Process Detail (PD_PDET)
- Organization of this page
Function
The Process Detail (PD_PDET) record indicates detailed information on a particular database process, such as locks and I/O. One record is created for each database process. 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 field
PD_PDET_SPID
Lifetime
From the start until stop of a process
Record size
-
Fixed part: 681 bytes
-
Variable part: 1,174 bytes
Fields
View name (Manager name) |
Description |
Summary |
Format |
Delta |
Data source |
|
---|---|---|---|---|---|---|
SQL Server version 2014 or earlier |
SQL Server version 2016 or later |
|||||
Blocked Processes (BLOCKING) |
Number of processes blocked by the process |
-- |
word |
No |
master..sysprocesses.blocked |
sys.dm_exec_requests.blocking_session_id |
Blocking Process (BLOCKED) |
Process ID of a blocking process, if any |
-- |
word |
No |
master..sysprocesses.blocked |
sys.dm_exec_requests.blocking_session_id |
CPU % (PERC_CPU) |
CPU time being used by the process, as a percentage of the CPU time being used by all database processes This field cannot display correct value. |
-- |
double |
No |
master..sysprocesses.cpu |
sys.dm_exec_sessions.cpu_time, sys.dm_exec_requests.cpu_time |
CPU Timeticks (CPU) |
Cumulative CPU time of the process (in ticks) This field cannot display correct value. |
-- |
ulong |
No |
master..sysprocesses.cpu |
sys.dm_exec_sessions.cpu_time, sys.dm_exec_requests.cpu_time |
Command (COMMAND) |
Name of the command executed |
-- |
string(33) |
No |
master..sysprocesses.cmd |
dm_exec_requests.Command |
DB Name (DB_NAME) |
Name of the database being used by the process at the time of record acquisition |
-- |
string(257) |
No |
db_name(master..sysprocesses.dbid) |
db_name(sys.dm_exec_sessions.database_id) |
DBID (DBID) |
Database ID being used by the process at the time of record acquisition |
-- |
ulong |
No |
master..sysprocesses.dbid |
sys.dm_exec_sessions.database_id |
GID (GID) |
This field is reserved and cannot be used. |
-- |
-- |
-- |
-- |
|
Host (HOST) |
Host computer name |
-- |
string(257) |
No |
master..sysprocesses.hostname |
sys.dm_exec_sessions.host_name |
Host PID (HOST_PID) |
Host process ID |
-- |
long |
No |
master..sysprocesses.hostprocess |
sys.dm_exec_sessions.host_process_id |
Locks (LOCKS) |
Number of locks being requested by the process at the time of record acquisition |
-- |
long |
No |
master..syslockinfo.req_spid |
sys.dm_tran_locks.request_session_id |
Mem Usage (MEMUSAGE) |
|
-- |
double |
No |
master..sysprocesses.memusage |
sys.dm_exec_sessions.memory_usage |
Physical I/O (PHYSICAL_IO) |
Cumulative number of times the process executed read/write operations to disks |
-- |
double |
No |
master..sysprocesses.physical_io |
sys.dm_exec_sessions.reads, sys.dm_exec_sessions.writes, sys.dm_exec_requests.reads, sys.dm_exec_requests.writes |
Program (PROGRAM) |
Application program name |
-- |
string(257) |
No |
master..sysprocesses.program_name |
sys.dm_exec_sessions.program_name |
Record Time (RECORD_TIME) |
Interval end time (GMT format) |
-- |
time_t |
No |
Agent Collector |
|
Record Type (INPUT_RECORD_TYPE) |
Record type (always PDET) |
-- |
char(8) |
No |
Agent Collector |
|
SPID (SPID) |
Process ID |
-- |
word |
No |
master..sysprocesses.spid |
sys.dm_exec_sessions.session_id |
Start Time (START_TIME) |
Interval start time (GMT format) |
-- |
time_t |
No |
Agent Collector |
|
Status (STATUS) |
Process status |
-- |
string(61) |
No |
master..sysprocesses.status |
sys.dm_exec_sessions.status |
UID (UID) |
|
-- |
ulong |
No |
master..sysprocesses.uid |
|
User (USER) |
|
-- |
string(257) |
No |
master..sysprocesses.sid, master..syslogins.name or master..sysprocesses.sid, master..sysprocesses.loginame |
sys.dm_exec_requests.session_id,sys.server_principals.name or sys.dm_exec_sessions.security_id,sys.dm_exec_sessions.login_name |