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 name | Description |
---|---|
Availability | Database status. The following values are valid:
|
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 |
Drilldown reports (field level)
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. |