Total database file size

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 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

This alert is raised when the total size of the database files has increased. 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.

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