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:
- Carrying out index maintenance – see http://www.mssqltips.com/sqlservertip/1339/sql-server-index-maintenance-checklist/
- Data partitioning – see http://www.mssqltips.com/sqlservertip/1200/handling-large-sql-server-tables-with-data-partitioning/
Metric definition
Name
Table size (MB)
Description
The size in Megabytes of a specific table.
The T-SQL query that will collect data