SQL Server Management Studio Standard Reports – Disk Usage by Table/Top Tables

SQL Server Management Studio Standard Reports – Disk Usage by Table/Top Tables

Rate This
  • Comments 6
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:

Column Description
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

Leave a Comment
  • Please add 7 and 6 and type the answer here:
  • Post
  • I right click on one of my user dbs and I don't see that option.  Do you have to have ssrs installed, perhaps?

  • rtorres - no, but you do need SSMS 2005 SP2 or higher.

  • you can't be in 2000 compatibility mode either

  • When i select a standard report - i don't get the report for that database. Most reports on any database seem to  point back to the same database - Is there a way to edit the standard reports?

  • Pete - you can't edit the standard ones, but you can create your own.

  • I have a default database defined on my registered servers.  We are finding that the Disk Usage by Table then appears to only work for the default database although the title of the report will indicate the database that you right click on.  Sounds like a bug to me, you shouldn't have to change your default database to default for this report to run.

Page 1 of 1 (6 items)