![[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 (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 | -- | -- | -- |
Copyright (C) 2013, Hitachi, Ltd.
Copyright (C) 2013, Hitachi Solutions, Ltd.