Sybase ASE Storage Manager (Revision #14)

With the Sybase ASE 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. This includes Table Name, Schema, Segment, Type, Row Count, Reserved Size, Data Size, Index Size, Unused Size, Lock Type and Created Date.
• Index storage now includes Index Name, Index Type, Segment, Table Name, Index Size, Reserved Size, Unused Size, Data Size, Clustered, Unique 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 -> Sybase ASE DBA Tools -> Storage Manager

Below text goes to ADS 7.5 Documentation.

Table Name: Name of the database object
Schema Name: Owner of the table
Segment: Name of the table segment
Type: Whether Sytem or User Table
Row Count: Number of rows in the table
Reserved: reports the amount of space that has been allocated to all the tables that have been created in the database
Data: shows how much space has actually been used by data
Indexes: shows how much space has actually been used by indexes
Unused: shows the amount of space that has been reserved but not yet used by existing table
Created Date: Date on which the table was created
Lock Type: Lock Type of the table

Type = Index

Index Name: Name of the index object
Index Schema: Owner of the Index
Table Name: Name of the database object
Segment: Name of the table segment
Object Type: Whether Sytem or User Index
Row Count: Number of rows in the Index
Reserved: reports the amount of space that has been allocated to all the indexes that have been created in the database
Data: shows how much space has actually been used by data
Indexes: shows how much space has actually been used by indexes
Unused: shows the amount of space that has been reserved but not yet used by existingindex
Created Date: Date on which the index was created
Lock Type: Lock Type of  the index