Database Detail (PD_DD)
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 |
ODBC key fields
Lifetime
From creation to deletion of a database
Record size
Fields
View name (Manager name) | Description | Summary | Format | Delta | Data source |
---|---|---|---|---|---|
Availability (AVAILABILITY) | Database status. The following values are valid:
| COPY | string(16) | No | master..sysdatabases.status |
Blocked Processes (BLOCKED) | Number of blocked processes | COPY | word | No | Total number of processes for which the master..sysprocesses.blocked value is not 0 |
Blocking Locks (BLOCKING) | Number of blocking locks | COPY | ulong | No | Number of locks for which the master..syslockinfo.req_status value is 3 (standby) |
Create Date (CREATE_DATE) | Database creation date | COPY | time_t | No | master..sysdatabases.crdate |
DB Name (DB_NAME) | Database name | COPY | string(257) | No | master..sysdatabases.name |
DB Owner (DBO) | Database owner | COPY | string(513) | No | Name of the user for which master..sysdatabases.sid is equal to master..syslogins.sid |
DBID (DBID) | Database ID | COPY | word | No | master..sysdatabases.dbid |
Demand Locks (DEMAND) | Number of request locks | COPY | ulong | No | master..syslockinfo |
Exclusive Intent Locks (EXCLUSIVE_INTENT) | Number of exclusive intent locks | COPY | ulong | No | master..syslockinfo |
Exclusive Page Locks (EXCLUSIVE_PAGE) | Number of exclusive page locks | COPY | ulong | No | master..syslockinfo |
Exclusive Table Locks (EXCLUSIVE_TABLE) | Number of exclusive table locks | COPY | ulong | No | master..syslockinfo |
Last Dump Date (LAST_DUMP) | Last dump date for the transaction log | COPY | time_t | No | msdb.dbo.backupset |
Locks (LOCKS) | Total number of locks | COPY | ulong | No | master..syslockinfo |
Options (OPTIONS) | Database options currently specified. Delimited by commas. | COPY | string(512) | No | master..sysdatabases.status, master..sysdatabases.status2 |
Other Processes (OTHER) | Number of other types of processes | COPY | word | No | master..sysprocesses.status |
Process Count (PROCESSES) | Total number of processes | COPY | word | No | master..sysprocesses |
Record Time (RECORD_TIME) | Interval end time (GMT format) | COPY | time_t | No | Remote Monitor Collector |
Record Type (INPUT_RECORD_TYPE) | Record type (always DD) | COPY | char(8) | No | Remote Monitor Collector |
Runnable Processes (RUNNABLE) | Number of executable processes | COPY | word | No | master..sysprocesses.status |
Running Processes (RUNNING) | Number of processes being executed | COPY | word | No | master..sysprocesses.status |
Shared Intent Locks (SHARED_INTENT) | Number of shared intent locks | COPY | ulong | No | master..syslockinfo.rsc_type, master..syslockinfo.req_mode |
Shared Page Locks (SHARED_PAGE) | Number of shared page locks | COPY | ulong | No | master..syslockinfo.rsc_type, master..syslockinfo.req_mode |
Shared Table Locks (SHARED_TABLE) | Number of shared table locks | COPY | ulong | No | master..syslockinfo.rsc_type, master..syslockinfo.req_mode |
Sleeping Processes (SLEEPING) | Number of sleeping processes | COPY | word | No | master..sysprocesses.status |
Start Time (START_TIME) | Interval start time (GMT format) | COPY | time_t | No | Remote Monitor Collector |
Update Page Locks (UPDATE_PAGE) | Number of update page locks | COPY | ulong | No | master..syslockinfo.rsc_type, master..syslockinfo.req_mode |
VA DeviceID(VADEVICEID) | Device ID of virtual agent. | -- | string(256) | No | Remote Monitor Collector |
Version (VERSION) | Microsoft SQL Server version used for database creation | COPY | word | No | master..sysdatabases.version |