SQL Server Table Storage Monitoring


Initially miniDBA displays table storage data as a graph that displays each table based on its storage size with detailed information given in tooltips for each table. This makes it easy to get an appreciation for outstandingly large tables and where large disk space consumption is occuring.

SQL Server tables graph vizualisation
When the grid is selected more detailed table information is displayed which can be sorted by clicking column headers. Storage and also the number of partitions per table can be seen here.

Partitions

The top grid is table information and the lower grid displays table partition meta data for the selected table. Size, boundary values, filegroup and compression information is displayed for each partition.
Using the rows and data page columns the distribution of data for a table can be seen over each partition.
SQL Server tables grid data