Database growth steps available

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.

Install metric...

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, 5.0 out of 5 based on 6 ratings

Metric definition

Name

Database growth steps available

Description

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

Collection frequency

300

Use collected or calculated values

Leave the Use a calculated rate of change between collections check box unchecked

Metric collection

Enabled

Alert definition

Alert name

Database growth steps available low

Description

Raised when the number of available autogrowth steps gets too low.

Raise an alert when the metric value goes

Below the defined threshholds

Default threshold values

High:1
Medium:3
Low:5

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

1 collection

Alert is

Enabled