Database Detail (8.0)

Organization of this page

Overview
Storage location
Record
Fields

Overview

The Database Detail (8.0) 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.

To Page Top

Storage location

Reports/SQL/Troubleshooting/Real-Time/Drilldown Only/

To Page Top

Record

Database Detail (PD_DD)

To Page Top

Fields

Field name	Description
Availability	Database 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 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 2014 or earlier: Microsoft SQL Server version used for database creation Microsoft SQL Server version 2016 or later: Value indicating the version of Microsoft SQL Server with operational compatibility

To Page Top