Database Summary

Overview

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.

Storage location

Reports/RM SQLServer/Troubleshooting/Real-Time/

Record

Database Detail (PD_DD)

Fields

Field nameDescription
AvailabilityDatabase 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 ProcessesNumber of blocked processes
Blocking LocksNumber of blocking locks
Create DateDatabase creation date
DB NameDatabase name
DB OwnerDatabase owner
DBIDDatabase ID
Last Dump DateLast dump date for the transaction log
LocksTotal number of locks
Process CountTotal number of processes
VersionMicrosoft SQL Server version used for database creation

Drilldown reports (field level)

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