SQL Server Table Growth


This alert works in conjunction with the SQL Server Table Size Collector alert in this same section. Please install that alert as a requirement for this alert. This alert will review the last 2 days of data from the collector alert (runs once a day) and calculate the growth of each table based on number of rows. You can use the thresholds in the alert to get warned when the number of rows in a table grows by more than 10% is a given day as an example.


To create this alert, click on Alerts > Manage Alerts tab and create a Custom Alert of type Custom SQL Alert - Multiple Numeric Return using the SQL Statement attached to this alert.