Database Summary (6.0)
- Organization of this page
Overview
The Database Summary (6.0) 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 |
|
Drilldown reports (field level)
Report name |
Description |
---|---|
Blocked Sessions (6.0) |
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 (6.0) |
Displays information related to sessions that have locks that are blocking other sessions. To display this report, click the Blocking Locks field. |
Database Detail (6.0) |
Displays detailed information related to a particular database on Microsoft SQL Server. To display this report, click the DB Name field. |
Sessions (6.0) |
Displays information related to the statuses of all processes connected to Microsoft SQL Server. To display this report, click the Process Count field. |