3,600 Metrics install automatically if you have SQL Monitor installed.
If you are using Redgate’s SQL Server monitoring tool, SQL Monitor, you can instantly install and run this metric on your servers.
This custom metric measures the total database file size (data files and log file combined).
An increase in this metric signals that a database was grown. When not done by the DBA, this is an autogrow.
Excessive autogrow events should be prevented as this can result to file fragmentation. Try to manually grow files before autogrow kicks in. If despite active file size management this metric detects a change, a database is probably growing at an unexpected rate.
Metric definition
Name
Total database file size
Description
This custom metric measures the total database file size (data files and log file combined).
The T-SQL query that will collect data
Instances to collect from
Select all
Databases to collect from
All
Collection frequency
30
Use collected or calculated values
Check the Use a calculated rate of change between collections check box
Metric collection
Enabled
Alert definition
Alert name
Database size increase
Description
Raise an alert when the metric value goes
above the defined threshholds
Default threshold values
| High: | 25 |
| Medium: | 10 |
| Low: | 0 |
Raise an alert when the threshold is passed for
collections
Alert is
Enabled
