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.
- Note:
-
PFM - RM for SQL Server collects performance data of the record field size from Microsoft SQL Server. Therefore, if Microsoft SQL Server contains data that exceeds the field size of User field, the last character of the performance data might be unreadable.
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: 937 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 |
Remote Monitor Collector |
|
Record Type (INPUT_RECORD_TYPE) |
Record type (always PDET) |
-- |
char(8) |
No |
Remote Monitor 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 |
Remote Monitor 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 |
VA DeviceID(VADEVICEID) |
Device ID of virtual agent. |
-- |
string(256) |
No |
Remote Monitor Collector |