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.

Total database file size, 5.0 out of 5 based on 2 ratings

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