Server Overview 2 (PI_SRV2)

Function

The Server Overview 2(PI_SRV2) record indicates overall information related to Microsoft SQL Server, such as rate of cache hits and I/O. The Server Overview 2(PI_SRV2) 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. Only one record is created.

Default and changeable values

ItemDefault valueChangeable
Collection Interval60Y
Collection Offset0Y
LogNoY
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
Avg Cache Scan
(CACHE_AVG_FREE_PAGE_SCAN)
This field is reserved and cannot be used.AVG------
Cache Buffers Free
(CACHE_NUMBER_OF_FREE_BUFFERS)
Number of data cache buffers inside a free pool at the time of data collection.
For Microsoft SQL Server 2012, this item is always 0.
AVGulongNomaster..sysperfinfo.free pages
Cache Hit %
(CACHE_HIT_RATIO)
Rate at which data pages were found inside the data cacheAVGdoubleNomaster..sysperfinfo.buffer cache hit ratio / buffer cache hit ratio base * 100
Command Queue Length
(NET_COMMAND_QUEUE_LENGTH)
This field is reserved and cannot be used.AVG------
Lazy Writes/sec
(IO_LAZY_WRITES_PER_SEC)
Number of pages per second flushed by Lazy Writer to a disk within an interval (1 page equals 8 kilobytes)AVGdoubleNomaster..sysperfinfo.Lazy writes/sec
Log Writes/sec
(IO_LOG_WRITES_PER_SEC)
Number of log pages per second physically written onto a disk within an intervalAVGdoubleNomaster..sysperfinfo.log flushes/sec
Max Cache Scan
(CACHE_MAX_FREE_PAGE_SCAN)
This field is reserved and cannot be used.HI------
Max Tempdb Space Used Mbytes
(MAX_TEMPDB_SPACE_USED_MB)
Maximum value of the space used in tempdb within an interval (in megabytes)HIdoubleNomaster..sysperfinfo.data file(s) size (kb) / 1024
Max Users Conn'd
(MAX_USERS_CONNECTED)
Maximum number of user connections established within an intervalHIulongNomaster..sysperfinfo.user connections
Net Reads/sec
(NET_NETWORK_READS_PER_SEC)
This field is reserved and cannot be used.AVG------
Net Writes/sec
(NET_NETWORK_WRITES_PER_SEC)
This field is reserved and cannot be used.AVG------
Page Reads/sec
(IO_PAGE_READS_PER_SEC)
Number of physical pages read per second within an intervalAVGdoubleNomaster..sysperfinfo.page reads/sec
Page Writes/sec
(IO_PAGE_WRITES_PER_SEC)
Number of physical pages written per second within an intervalAVGdoubleNomaster..sysperfinfo.page writes/sec
RA Pages Fetched into Cache/sec
(RA_PAGES_FETCHED_INTO_CACHE_PER_SEC)
Number of pages per second prefetched into the cache by Read Ahead Manager within an intervalAVGdoubleNomaster..sysperfinfo.readahead pages/sec
RA Pages Found in Cache/sec
(RA_PAGES_FOUND_IN_CACHE_PER_SEC)
This field is reserved and cannot be used.AVG------
RA Physical Reads/sec
(RA_PHYSICAL_READS_PER_SEC)
Number of physical read operations per second issued by Read Ahead Manager within an interval. (A single read operation involves 8 pages, each of which is 8 kilobytes)AVGdoubleNomaster..sysperfinfo.page reads/sec
RA Slots Used
(RA_SLOTS_USED)
This field is reserved and cannot be used.COPY------
Reads Pending
(IO_OUTSTANDING_READS)
This field is reserved and cannot be used.AVG------
Record Time
(RECORD_TIME)
Interval end time (GMT format)COPYtime_tNoRemote Monitor Collector
Record Type
(INPUT_RECORD_TYPE)
Record type (always SERV)COPYchar(8)NoRemote Monitor Collector
Start Time
(START_TIME)
Interval start time (GMT format)COPYtime_tNoRemote Monitor Collector
Trans/sec
(IO_TRANSACTIONS_PER_SEC)
Number of Transact-SQL command batches per second executed within an intervalAVGdoubleNomaster..sysperfinfo.batch requests/sec
User Conns
(USER_CONNECTIONS)
Number of client connectionsCOPYulongNomaster..sysperfinfo.user connections
VA DeviceID(VADEVICEID)Device ID of virtual agent.--string(256)NoRemote Monitor Collector
Writes Pending
(IO_OUTSTANDING_WRITES)
This field is reserved and cannot be used.AVG------