Process Detail (PD_PDET)

Organization of this page

Function
Default and changeable values
ODBC key field
Lifetime
Record size
Fields

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 Microsoft 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.

To Page Top

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

To Page Top

ODBC key field

PD_PDET_SPID

To Page Top

Lifetime

From the start until stop of a process

To Page Top

Record size

Fixed part: 937 bytes
Variable part: 1,174 bytes

To Page Top

Fields

View name (Manager name)	Description	Summary	Format	Delta	Data source
View name (Manager name)	Description	Summary	Format	Delta	Microsoft SQL Server version 2014 or earlier	Microsoft 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)	Microsoft SQL Server version 2014 or earlier: Number of procedure cache pages allocated to the process (1 page equals 8 kilobytes) Microsoft SQL Server version 2016 or later: Number of pages of memory used in the process	--	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)	Microsoft SQL Server version 2014 or earlier: User ID of the user who executed the command Microsoft SQL Server version 2016 or later: This is not available.	--	ulong	No	master..sysprocesses.uid	--
User (USER)	Microsoft SQL Server version 2014 or earlier: Logon name of the user who issued the command. If information cannot be obtained from the syslogins system table of Microsoft SQL Server, it is obtained from the sysprocesses system table. If the logon name used is 61 characters or longer, the part exceeding 61 characters is cut off. Microsoft SQL Server version 2016 or later: If information cannot be obtained from the sys.server_principals system table, it is obtained from the dm_exec_sessions system table. If the logon name used is 61 characters or longer, the part exceeding 61 characters is cut off.	--	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

To Page Top