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
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) | Total number of pages flushed by Lazy Writer to a disk (1 page equals 8 kilobytes) | AVG | double | No | master..sysperfinfo.Lazy writes/sec |
Log Writes/sec (IO_LOG_WRITES_PER_SEC) | Total number of log pages physically written onto a disk | 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) | Total number of physical page read operations executed | AVG | double | No | master..sysperfinfo.page reads/sec |
Page Writes/sec (IO_PAGE_WRITES_PER_SEC) | Total number of physical page write operations executed | AVG | double | No | master..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 Manager | 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) | Total number of physical read operations issued by Read Ahead Manager. (A single read operation is 8 pages, | 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) | Total number of Transact-SQL command batches executed | 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 | -- | -- | -- |