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

ItemDefault valueChangeable
Collection Interval60Y
Collection Offset0Y
LogNoY
LOGIF(Blank)Y

ODBC key fields

Lifetime

From creation to deletion of a database

Record size

Fields

View name
(Manager name)
DescriptionSummaryFormatDeltaData source
Availability
(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.
COPYstring(16)Nomaster..sysdatabases.status
Blocked Processes
(BLOCKED)
Number of blocked processesCOPYwordNoTotal number of processes for which the master..sysprocesses.blocked value is not 0
Blocking Locks
(BLOCKING)
Number of blocking locksCOPYulongNoNumber of locks for which the master..syslockinfo.req_status value is 3 (standby)
Create Date
(CREATE_DATE)
Database creation dateCOPYtime_tNomaster..sysdatabases.crdate
DB Name
(DB_NAME)
Database nameCOPYstring(257)Nomaster..sysdatabases.name
DB Owner
(DBO)
Database ownerCOPYstring(513)NoName of the user for which master..sysdatabases.sid is equal to master..syslogins.sid
DBID
(DBID)
Database IDCOPYwordNomaster..sysdatabases.dbid
Demand Locks
(DEMAND)
Number of request locksCOPYulongNomaster..syslockinfo
Exclusive Intent Locks
(EXCLUSIVE_INTENT)
Number of exclusive intent locksCOPYulongNomaster..syslockinfo
Exclusive Page Locks
(EXCLUSIVE_PAGE)
Number of exclusive page locksCOPYulongNomaster..syslockinfo
Exclusive Table Locks
(EXCLUSIVE_TABLE)
Number of exclusive table locksCOPYulongNomaster..syslockinfo
Last Dump Date
(LAST_DUMP)
Last dump date for the transaction logCOPYtime_tNomsdb.dbo.backupset
Locks
(LOCKS)
Total number of locksCOPYulongNomaster..syslockinfo
Options
(OPTIONS)
Database options currently specified. Delimited by commas.COPYstring(512)Nomaster..sysdatabases.status, master..sysdatabases.status2
Other Processes
(OTHER)
Number of other types of processesCOPYwordNomaster..sysprocesses.status
Process Count
(PROCESSES)
Total number of processesCOPYwordNomaster..sysprocesses
Record Time
(RECORD_TIME)
Interval end time (GMT format)COPYtime_tNoRemote Monitor Collector
Record Type
(INPUT_RECORD_TYPE)
Record type (always DD)COPYchar(8)NoRemote Monitor Collector
Runnable Processes
(RUNNABLE)
Number of executable processesCOPYwordNomaster..sysprocesses.status
Running Processes
(RUNNING)
Number of processes being executedCOPYwordNomaster..sysprocesses.status
Shared Intent Locks
(SHARED_INTENT)
Number of shared intent locksCOPYulongNomaster..syslockinfo.rsc_type, master..syslockinfo.req_mode
Shared Page Locks
(SHARED_PAGE)
Number of shared page locksCOPYulongNomaster..syslockinfo.rsc_type, master..syslockinfo.req_mode
Shared Table Locks
(SHARED_TABLE)
Number of shared table locksCOPYulongNomaster..syslockinfo.rsc_type, master..syslockinfo.req_mode
Sleeping Processes
(SLEEPING)
Number of sleeping processesCOPYwordNomaster..sysprocesses.status
Start Time
(START_TIME)
Interval start time (GMT format)COPYtime_tNoRemote Monitor Collector
Update Page Locks
(UPDATE_PAGE)
Number of update page locksCOPYulongNomaster..syslockinfo.rsc_type, master..syslockinfo.req_mode
VA DeviceID(VADEVICEID)Device ID of virtual agent.--string(256)NoRemote Monitor Collector
Version
(VERSION)
Microsoft SQL Server version used for database creationCOPYwordNomaster..sysdatabases.version