SQL Table Growth Test
Periodic monitoring of the usage of the database is essential to ensure that the database is always adequately sized to handle current and future loads. It is also essential to monitor the size of the tables within a database too. If the growth of any table is uncontrollable, then, other tables in the database may be deprived of space to store critical data. The SQL Table Growth test helps administrators in figuring out the exact tables that have been growing beyond a pre-configured size. Using this test administrators can isolate the tables that have been growing uncontrollably and analyze if those tables need to be resized.
This test monitors the tables on the target Microsoft SQL Database server and reports the count of tables that have been growing beyond a pre-configured size. This test also reveals the maximum size up to which the tables can grow.
This test is disabled by default. To enable the test, go to the enable / disable tests page using the menu sequence : Agents -> Tests -> Enable/Disable, pick Microsoft SQL as the Component type, Performance as the Test type, choose this test from the disabled tests list, and click on the << button to move the test to the ENABLED TESTS list. Finally, click the Update button.
Target of the test : A Microsoft SQL server
Agent deploying the test : An internal agent
Outputs of the test : One set of results for the Microsoft SQL server monitored.
|
Measurement | Description | Measurement Unit | Interpretation |
---|---|---|---|
Large tables count |
Indicates the total number of tables that have grown beyond the limit specified against the TABLE GROWTH SIZE parameter. |
Number |
|
Max table growth size |
Indicates the maximum size up to which the tables continued to grow during the last measurement period. |
MB |
The detailed diagnosis of this measure lists the tables that continued to grow and the size of the tables. |
Max table growth |
Indicates the maximum growth of a table in terms of percentage. |
Percent |
Use the detailed diagnosis to figure out the tables that recorded the maximum growth. |