View disk usage, running processes, unused indexes, and devices and segments associated with an Adaptive Server database.
-
In the Perspective Resources view, right-click the server to monitor and select Monitor.
-
In the left pane, select Databases.
You can also display the Databases screen by clicking a Databases link from a different window in the Adaptive Server monitor.
-
Select a database in the Databases table.
The tabs at the bottom of the screen are populated with information on the database you selected.
Note: When you select a database, Sybase Control Center calculates space usage before displaying any data, and this may take 30 seconds or more for a large database.
-
Click a tab to see information about the resource you are interested in:
-
Details – shows disk usage, including the size of reserved and unreserved data and log segments.
-
Running Processes – shows the server process ID (spid), login, host, command, and transaction for each process that is currently using the database. Each spid number is a link; click it to see more information about that process.
-
Devices Used – shows the size and usage allocation (data or log) for each device that provides storage for this database. Each device name is a link; click it to see more information about that device.
-
Segments Used – shows the size and unused portion of each segment, in megabytes. Each segment name is a link; click it to see more information about that segment.
-
Unused Indexes – shows the name and table of each unused index.
-
Frequently Used Tables – shows usage statistics for frequently used tables.