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

ItemDefault valueChangeable
Collection Interval60Y
Collection Offset0Y
LogYesY
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
CPU %
(PERC_BUSY)
Percentage of time CPU is busy#2AVGdoubleNoCPU_BUSY / (CPU_BUSY + IDLE + IO_BUSY) * 100
CPU Time
(CPU_TIME)
CPU busy time (in seconds and milliseconds) #2AVGutimeYes@@cpu_busy / 1000
CPU Timeticks
(CPU_BUSY)
CPU usage time (in ticks)ADDBIulongYes@@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#2AVGulongNo@@connections
I/O %(PERC_IO)Percentage of CPU time spent for I/O#2AVGdoubleNoIO_BUSY / (CPU_BUSY + IDLE + IO_BUSY) * 100
I/O Time(IO_TIME)CPU time spent for I/O (in seconds and milliseconds) #2AVGutimeYes@@io_busy / 1000
I/O Timeticks
(IO_BUSY)
CPU I/O time (in ticks)ADDBIulongYes@@io_busy * 1000 / @@timeticks
Idle %
(PERC_IDLE)
Percentage of time CPU is idle#2AVGdoubleNoIDLE / (CPU_BUSY + IDLE + IO_BUSY) * 100
Idle Time
(IDLE_TIME)
CPU idle time (in seconds and milliseconds)#2AVGutimeYes@@idle / 1000
Idle Timeticks
(IDLE)
CPU idle time (in ticks)ADDBIulongYes@@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)#2AVGdoubleNomaster..sysperfinfo
Log Writes/sec
(LOG_WRITES_SEC)
Number of log pages per second written onto a disk within an interval #2AVGdoubleNomaster..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#2AVGulongYes@@packet_errors
Pkts Rcvd
(PACK_RECEIVED)
Number of packets received#2AVGulongYes@@pack_received
Pkts Sent
(PACK_SENT)
Number of packets sent#2AVGulongYes@@pack_sent
Reads Pending
(READS_PENDING)
This field is reserved and cannot be used.AVG------
Record Time
(RECORD_TIME)
Interval end time (GMT format) #1COPYtime_tNoRemote Monitor Collector
Record Type
(INPUT_RECORD_TYPE)
Record type (always PI) #1COPYchar(8)NoRemote Monitor Collector
Start Time
(START_TIME)
Interval start time (GMT format) #1COPYtime_tNoRemote Monitor Collector
Timeticks
(TIMETICKS)
Microseconds per tick#1COPYulongNo@@timeticks
Total Errors
(TOTAL_ERRORS)
Number of disk errors#2AVGulongYes@@total_errors
Total Reads
(TOTAL_READ)
Number of disk read operations#2AVGulongYes@@total_read
Total Writes
(TOTAL_WRITE)
Number of disk write operations Number of disk write operations#2AVGulongYes@@total_write
Trans/sec
(TRANS_SEC)
Number of Transact-SQL command batches per second executed within an interval #2AVGdoubleNomaster..sysperfinfo
VA DeviceID(VADEVICEID)Device ID of virtual agent.--string(256)NoRemote Monitor Collector
Writes Pending
(WRITES_PENDING)
This field is reserved and cannot be used.AVG------