SQL Server Storage Manager (Revision #8)

With Aqua Data Studio 7.5 you can plan, initialize, allocate, manage, and tune MSSQL Server database objects for better performance

New enhanced Object Tab in Aqua Data Studio 7.5 gives:

• Detailed information of Segments
• High-level storage information of Tables which helps in tracking growth
• Index storage that now includes Index Type, Size, Rows, Validity and Created Date. You can quickly identify whether indexes are not created on Tables participating in SQL Queries
• Overall Object Storage information. You can sort and quickly identify which Table or Index takes up more space. You can configure Storage and eliminate wasted storage

Object Tab - Display of the Tables and Indexes.

Documentation -> Sybase ASE DBA Tools -> Storage Manage

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