![[Contents]](FIGURE/CONTENT.GIF)
Job Management Partner 1 Version 10, Job Management Partner 1/Performance Management - Remote Monitor for Microsoft(R) SQL Server Description, User's Guide and Reference
![[Glossary]](FIGURE/GLOSS.GIF)
![[Index]](FIGURE/INDEX.GIF)
![[Back]](FIGURE/FRONT.GIF)
![[Next]](FIGURE/AFTER.GIF)
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 | -- | -- | -- |
Copyright (C) 2013, Hitachi, Ltd.
Copyright (C) 2013, Hitachi Solutions, Ltd.