Server Detail (PD)
- Organization of this page
Function
The Server Detail (PD) record indicates detailed information on Microsoft SQL Server, such as I/O and locks. Only one record is created.
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
None
Lifetime
From the start until stop of a Microsoft SQL Server instance
Record size
-
Fixed part: 1,303 bytes
-
Variable part: 0 bytes
Fields
View name (Manager name) |
Description |
Summary |
Format |
Delta |
Data source |
|
---|---|---|---|---|---|---|
SQL Server version 2014 or earlier |
SQL Server version 2016 or later |
|||||
Avg Cache Scan(CACHE_AVG_SCAN) |
This field is reserved and cannot be used. |
-- |
-- |
-- |
-- |
|
Blocked Processes (BLOCKED) |
Number of processes that are waiting because a process running on Microsoft SQL Server is locked |
-- |
word |
No |
master..sysprocesses.blocked |
sys.dm_exec_requests.blocking_session_id |
Blocking Locks (BLOCKING) |
Number of blocking locks |
-- |
ulong |
No |
master..syslockinfo.req_status |
sys.dm_tran_locks.request_status |
Boot Time (BOOT_TIME) |
This field is reserved and cannot be used. |
-- |
time_t |
No |
Microsoft SQL Server error log |
|
CPU % (PERC_BUSY) |
Percentage of time CPU is busy This field cannot display correct value. |
-- |
double |
No |
CPU_BUSY / (CPU_BUSY + IDLE + IO_BUSY) * 100 |
|
CPU Time (CPU_TIME) |
CPU busy time (in seconds and milliseconds) This field cannot display correct value. |
-- |
utime |
Yes |
@@cpu_busy / 1000 |
|
CPU Timeticks (CPU_BUSY) |
CPU usage time (in ticks) This field cannot display correct value. |
-- |
ulong |
Yes |
@@cpu_busy * 1000 / @@timeticks |
|
Cache Buffers Free (CACHE_FREE_BUFFERS) |
Number of data cache buffers inside a free pool. For Microsoft SQL Server 2012 or later, this item is always 0. |
-- |
word |
No |
master..sysperfinfo.free pages |
sys.dm_os_performance_counters.free pages |
Cache Hit % (CACHE_HIT_RATIO) |
Rate at which data pages were found inside the data cache within an interval |
-- |
double |
No |
master..sysperfinfo.buffer cache hit ratio / buffer cache hit ratio base * 100 |
sys.dm_os_performance_counters.buffer cache hit ratio / buffer cache hit ratio base * 100 |
Conns (CONNECTIONS) |
Number of client connections |
-- |
ulong |
No |
@@connections |
|
DSQuery (DS_QUERY) |
Value of DSQUERY environment variable. Character string is truncated at 30 bytes. |
-- |
string(31) |
No |
#4 |
|
Database Count (DATABASES) |
Database count |
-- |
word |
No |
master..sysdatabases |
sys.databases |
Demand Locks (DEMAND) |
Number of request locks |
-- |
ulong |
No |
master..syslockinfo.rsc_type, master..syslockinfo.req_mode |
sys.dm_tran_locks.resource_type, sys.dm_tran_locks.request_mode |
Exclusive Intent Locks (EXCLUSIVE_INTENT) |
Number of exclusive intent locks |
-- |
ulong |
No |
master..syslockinfo.rsc_type, master..syslockinfo.req_mode |
sys.dm_tran_locks.resource_type, sys.dm_tran_locks.request_mode |
Exclusive Page Locks (EXCLUSIVE_PAGE) |
Number of exclusive page locks |
-- |
ulong |
No |
master..syslockinfo.rsc_type, master..syslockinfo.req_mode |
sys.dm_tran_locks.resource_type, sys.dm_tran_locks.request_mode |
Exclusive Table Locks (EXCLUSIVE_TABLE) |
Number of exclusive table locks |
-- |
ulong |
No |
master..syslockinfo.rsc_type, master..syslockinfo.req_mode |
sys.dm_tran_locks.resource_type, sys.dm_tran_locks.request_mode |
Host OS (OS) |
OS under which Microsoft SQL Server is running. Data is truncated after 30 bytes. |
-- |
string(31) |
No |
Value of registry-key HKEY_LOCAL_MACHINE \SOFTWARE\Microsoft\WindowsNT\CurrentVersion\ProductName |
|
Host Type (HOST_TYPE) |
Type of machine on which Microsoft SQL Server is running. Either of the following values is displayed:
|
-- |
string(31) |
No |
@@version |
|
I/O % (PERC_IO) |
Percentage of CPU time spent for I/O This field cannot display correct value. |
-- |
double |
No |
IO_BUSY / (CPU_BUSY + IDLE + IO_BUSY) * 100 |
|
I/O Time (IO_TIME) |
Percentage of CPU time spent for I/O (in seconds and milliseconds) This field cannot display correct value. |
-- |
utime |
Yes |
@@io_busy / 1000 |
|
I/O Timeticks (IO_BUSY) |
CPU I/O time (in ticks) This field cannot display correct value. |
-- |
ulong |
Yes |
@@io_busy * 1000 / @@timeticks |
|
Idle % (PERC_IDLE) |
Percentage of time CPU is idle This field cannot display correct value. |
-- |
double |
No |
IDLE / (CPU_BUSY + IDLE + IO_BUSY) * 100 |
|
Idle Time (IDLE_TIME) |
Percentage of time CPU is idle (in seconds and milliseconds) This field cannot display correct value. |
-- |
utime |
Yes |
@@idle / 1000 |
|
Idle Timeticks (IDLE) |
CPU idle time (in ticks) This field cannot display correct value. |
-- |
ulong |
Yes |
@@idle * 1000 / @@timeticks |
|
Lazy Writes/sec (LAZY_WRITES_SEC) |
Total number of pages flushed by Lazy Writer to a disk (1 page equals 8 kilobytes) |
-- |
double |
No |
master..sysperfinfo.lazy writer buffers/sec |
sys.dm_os_performance_counters.lazy writer buffers/sec |
Locks (LOCKS) |
Total number of locks |
-- |
ulong |
No |
master..syslockinfo |
sys.dm_tran_locks |
Log Writes/sec (LOG_WRITES_SEC) |
Total number of log pages written onto a disk |
-- |
double |
No |
master..sysperfinfo.log flushes/sec |
sys.dm_os_performance_counters.log flushes/sec |
Max Cache Scan (CACHE_MAX_SCAN) |
This field is reserved and cannot be used. |
-- |
-- |
-- |
-- |
|
Net Queue (NET_QUEUE) |
This field is reserved and cannot be used. |
-- |
-- |
-- |
-- |
|
Net Reads/Sec (NET_READS_SEC) |
This field is reserved and cannot be used. |
-- |
-- |
-- |
-- |
|
Net Writes/Sec (NET_WRITES_SEC) |
This field is reserved and cannot be used. |
-- |
-- |
-- |
-- |
|
Other Processes (OTHER) |
Number of processes of other types |
-- |
word |
No |
master..sysprocesses.status |
sys.dm_exec_sessions.status |
Page Reads/sec (PAGE_READS_SEC) |
Total number of physical page read operations |
-- |
double |
No |
master..sysperfinfo.page reads/sec |
sys.dm_os_performance_counters.page reads/sec |
Page Writes/sec (PAGE_WRITES_SEC) |
Total number of physical page write operations |
-- |
double |
No |
master..sysperfinfo.page writes/sec |
sys.dm_os_performance_counters.page writes/sec |
Pkt Errors (PACKET_ERRORS) |
Number of packet errors |
-- |
ulong |
Yes |
@@packet_errors |
|
Pkts Rcvd (PACK_RECEIVED) |
Number of packets received |
-- |
ulong |
Yes |
@@pack_received |
|
Pkts Sent (PACK_SENT) |
Number of packets sent |
-- |
ulong |
Yes |
@@pack_sent |
|
Process Count (PROCESSES) |
Total number of processes |
-- |
word |
No |
master..sysprocesses |
sys.dm_exec_sessions |
RA Pages Fetched (RA_PAGES_FETCHED) |
Total number of pages prefetched into the cache by Read Ahead Manager |
-- |
double |
No |
master..sysperfinfo.readahead pages/sec |
sys.dm_os_performance_counters.readahead pages/sec |
RA Pages Found (RA_PAGES_FOUND) |
This field is reserved and cannot be used. |
-- |
-- |
-- |
-- |
|
RA Reads/sec (RA_READS_SEC) |
Total number of physical read operations executed by Read Ahead Manager |
-- |
double |
No |
master..sysperfinfo.page reads/sec |
sys.dm_os_performance_counters.page reads/sec |
RA Slots Used (RA_SLOTS_USED) |
This field is reserved and cannot be used. |
-- |
-- |
-- |
-- |
|
Reads Pending (READS_PENDING) |
This field is reserved and cannot be used. |
-- |
-- |
-- |
-- |
|
Record Time (RECORD_TIME) |
Interval end time (GMT format) |
-- |
time_t |
No |
Agent Collector |
|
Record Type (INPUT_RECORD_TYPE) |
Record type (always PD) |
-- |
char(8) |
No |
Agent 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 |
Server Name (SERVER_NAME) |
Name of machine on which Microsoft SQL Server is running |
-- |
string(257) |
No |
@@servername |
|
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 |
Agent Collector |
|
Timeticks (TIMETICKS) |
Microseconds per tick |
-- |
ulong |
No |
@@timeticks |
|
Total Errors (TOTAL_ERRORS) |
Number of disk errors |
-- |
ulong |
Yes |
@@total_errors |
|
Total Reads (TOTAL_READ) |
Number of disk read operations |
-- |
ulong |
Yes |
@@total_read |
|
Total Writes (TOTAL_WRITE) |
Number of disk write operations |
-- |
ulong |
Yes |
@@total_write |
|
Trans/sec (TRANS_SEC) |
Total number of Transact-SQL command batches executed |
-- |
double |
No |
master..sysperfinfo.batch requests/sec |
sys.dm_os_performance_counters.batch requests/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 |
Version (SERVER_VERSION) |
Microsoft SQL Server version |
-- |
string(20) |
No |
SERVERPROPERTY('productversion') |
|
Writes Pending (WRITES_PENDING) |
This field is reserved and cannot be used. |
-- |
-- |
-- |
-- |
- #4
-
N/A is always displayed.