buck.woody

LinkedIn | FaceBook | Twitter

Resume

 Professional Blog Personal Blog Podcasts Articles University of Washington
SQL Server Management Studio Standard Reports – Disk Usage by Table/Top Tables - Carpe Datum - Site Home - MSDN Blogs

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

Common Tasks
Search
  • Advanced search options...
Tags
Archives
Archives
MSDN Blogs > Carpe Datum > 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
14 Dec 2007 10:54 AM
  • 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 8 and 8 and type the answer here:
  • Post
Comments
  • rtorres
    5 Oct 2010 8:39 AM

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

  • Buck Woody
    5 Oct 2010 8:41 AM

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

  • Dena
    17 Nov 2010 2:54 PM

    you can't be in 2000 compatibility mode either

  • Pete
    28 Feb 2011 6:25 PM

    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?

  • 3 Mar 2011 1:04 PM

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

  • Barbara
    27 Jan 2012 1:05 PM

    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)