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, right-click the server to monitor 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.