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.

Item	Default value	Changeable
Collection Interval	60	Y
Collection Offset	0	Y
Log	No	Y
LOGIF	(Blank)	Y

• PD_DD_DB_NAME
• PD_DD_DBID

From creation to deletion of a database

• Fixed part: 681 bytes
• Variable part: 1,362 bytes

View name (Manager name)	Description	Summary	Format	Delta	Data 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.	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