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
Item | Default value | Changeable |
---|---|---|
Collection Interval | 60 | Y |
Collection Offset | 0 | Y |
Log | No | 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 |
---|---|---|---|---|---|
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. | AVG | ulong | No | master..sysperfinfo.free pages |
Cache Hit % (CACHE_HIT_RATIO) | Rate at which data pages were found inside the data cache | AVG | double | No | master..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) | AVG | double | No | master..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 interval | AVG | double | No | master..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) | HI | double | No | master..sysperfinfo.data file(s) size (kb) / 1024 |
Max Users Conn'd (MAX_USERS_CONNECTED) | Maximum number of user connections established within an interval | HI | ulong | No | master..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 interval | AVG | double | No | master..sysperfinfo.page reads/sec |
Page Writes/sec (IO_PAGE_WRITES_PER_SEC) | Number of physical pages written per second within an interval | AVG | double | No | master..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 interval | AVG | double | No | master..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) | AVG | double | No | master..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) | COPY | time_t | No | Remote Monitor Collector |
Record Type (INPUT_RECORD_TYPE) | Record type (always SERV) | COPY | char(8) | No | Remote Monitor Collector |
Start Time (START_TIME) | Interval start time (GMT format) | COPY | time_t | No | Remote Monitor Collector |
Trans/sec (IO_TRANSACTIONS_PER_SEC) | Number of Transact-SQL command batches per second executed within an interval | AVG | double | No | master..sysperfinfo.batch requests/sec |
User Conns (USER_CONNECTIONS) | Number of client connections | COPY | ulong | No | master..sysperfinfo.user connections |
VA DeviceID(VADEVICEID) | Device ID of virtual agent. | -- | string(256) | No | Remote Monitor Collector |
Writes Pending (IO_OUTSTANDING_WRITES) | This field is reserved and cannot be used. | AVG | -- | -- | -- |