![[Contents]](FIGURE/CONTENT.GIF)
Job Management Partner 1 Version 10, Job Management Partner 1/Performance Management - Remote Monitor for Microsoft(R) SQL Server Description, User's Guide and Reference
![[Glossary]](FIGURE/GLOSS.GIF)
![[Index]](FIGURE/INDEX.GIF)
![[Back]](FIGURE/FRONT.GIF)
![[Next]](FIGURE/AFTER.GIF)
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 | -- | -- | -- |
Copyright (C) 2013, Hitachi, Ltd.
Copyright (C) 2013, Hitachi Solutions, Ltd.