Global Server Summary 2 (PI_PI2)
- Organization of this page
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 |
|
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,100 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 |
|||||
|
CPU % (PERC_BUSY) |
Percentage of time CPU is busy#2 This field cannot display correct value. |
AVG |
double |
No |
CPU_BUSY / (CPU_BUSY + IDLE + IO_BUSY) * 100 |
|
|
CPU Time (CPU_TIME) |
CPU busy time (in seconds and milliseconds) #2 This field cannot display correct value. |
AVG |
utime |
Yes |
@@cpu_busy / 1000 |
|
|
CPU Timeticks (CPU_BUSY) |
CPU usage time (in ticks) This field cannot display correct value. |
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 This field cannot display correct value. |
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 This field cannot display correct value. |
AVG |
utime |
Yes |
@@io_busy / 1000 |
|
|
I/O Timeticks (IO_BUSY) |
CPU I/O time (in ticks) This field cannot display correct value. |
ADDBI |
ulong |
Yes |
@@io_busy * 1000 / @@timeticks |
|
|
Idle % (PERC_IDLE) |
Percentage of time CPU is idle#2 This field cannot display correct value. |
AVG |
double |
No |
IDLE / (CPU_BUSY + IDLE + IO_BUSY) * 100 |
|
|
Idle Time (IDLE_TIME) |
CPU idle time (in seconds and milliseconds)#2 This field cannot display correct value. |
AVG |
utime |
Yes |
@@idle / 1000 |
|
|
Idle Timeticks (IDLE) |
CPU idle time (in ticks) This field cannot display correct value. |
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 |
sys.dm_os_performance_counters |
|
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 |
sys.dm_os_performance_counters |
|
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 |
Agent Collector |
|
|
Record Type (INPUT_RECORD_TYPE) |
Record type (always PI2) #1 |
COPY |
char(8) |
No |
Agent Collector |
|
|
Start Time (START_TIME) |
Interval start time (GMT format) #1 |
COPY |
time_t |
No |
Agent 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 |
Yes#3 |
master..sysperfinfo |
sys.dm_os_performance_counters |
|
Writes Pending (WRITES_PENDING) |
This field is reserved and cannot be used. |
AVG |
-- |
-- |
-- |
|
- #3
-
The delta is calculated based on the changed amount of data acquired from SQL Server data base.