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 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
Demand LocksNumber of request locks
Exclusive Intent LocksNumber of exclusive intent locks
Exclusive Page LocksNumber of exclusive page locks
Exclusive Table LocksNumber of exclusive table locks
Last Dump DateLast dump date for the transaction log
LocksTotal number of locks
OptionsDatabase option
Other ProcessesNumber of other types of processes
Process CountTotal number of processes
Runnable ProcessesNumber of executable processes
Running ProcessesNumber of processes being executed
Shared Intent LocksNumber of shared intent locks
Shared Page LocksNumber of shared page locks
Shared Table LocksNumber of shared table locks
Sleeping ProcessesNumber of sleeping processes
Update Page LocksNumber of update page locks
VersionMicrosoft SQL Server version used for database creation