Database Detail
Overview
The Database Detail report displays detailed information related to a particular database on Microsoft SQL Server. This report is displayed as a list. This is a drilldown report.
Storage location
Reports/RM SQLServer/Troubleshooting/Real-Time/Drilldown Only/
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 |
Demand Locks | Number of request locks |
Exclusive Intent Locks | Number of exclusive intent locks |
Exclusive Page Locks | Number of exclusive page locks |
Exclusive Table Locks | Number of exclusive table locks |
Last Dump Date | Last dump date for the transaction log |
Locks | Total number of locks |
Options | Database option |
Other Processes | Number of other types of processes |
Process Count | Total number of processes |
Runnable Processes | Number of executable processes |
Running Processes | Number of processes being executed |
Shared Intent Locks | Number of shared intent locks |
Shared Page Locks | Number of shared page locks |
Shared Table Locks | Number of shared table locks |
Sleeping Processes | Number of sleeping processes |
Update Page Locks | Number of update page locks |
Version | Microsoft SQL Server version used for database creation |