Database Statistics and Details

The Databases window shows a variety of detailed statistics, including the status of active databases.

Note: In cluster configurations, the Global Databases table provides information about global databases, and the Local Databases tables provides information about local, temporary databases, grouped by cluster instance.

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.

Tabs in the Databases View
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.

Related tasks
Determining the Backup Status of a Database
Displaying Resources Used by a Database
Displaying Information About Segments Used by a Database