Server Overview (PI_SERV)

Function

The Server Overview (PI_SERV) record indicates overall information related to Microsoft SQL Server, such as rate of cache hits and I/O. 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)
Total number of pages flushed by Lazy Writer to a disk (1 page equals 8 kilobytes)AVGdoubleNomaster..sysperfinfo.Lazy writes/sec
Log Writes/sec
(IO_LOG_WRITES_PER_SEC)
Total number of log pages physically written onto a diskAVGdoubleNomaster..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)
Total number of physical page read operations executedAVGdoubleNomaster..sysperfinfo.page reads/sec
Page Writes/sec
(IO_PAGE_WRITES_PER_SEC)
Total number of physical page write operations executedAVGdoubleNomaster..sysperfinfo.page writes/sec
RA Pages Fetched into Cache/sec
(RA_PAGES_FETCHED_INTO_CACHE_PER_SEC)
Total number of pages prefetched into the cache by Read Ahead ManagerAVGdoubleNomaster..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)
Total number of physical read operations issued by Read Ahead Manager. (A single read operation is 8 pages,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)
Total number of Transact-SQL command batches executedAVGdoubleNomaster..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------