Database Detail (PD_DD)

Collection Interval

60

Y

Collection Offset

0

Y

Log

No

Y

LOGIF

(Blank)

Y

Over 10 Sec Collection Time

No

N

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.

--

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)

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

--

word

No

master..sysdatabases.version

sys.databases.compatibility_level