The Databases window shows a variety of detailed statistics, including the status of active databases.
The Databases table lists the databases in the current server by name. If a database is unavailable, for example, because it is quiesced or is offline, the Name column includes the reason.
The Databases table lists the type, durability, and DML logging status for each database. The Databases table also includes for each database, the ID, and current status information, backup status, whether the transaction log is full, and whether there are suspended processes. Processes may be suspended when the transaction log fills up.
The type of database is indicated for temporary, in-memory, proxy and archive databases, and left blank for all other databases. The Durability column indicates if a database is recoverable.
The tabs at the bottom of the screen display information about the selected database. For a large database, it might take 30 seconds or more for the information to appear.
| Details | Displays information about space
usage, including pie charts for data segments and log segments. If
this database does not have a log segment, the pie chart on the
right shows combined data and log segment usage. In SAP ASE version 15.7 ESD #3, "Other" displays the space usage for the object allocation map (OAM). For more information about OAM, see the System Administration Guide: Volume 2. |
| Running Processes | Displays information about
processes that are currently using this database, including the
process ID, login, host, command, and transaction name. Click a process ID in the SPID column to switch to the Processes view’s information about that process. |
| Devices Used | Displays information about devices
on which this database stores its data, including the device name,
the amount of space used on that device, and the usage allocation
(data or log). Click a device in the Name column to switch to the Devices view’s information about that device. |
| Segments Used | Displays information about
segments used by this database, including the segment name, the size
of the segment in megabytes, and the amount of free space in the
segment. Click a segment in the Name column to switch to the Segments view's information about that segment. |
| Unused Indexes | Lists indexes in this database that have not been used since the server was last restarted. |
| Frequently Used Tables | Displays information about tables in this database that have been used since the server was last restarted, including the table name, index ID, logical and physical reads, lock requests and waits, and contention statistics. |
The Local Temporary Databases screen provides information about local, temporary databases grouped by cluster instances. For each cluster instance, SAP Control Center lists the ID and current status information, including backup status; whether the transaction log is full, and whether there are suspended processes.
The tabs at the bottom of the Local Temporary Databases screen display information about the selected database. Click the Temporary Database Activity tab to see information about log requests and wait status, device read and write values, and charts depicting I/O activity in the selected temporary database.