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 metric measures the number of available autogrowth steps for a database, so you can see when they are reduced or increased because something else (e.g. another database) starts or stops taking up space, when storage is added, etc.
With appropriate thresholds set on the associated alert, you will be notified when the number of available steps gets too low.Database growth steps available,
Database growth steps available
This metric calculates the number of autogrowth steps available for a database at a given time. It does this from a database file level, taking into account:
- database file’s current size
- database file’s max size
- growth info (is growth allowed, is growth unlimited, is growth flat or percentage based, growth step size in MB or percent)
- free space for each drive where database files are located
The final number of available steps is the sum of available steps for each database data file.
The T-SQL query that will collect data
Instances to collect from
Type the name of the instance containing the database you want to monitor
Databases to collect from
the name of the database you want to monitor
Use collected or calculated values
Leave the Use a calculated rate of change between collections check box unchecked
Database growth steps available low
Raise an alert when the metric value goes
Below the defined threshholds
Default threshold values
Note: These thresholds are intended as guideline values. If they seem too high or too low, replace them with values more suited to your environment.
Raise an alert when the threshold is passed for