SQL Server Management Studio Standard Reports – Disk Usage by Table/Top Tables
I'm continuing my series on the Standard Reports in SQL Server Management Studio. I’m covering two reports at once, since they have the same columns and output, but show the data from a different perspective. These two reports will help you find out the size and shape of your tables. You might have a table with quite a few rows that actually doesn’t take a lot of disk space, and another that has fewer rows might take more space. These reports help you sort that out.
These are database-level reports and you can find them by starting SQL Server Management Studio and right-clicking a database name. From the menu that appears, click the Standard Reports, and then select either of them.
Here are the columns you’ll get in these reports:
|Table Name||The name of the schema and the table|
|# Records||The number of records in the table|
|Reserved (KB)||How much contiguous space is reserved for the table|
|Data (KB)||The number of Kilobytes of data in the table|
|Indexes (KB)||The number of Kilobytes of index space in the table|
|Unused (KB)||The number of Kilobytes left in the space allotted for the table|