Skip to main content
< All Topics
Print

Table sizes dashboard

The Table sizes dashboard shows the data size, number of rows and index space used for each table in each database on each server:

Analysis is made on the tables growth patterns, and predictions can be seen on the dashboard as well:

If a production database is having a table with more than 1 million rows and an increase in the number of rows of more than 20 %, this alert is raised. This will raise the High row count change alert.

Corresponding views in the Performance Store database:
dbo.v_table_sizes
dbo.v_table_predictions
dbo.v_table_sizes_aggregated
dbo.v_table_sizes_current

Other relevant views in the Performance Store database:
dbo.v_table_size_changes

Table of Contents