Hitachi

JP1 Version 12 JP1/Performance Management - Remote Monitor for Microsoft(R) SQL Server Description, User's Guide and Reference


Global Server Summary (PI)

Organization of this page

Function

The Global Server Summary (PI) record indicates information related to the Microsoft SQL Server I/O and network. 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

Fields

View name

(Manager name)

Description

Summary

Format

Delta

Data source

Microsoft SQL Server version 2014 or earlier

Microsoft 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)

Total number of pages flushed by Lazy Writer to a disk (1 page equals 8 kilobytes)#2

AVG

double

No

master..sysperfinfo

sys.dm_os_performance_counters

Log Writes/sec

(LOG_WRITES_SEC)

Total number of log pages written onto a disk#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

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)

Total number of Transact-SQL command batches executed #2

AVG

double

No

master..sysperfinfo

sys.dm_os_performance_counters

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

--

--

--