Microsoft Dynamics Ax – large tables

February 18th, 2010 by Stephen Jones Leave a reply »

To check which tables occupy the most space in your database Microsoft Dynamics Ax
has an out-of-the box report . Admin – Reports – Size of company accounts, which gives detailed on all the database tables, with a record count and an estimated size used.

Lookout for not so obvious suspects responsible for excessive growth in database volume. Like table SysTraceTableSQL This system table stores information about trace events. You can purge the old data in table after you’ve finished analyzing it.

(Note: that deleting a table of several gigabyte in one step might stall your database server.)


Leave a Reply

You must be logged in to post a comment.