Microsoft Dynamics GP is an ERP system and as such, owners intend to push as much data from their organization as they can through this one centralized system. Managing the size of the database can be difficult. The most important question is: What tables are getting large and what is stored in them? For this most important question our clients use the Table Size Inquiry window.
The information returned includes record count, data size, the long descriptive name of the table, the physical name of the table, and how much space is dedicated unused space. Armed with this information our administrators can more easily choose the type of file routines in which they engage that can reduce and offload transaction data from their ERP system.
By Shane LaBarge, CPA, MBS, MSIS, Dynamics GP Consultant, Avastone Technologies LLC,