SQL Server Storage Manager (Revision #16)

With the SQL Server Storage Manager you can now use the "Object" tab to view the storage information of table and indexes for capacity planning.

The new enhanced Object tab in displays:

• Detailed information of Tables and Indexes.
• High-level storage information of Tables which helps in tracking growth.
• Index storage now includes Index Type, Size, Rows, Validity and Created Date.
• Overall Object Storage information. You can sort and quickly identify which Table or Index takes up more space.

Object Tab - Display of the Tables and Indexes.

Table Objects	Index Objects

Documentation -> MS SQL DBA Tools -> Storage Manager

Object Name: Name of the database object
Owner: Owner of the Table
Filegroup: ?
Row Count: Total number of rows in the table
Table Size: Total Size occupied by the table
Reserved Size: Space reserved for the table
Data Size: Total size of data
Unused Size: Total unused space
Index Size: Space used by Indexes in that table

Type = Index

Schema: Owner of the Table
Table Name:
Filegroup: ?
Object Type: Whether System or User Index
Reserved Size: Space reserved for the Index
Used Size: Total used space
Index Size: Space used by Indexes