Percentage of used/available database space

This metric measures the ratio between used database space and total available space, also taking into account current size, maximum size and the amount of free space for each drive. The values collected help you maintain control over the database storage area, and monitor database growth in combination with general space management on a database file's host.

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 ratio between used database space and total available space, taking into account the following database file metrics:

  • current used space
  • current size
  • maximum size
  • free space for each drive where database files are located

The actual available space per drive is calculated first, followed by the sum of the total used space from drives and the total available space from drives. These values are then used to calculate the global percentage.

The metric helps you to maintain control over the database storage area, and monitor database growth in combination with general space management on a database file’s host. If available space decreases or increases because something else in your environment, such as another database, starts or stops taking up space, you may want to analyze this further. You are also alerted when the percentage increases signficantly.

Percentage of used/available database space, 4.7 out of 5 based on 10 ratings

Metric definition

Name

Percentage of used/available database space

Description

This metric measures the ratio between used database space and total available space, taking into account the database file's current used space, current size, maximum size, and free space for each drive where database files are located. The actual available space per drive is calculated first, followed by the sum of the total used space from drives and the total available space from drives. These values are then used to calculate the global percentage. The metric helps you to help you maintain control over the database storage area, and monitor database growth in combination with general space management on a database file's host. If available space decreases or increases because something else in your environment, such as another database, starts or stops taking up space, you may want to analyze this further. You are also alerted when the percentage increases signficantly.

The T-SQL query that will collect data

Instances to collect from

Select the instance that contains the database you’re interested in.

Databases to collect from

0

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

Used/available database space increased

Description

Raised when the fill percentage exceeds a specified threshold. The metric on which this alert is based measures the ratio between used database space and total available space, taking into account the database file's current used space, current size, maximum size, and free space for each drive where database files are located. The actual available space per drive is calculated first, followed by the sum of the total used space from drives and the total available space from drives. Those values are then used to calculate the global percentage. It is best practice to monitor database growth in combination with general space management on a database file's host. If available space decreases or increases because something else in your environment (for example, another database) starts or stops taking up space, you may want to analyze this further.

Raise an alert when the metric value goes

Above the defined threshholds

Default threshold values

High:90
Medium:80
Low:70

Note: These thresholds are intended as guideline values. If they seem too high or too low for your environment, replace them with values more suited to your server performance.

Raise an alert when the threshold is passed for

1 collection

Alert is

Enabled