Database Detail (PD_DD)
- Organization of this page
Function
The Database Detail (PD_DD) record indicates database information (snapshot), such as the numbers of locks and processes, related to a particular database. One record is created for each database. This is a multi-instance record.
Default and changeable values
Item |
Default value |
Changeable |
---|---|---|
Collection Interval |
60 |
Y |
Collection Offset |
0 |
Y |
Log |
No |
Y |
LOGIF |
(Blank) |
Y |
Over 10 Sec Collection Time |
No |
N |
ODBC key fields
-
PD_DD_DB_NAME
-
PD_DD_DBID
Lifetime
From creation to deletion of a database
Record size
-
Fixed part: 937 bytes
-
Variable part: 1,372 bytes
Fields
View name (Manager name) |
Description |
Summary |
Format |
Delta |
Data source |
|
---|---|---|---|---|---|---|
Microsoft SQL Server version 2014 or earlier |
Microsoft SQL Server version 2016 or later |
|||||
Availability (AVAILABILITY) |
Database status. The following values are valid:
|
-- |
string(16) |
No |
master..sysdatabases.status |
sys.databases.state |
Blocked Processes (BLOCKED) |
Number of blocked processes |
-- |
word |
No |
Total number of processes for which the master..sysprocesses.blocked value is not 0 |
Total number of processes for which the sys.dm_exec_requests.blocking_session_id value is not 0 |
Blocking Locks (BLOCKING) |
Number of blocking locks |
-- |
ulong |
No |
Number of locks for which the master..syslockinfo.req_status value is 3 (standby) |
Number of locks for which the sys.dm_tran_locks.request_status value is WAIT, LOW_PRIORITY_WAIT, or ABORT_BLOCKERS |
Create Date (CREATE_DATE) |
Database creation date |
-- |
time_t |
No |
master..sysdatabases.crdate |
sys.databases.create_date |
DB Name (DB_NAME) |
Database name |
-- |
string(257) |
No |
master..sysdatabases.name |
sys.databases.name |
DB Owner (DBO) |
Database owner |
-- |
string(513) |
No |
Name of the user for which master..sysdatabases.sid is equal to master..syslogins.sid |
Name of the user for which sys.databases.owner_sid is equal to sys.server_principals.sid |
DBID (DBID) |
Database ID |
-- |
ulong |
No |
master..sysdatabases.dbid |
sys.databases.database_id |
Demand Locks (DEMAND) |
Number of request locks |
-- |
ulong |
No |
master..syslockinfo |
sys.dm_tran_locks |
Exclusive Intent Locks (EXCLUSIVE_INTENT) |
Number of exclusive intent locks |
-- |
ulong |
No |
master..syslockinfo |
sys.dm_tran_locks |
Exclusive Page Locks (EXCLUSIVE_PAGE) |
Number of exclusive page locks |
-- |
ulong |
No |
master..syslockinfo |
sys.dm_tran_locks |
Exclusive Table Locks (EXCLUSIVE_TABLE) |
Number of exclusive table locks |
-- |
ulong |
No |
master..syslockinfo |
sys.dm_tran_locks |
Last Dump Date (LAST_DUMP) |
Last dump date for the transaction log |
-- |
time_t |
No |
msdb.dbo.backupset |
|
Locks (LOCKS) |
Total number of locks |
-- |
ulong |
No |
master..syslockinfo |
sys.dm_tran_locks |
Options (OPTIONS) |
Database options currently specified. Delimited by commas. |
-- |
string(512) |
No |
master..sysdatabases.status, master..sysdatabases.status2 |
sys.databases |
Other Processes (OTHER) |
Number of other types of processes |
-- |
word |
No |
master..sysprocesses.status |
sys.dm_exec_sessions.status |
Process Count (PROCESSES) |
Total number of processes |
-- |
word |
No |
master..sysprocesses |
sys.dm_exec_sessions |
Record Time (RECORD_TIME) |
Interval end time (GMT format) |
-- |
time_t |
No |
Remote Monitor Collector |
|
Record Type (INPUT_RECORD_TYPE) |
Record type (always DD) |
-- |
char(8) |
No |
Remote Monitor Collector |
|
Runnable Processes (RUNNABLE) |
Number of executable processes |
-- |
word |
No |
master..sysprocesses.status |
sys.dm_exec_sessions.status |
Running Processes (RUNNING) |
Number of processes being executed |
-- |
word |
No |
master..sysprocesses.status |
sys.dm_exec_sessions.status |
Shared Intent Locks (SHARED_INTENT) |
Number of shared intent locks |
-- |
ulong |
No |
master..syslockinfo.rsc_type, master..syslockinfo.req_mode |
sys.dm_tran_locks.resource_type, sys.dm_tran_locks.request_mode |
Shared Page Locks (SHARED_PAGE) |
Number of shared page locks |
-- |
ulong |
No |
master..syslockinfo.rsc_type, master..syslockinfo.req_mode |
sys.dm_tran_locks.resource_type, sys.dm_tran_locks.request_mode |
Shared Table Locks (SHARED_TABLE) |
Number of shared table locks |
-- |
ulong |
No |
master..syslockinfo.rsc_type, master..syslockinfo.req_mode |
sys.dm_tran_locks.resource_type, sys.dm_tran_locks.request_mode |
Sleeping Processes (SLEEPING) |
Number of sleeping processes |
-- |
word |
No |
master..sysprocesses.status |
sys.dm_exec_sessions.status |
Start Time (START_TIME) |
Interval start time (GMT format) |
-- |
time_t |
No |
Remote Monitor Collector |
|
Trans (TRANS) |
Total number of transactions |
-- |
double |
No |
master..sysperfinfo.transactions/sec |
sys.dm_os_performance_counters.transactions/sec |
Update Page Locks (UPDATE_PAGE) |
Number of update page locks |
-- |
ulong |
No |
master..syslockinfo.rsc_type, master..syslockinfo.req_mode |
sys.dm_tran_locks.resource_type, sys.dm_tran_locks.request_mode |
VA DeviceID(VADEVICEID) |
Device ID of virtual agent. |
-- |
string(256) |
No |
Remote Monitor Collector |
|
Version (VERSION) |
|
-- |
word |
No |
master..sysdatabases.version |
sys.databases.compatibility_level |