Table size (MB)

This metric is useful if you want to know exactly how much physical space a particular table is taking up, including the size of its indexes.

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 is useful if you want to know exactly how much physical space a particular table is taking up, including the size of its indexes. If a database is growing quickly within a short time and you suspect a certain table is responsible, you can monitor its actual size, or the rate at which it is increasing.

If you have a particularly large table affecting performance, you may consider:

Table size (MB), 4.1 out of 5 based on 10 ratings

Metric definition

Name

Table size (MB)

Description

The size in Megabytes of a specific table.

The T-SQL query that will collect data