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
Item | Default value | Changeable |
---|---|---|
Collection Interval | 60 | Y |
Collection Offset | 0 | Y |
Log | No | Y |
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) | Description | Summary | Format | Delta | Data 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 | -- | word | No | master..sysprocesses.blocked |
Blocking Locks (BLOCKING) | Number of blocking locks | -- | ulong | No | master..syslockinfo.req_status |
Boot Time (BOOT_TIME) | This field is reserved and cannot be used. | -- | -- | -- | -- |
CPU % (PERC_BUSY) | Percentage of time CPU is busy | -- | double | No | CPU_BUSY / (CPU_BUSY + IDLE + IO_BUSY) * 100 |
CPU Time (CPU_TIME) | CPU busy time (in seconds and milliseconds) | -- | utime | Yes | @@cpu_busy / 1000 |
CPU Timeticks (CPU_BUSY) | CPU usage time (in ticks) | -- | 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, this item is always 0. | -- | word | No | master..sysperfinfo.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 |
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 | # |
Database Count (DATABASES) | Database count | -- | word | No | master..sysdatabases |
Demand Locks (DEMAND) | Number of request locks | -- | ulong | No | master..syslockinfo.rsc_type, master..syslockinfo.req_mode |
Exclusive Intent Locks (EXCLUSIVE_INTENT) | Number of exclusive intent locks | -- | ulong | No | master..syslockinfo.rsc_type, master..syslockinfo.req_mode |
Exclusive Page Locks (EXCLUSIVE_PAGE) | Number of exclusive page locks | -- | ulong | No | master..syslockinfo.rsc_type, master..syslockinfo.req_mode |
Exclusive Table Locks (EXCLUSIVE_TABLE) | Number of exclusive table locks | -- | ulong | No | master..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) | No | Value 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:
| -- | string(31) | No | @@version |
I/O % (PERC_IO) | Percentage of CPU time spent for I/O | -- | 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) | -- | utime | Yes | @@io_busy / 1000 |
I/O Timeticks (IO_BUSY) | CPU I/O time (in ticks) | -- | ulong | Yes | @@io_busy * 1000 / @@timeticks |
Idle % (PERC_IDLE) | Percentage of time CPU is idle | -- | double | No | IDLE / (CPU_BUSY + IDLE + IO_BUSY) * 100 |
Idle Time (IDLE_TIME) | Percentage of time CPU is idle (in seconds and milliseconds) | -- | utime | Yes | @@idle / 1000 |
Idle Timeticks (IDLE) | CPU idle time (in ticks) | -- | 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 |
Locks (LOCKS) | Total number of locks | -- | ulong | No | master..syslockinfo |
Log Writes/sec (LOG_WRITES_SEC) | Total number of log pages written onto a disk | -- | double | No | master..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 | -- | word | No | master..sysprocesses.status |
Page Reads/sec (PAGE_READS_SEC) | Total number of physical page read operations | -- | double | No | master..sysperfinfo.page reads/sec |
Page Writes/sec (PAGE_WRITES_SEC) | Total number of physical page write operations | -- | double | No | master..sysperfinfo.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 |
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 |
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 |
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 | Remote Monitor Collector |
Record Type (INPUT_RECORD_TYPE) | Record type (always PD) | -- | char(8) | No | Remote Monitor Collector |
Runnable Processes (RUNNABLE) | Number of executable processes | -- | word | No | master..sysprocesses.status |
Running Processes (RUNNING) | Number of processes being executed | -- | word | No | master..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 | -- | ulong | No | master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
Shared Page Locks (SHARED_PAGE) | Number of shared page locks | -- | ulong | No | master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
Shared Table Locks (SHARED_TABLE) | Number of shared table locks | -- | ulong | No | master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
Sleeping Processes (SLEEPING) | Number of sleeping processes | -- | word | No | master..sysprocesses.status |
Start Time (START_TIME) | Interval start time (GMT format) | -- | time_t | No | Remote Monitor 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 |
Update Page Locks (UPDATE_PAGE) | Number of update page locks | -- | ulong | No | master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
VA DeviceID(VADEVICEID) | Device ID of virtual agent. | -- | string(256) | No | Remote Monitor Collector |
Version (SERVER_VERSION) | Microsoft SQL Server version | -- | string(20) | No | SERVERPROPERTY('productversion') |
Writes Pending (WRITES_PENDING) | This field is reserved and cannot be used. | -- | -- | -- | -- |