Server Detail (PD)

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

ItemDefault valueChangeable
Collection Interval60Y
Collection Offset0Y
LogNoY
LOGIF(Blank)Y

ODBC key field

None

Lifetime

From the start until stop of a Microsoft SQL Server instance

Record size

Fields

View name
(Manager name)
DescriptionSummaryFormatDeltaData source
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--wordNomaster..sysprocesses.blocked
Blocking Locks
(BLOCKING)
Number of blocking locks--ulongNomaster..syslockinfo.req_status
Boot Time
(BOOT_TIME)
This field is reserved and cannot be used.--------
CPU %
(PERC_BUSY)
Percentage of time CPU is busy--doubleNoCPU_BUSY / (CPU_BUSY + IDLE + IO_BUSY) * 100
CPU Time
(CPU_TIME)
CPU busy time (in seconds and milliseconds)--utimeYes@@cpu_busy / 1000
CPU Timeticks
(CPU_BUSY)
CPU usage time (in ticks)--ulongYes@@cpu_busy * 1000 / @@timeticks
Cache Buffers Free
(CACHE_FREE_BUFFERS)
Number of data cache buffers inside a free pool.
For Microsoft SQL Server 2012, this item is always 0.
--wordNomaster..sysperfinfo.free pages
Cache Hit %
(CACHE_HIT_RATIO)
Rate at which data pages were found inside the data cache within an interval--doubleNomaster..sysperfinfo.buffer cache hit ratio / buffer cache hit ratio base * 100
Conns
(CONNECTIONS)
Number of client connections--ulongNo@@connections
DSQuery
(DS_QUERY)
Value of DSQUERY environment variable. Character string is truncated at 30 bytes.--string(31)No#
Database Count
(DATABASES)
Database count--wordNomaster..sysdatabases
Demand Locks
(DEMAND)
Number of request locks--ulongNomaster..syslockinfo.rsc_type, master..syslockinfo.req_mode
Exclusive Intent Locks
(EXCLUSIVE_INTENT)
Number of exclusive intent locks--ulongNomaster..syslockinfo.rsc_type, master..syslockinfo.req_mode
Exclusive Page Locks
(EXCLUSIVE_PAGE)
Number of exclusive page locks--ulongNomaster..syslockinfo.rsc_type, master..syslockinfo.req_mode
Exclusive Table Locks
(EXCLUSIVE_TABLE)
Number of exclusive table locks--ulongNomaster..syslockinfo.rsc_type, master..syslockinfo.req_mode
Host OS
(OS)
OS under which Microsoft SQL Server is running. Data is truncated after 30 bytes.--string(31)NoValue of registry-key\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:
  • For the 32-bit and 64-bit (IPF) versions of Microsoft SQL Server: Intel
  • For the 64-bit version of Microsoft SQL Server (x64): X64
--string(31)No@@version
I/O %
(PERC_IO)
Percentage of CPU time spent for I/O--doubleNoIO_BUSY / (CPU_BUSY + IDLE + IO_BUSY) * 100
I/O Time
(IO_TIME)
Percentage of CPU time spent for I/O (in seconds and milliseconds)--utimeYes@@io_busy / 1000
I/O Timeticks
(IO_BUSY)
CPU I/O time (in ticks)--ulongYes@@io_busy * 1000 / @@timeticks
Idle %
(PERC_IDLE)
Percentage of time CPU is idle--doubleNoIDLE / (CPU_BUSY + IDLE + IO_BUSY) * 100
Idle Time
(IDLE_TIME)
Percentage of time CPU is idle (in seconds and milliseconds)--utimeYes@@idle / 1000
Idle Timeticks
(IDLE)
CPU idle time (in ticks)--ulongYes@@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)--doubleNomaster..sysperfinfo.lazy writer buffers/sec
Locks
(LOCKS)
Total number of locks--ulongNomaster..syslockinfo
Log Writes/sec
(LOG_WRITES_SEC)
Total number of log pages written onto a disk--doubleNomaster..sysperfinfo.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--wordNomaster..sysprocesses.status
Page Reads/sec
(PAGE_READS_SEC)
Total number of physical page read operations--doubleNomaster..sysperfinfo.page reads/sec
Page Writes/sec
(PAGE_WRITES_SEC)
Total number of physical page write operations--doubleNomaster..sysperfinfo.page writes/sec
Pkt Errors
(PACKET_ERRORS)
Number of packet errors--ulongYes@@packet_errors
Pkts Rcvd
(PACK_RECEIVED)
Number of packets received--ulongYes@@pack_received
Pkts Sent
(PACK_SENT)
Number of packets sent--ulongYes@@pack_sent
Process Count
(PROCESSES)
Total number of processes--wordNomaster..sysprocesses
RA Pages Fetched
(RA_PAGES_FETCHED)
Total number of pages prefetched into the cache by Read Ahead Manager--doubleNomaster..sysperfinfo.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--doubleNomaster..sysperfinfo.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_tNoRemote Monitor Collector
Record Type
(INPUT_RECORD_TYPE)
Record type (always PD)--char(8)NoRemote Monitor Collector
Runnable Processes
(RUNNABLE)
Number of executable processes--wordNomaster..sysprocesses.status
Running Processes
(RUNNING)
Number of processes being executed--wordNomaster..sysprocesses.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--ulongNomaster..syslockinfo.rsc_type,master..syslockinfo.req_mode
Shared Page Locks
(SHARED_PAGE)
Number of shared page locks--ulongNomaster..syslockinfo.rsc_type,master..syslockinfo.req_mode
Shared Table Locks
(SHARED_TABLE)
Number of shared table locks--ulongNomaster..syslockinfo.rsc_type,master..syslockinfo.req_mode
Sleeping Processes
(SLEEPING)
Number of sleeping processes--wordNomaster..sysprocesses.status
Start Time
(START_TIME)
Interval start time (GMT format)--time_tNoRemote Monitor Collector
Timeticks
(TIMETICKS)
Microseconds per tick--ulongNo@@timeticks
Total Errors
(TOTAL_ERRORS)
Number of disk errors--ulongYes@@total_errors
Total Reads
(TOTAL_READ)
Number of disk read operations--ulongYes@@total_read
Total Writes
(TOTAL_WRITE)
Number of disk write operations--ulongYes@@total_write
Trans/sec
(TRANS_SEC)
Total number of Transact-SQL command batches executed--doubleNomaster..sysperfinfo.batch requests/sec
Update Page Locks
(UPDATE_PAGE)
Number of update page locks--ulongNomaster..syslockinfo.rsc_type,master..syslockinfo.req_mode
VA DeviceID(VADEVICEID)Device ID of virtual agent.--string(256)NoRemote Monitor Collector
Version
(SERVER_VERSION)
Microsoft SQL Server version--string(20)NoSERVERPROPERTY('productversion')
Writes Pending
(WRITES_PENDING)
This field is reserved and cannot be used.--------
#
N/A is always displayed.