Global Server Summary 2 (PI_PI2)
Function
The Global Server Summary 2(PI_PI2) record indicates information related to the Microsoft SQL Server I/O and network. The Global Server Summary 2(PI_PI2) record acquires from the Microsoft SQL Server the values of the fields which store the cumulative values for "/sec" counters and uses those values to calculate the per-sec value. One record is created for each interval.
Default and changeable values
Item | Default value | Changeable |
---|---|---|
Collection Interval | 60 | Y |
Collection Offset | 0 | Y |
Log | Yes | 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 |
---|---|---|---|---|---|
CPU % (PERC_BUSY) | Percentage of time CPU is busy#2 | AVG | double | No | CPU_BUSY / (CPU_BUSY + IDLE + IO_BUSY) * 100 |
CPU Time (CPU_TIME) | CPU busy time (in seconds and milliseconds) #2 | AVG | utime | Yes | @@cpu_busy / 1000 |
CPU Timeticks (CPU_BUSY) | CPU usage time (in ticks) | ADDBI | ulong | Yes | @@cpu_busy * 1000 / @@timeticks |
Cache Avg Scan (CACHE_AVG_SCAN) | This field is reserved and cannot be used. | AVG | -- | -- | -- |
Conns (CONNECTIONS) | Number of client connections#2 | AVG | ulong | No | @@connections |
I/O %(PERC_IO) | Percentage of CPU time spent for I/O#2 | AVG | double | No | IO_BUSY / (CPU_BUSY + IDLE + IO_BUSY) * 100 |
I/O Time(IO_TIME) | CPU time spent for I/O (in seconds and milliseconds) #2 | AVG | utime | Yes | @@io_busy / 1000 |
I/O Timeticks (IO_BUSY) | CPU I/O time (in ticks) | ADDBI | ulong | Yes | @@io_busy * 1000 / @@timeticks |
Idle % (PERC_IDLE) | Percentage of time CPU is idle#2 | AVG | double | No | IDLE / (CPU_BUSY + IDLE + IO_BUSY) * 100 |
Idle Time (IDLE_TIME) | CPU idle time (in seconds and milliseconds)#2 | AVG | utime | Yes | @@idle / 1000 |
Idle Timeticks (IDLE) | CPU idle time (in ticks) | ADDBI | ulong | Yes | @@idle * 1000 / @@timeticks |
Lazy Writes/sec (LAZY_WRITES_SEC) | Number of pages per second flushed by Lazy Writer to a disk within an interval (1 page equals 8 kilobytes)#2 | AVG | double | No | master..sysperfinfo |
Log Writes/sec (LOG_WRITES_SEC) | Number of log pages per second written onto a disk within an interval #2 | AVG | double | No | master..sysperfinfo |
Net Queue (NET_QUEUE) | This field is reserved and cannot be used. | AVG | -- | -- | -- |
Net Reads/sec (NET_READS_SEC) | This field is reserved and cannot be used. | AVG | -- | -- | -- |
Net Writes/sec (NET_WRITES_SEC) | This field is reserved and cannot be used. | AVG | -- | -- | -- |
Pkt Errors (PACKET_ERRORS) | Number of packet errors#2 | AVG | ulong | Yes | @@packet_errors |
Pkts Rcvd (PACK_RECEIVED) | Number of packets received#2 | AVG | ulong | Yes | @@pack_received |
Pkts Sent (PACK_SENT) | Number of packets sent#2 | AVG | ulong | Yes | @@pack_sent |
Reads Pending (READS_PENDING) | This field is reserved and cannot be used. | AVG | -- | -- | -- |
Record Time (RECORD_TIME) | Interval end time (GMT format) #1 | COPY | time_t | No | Remote Monitor Collector |
Record Type (INPUT_RECORD_TYPE) | Record type (always PI) #1 | COPY | char(8) | No | Remote Monitor Collector |
Start Time (START_TIME) | Interval start time (GMT format) #1 | COPY | time_t | No | Remote Monitor Collector |
Timeticks (TIMETICKS) | Microseconds per tick#1 | COPY | ulong | No | @@timeticks |
Total Errors (TOTAL_ERRORS) | Number of disk errors#2 | AVG | ulong | Yes | @@total_errors |
Total Reads (TOTAL_READ) | Number of disk read operations#2 | AVG | ulong | Yes | @@total_read |
Total Writes (TOTAL_WRITE) | Number of disk write operations Number of disk write operations#2 | AVG | ulong | Yes | @@total_write |
Trans/sec (TRANS_SEC) | Number of Transact-SQL command batches per second executed within an interval #2 | AVG | double | No | master..sysperfinfo |
VA DeviceID(VADEVICEID) | Device ID of virtual agent. | -- | string(256) | No | Remote Monitor Collector |
Writes Pending (WRITES_PENDING) | This field is reserved and cannot be used. | AVG | -- | -- | -- |