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:

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

Comments (6)

  1. rtorres says:

    I right click on one of my user dbs and I don't see that option.  Do you have to have ssrs installed, perhaps?

  2. Buck Woody says:

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

  3. Dena says:

    you can't be in 2000 compatibility mode either

  4. Pete says:

    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?

  5. BuckWoody says:

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

  6. Barbara says:

    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.

Skip to main content