Database Summary

Job Management Partner 1 Version 10, Job Management Partner 1/Performance Management - Remote Monitor for Microsoft(R) SQL Server Description, User's Guide and Reference

The Database Summary report displays detailed information related to the statuses of all databases in Microsoft SQL Server. This report is displayed as a table. From the displayed report, you can display more detailed drilldown reports.

Field name	Description
Availability	Database status. The following values are valid: Active Enabled. Process is running. Available Enabled. No process is running. NOT Available A crash or problem may have occurred during loading, and as a result the database cannot be opened or used in its current state. Restricted Database can be used only by its owner or a single user.
Blocked Processes	Number of blocked processes
Blocking Locks	Number of blocking locks
Create Date	Database creation date
DB Name	Database name
DB Owner	Database owner
DBID	Database ID
Last Dump Date	Last dump date for the transaction log
Locks	Total number of locks
Process Count	Total number of processes
Version	Microsoft SQL Server version used for database creation

Report name	Description
Blocked Sessions	Displays the information related to sessions that are waiting for lock release by other sessions. To display this report, click the Blocked Processes field.
Blocking Locks	Displays information related to sessions that have locks that are blocking other sessions. To display this report, click the Blocking Locks field.
Database Detail	Displays detailed information related to a particular database on Microsoft SQL Server. To display this report, click the DB Name field.
Sessions	Displays information related to the statuses of all processes connected to Microsoft SQL Server. To display this report, click the Process Count field.