Database Statistics

Owned by Dennis Waehner
Jul 31, 2023

Click "Database Statistics..." from the Database tab to view and manage database statistics of the ACM database.

The top grid shows the current overall status of the ACM database.  This screen is a quick view into the database configuration and how much memory is available.  The sizes listed in this table all are recorded in Megabytes (MB).

Table Column Meanings:

  • Name:  This is the logical name of the file in the database.
  • File ID: This is the ID of the file within the database.
  • Size: This is the current size of the file.
  • Available: This is the amount of space available.
  • Used: This is the amount of space used by the database.
  • % Used: This is the percentage of the total size that is in use.
  • Growth: This field shows if the database file is set to automatically grow.
  • Max Size: This shows the maximum size to which the database is allowed to grow. **This does not mean the computer can support the maximum size.**
  • Gr Rate: If the database is set to grow, this is the rate at which it grows. This can be set to a percentage or an absolute growth rate.

Storage Stats

Click to view the storage statics for the tables within the ACM database.

This form contains the ACM Detail Table which is a comprehensive break down of how much memory each individual table is using in the database. 

Table Column Meanings:

  • Table Name : This is the name of the table.
  • Row Cnt: This is the number of rows in the table.
  • Total Size: This is the total amount of space reserved for the table.
  • Data Size: This is the total amount of space used by the table.
  • Index Size: This is the total amount of space used by all indexes for the table.

Save As

Use the "Save As" button at the top to save the information in the table as CSV, Excel, PDF or HTML.

  • CSV:  This is a plain comma delimited text file, that will include the header of the table.
  • Excel: This will save the table in .xls format, including all table coloring.
  • PDF: This will save the table in .pdf format, including all table coloring and format.
  • HTML: This will save the table in .html format without coloring.

Index Statistics

Clicking the "Index Stats" button will bring up the SQL Index Monitor. View the SQL Index Monitor section for more details.

For assistance, please submit a ticket via our Support Portal, email autosol.support@autosoln.com or call 281.286.6017 to speak to a support team member.