Space used by database objects

Install metric...

Metrics install automatically if you have Redgate Monitor installed.

If you are using Redgate’s SQL Server monitoring tool, Redgate Monitor, you can instantly install and run this metric on your servers.

This metric reports the total space used by database files in GB. This includes data files but excludes log files.

This lets you track the growth of the databases over time so you can be aware of future space requirements.

Alternatively, the following T-SQL can be used for SQL Server 2012 and higher:

Metric definition


Space used by Database objects in GB


Monitors the total space used by data files in the database. This excludes log files.

The T-SQL query that will collect data

Instances to collect from

The instance that contains the database you're interested in.

Databases to collect from

The database you're interested in.

Collection frequency


Use collected or calculated values

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

Metric collection


Alert definition

An alert is not required