Displaying Resources Used by a Database

View disk usage, running processes, unused indexes, and devices and segments associated with an Adaptive Server database.

1. In the Perspective Resources view, select the server to monitor, click the drop-down arrow, and select Monitor.
2. 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.
3. 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.
4. 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.