![[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 Detail (PD) record indicates detailed information on Microsoft SQL Server, such as I/O and locks. 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_SCAN) | This field is reserved and cannot be used. | -- | -- | -- | -- |
| Blocked Processes (BLOCKED) |
Number of processes that are waiting because a process running on Microsoft SQL Server is locked | -- | word | No | master..sysprocesses.blocked |
| Blocking Locks (BLOCKING) |
Number of blocking locks | -- | ulong | No | master..syslockinfo.req_status |
| Boot Time (BOOT_TIME) |
This field is reserved and cannot be used. | -- | -- | -- | -- |
| CPU % (PERC_BUSY) |
Percentage of time CPU is busy | -- | double | No | CPU_BUSY / (CPU_BUSY + IDLE + IO_BUSY) * 100 |
| CPU Time (CPU_TIME) |
CPU busy time (in seconds and milliseconds) | -- | utime | Yes | @@cpu_busy / 1000 |
| CPU Timeticks (CPU_BUSY) |
CPU usage time (in ticks) | -- | ulong | Yes | @@cpu_busy * 1000 / @@timeticks |
| Cache Buffers Free (CACHE_FREE_BUFFERS) |
Number of data cache buffers inside a free pool. For Microsoft SQL Server 2012, this item is always 0. |
-- | word | No | master..sysperfinfo.free pages |
| Cache Hit % (CACHE_HIT_RATIO) |
Rate at which data pages were found inside the data cache within an interval | -- | double | No | master..sysperfinfo.buffer cache hit ratio / buffer cache hit ratio base * 100 |
| Conns (CONNECTIONS) |
Number of client connections | -- | ulong | No | @@connections |
| DSQuery (DS_QUERY) |
Value of DSQUERY environment variable. Character string is truncated at 30 bytes. | -- | string(31) | No | # |
| Database Count (DATABASES) |
Database count | -- | word | No | master..sysdatabases |
| Demand Locks (DEMAND) |
Number of request locks | -- | ulong | No | master..syslockinfo.rsc_type, master..syslockinfo.req_mode |
| Exclusive Intent Locks (EXCLUSIVE_INTENT) |
Number of exclusive intent locks | -- | ulong | No | master..syslockinfo.rsc_type, master..syslockinfo.req_mode |
| Exclusive Page Locks (EXCLUSIVE_PAGE) |
Number of exclusive page locks | -- | ulong | No | master..syslockinfo.rsc_type, master..syslockinfo.req_mode |
| Exclusive Table Locks (EXCLUSIVE_TABLE) |
Number of exclusive table locks | -- | ulong | No | master..syslockinfo.rsc_type, master..syslockinfo.req_mode |
| Host OS (OS) |
OS under which Microsoft SQL Server is running. Data is truncated after 30 bytes. | -- | string(31) | No | Value of registry-key\SOFTWARE\Microsoft\WindowsNT\CurrentVersion\ProductName |
| Host Type (HOST_TYPE) |
Type of machine on which Microsoft SQL Server is running. Either of the following values is displayed:
|
-- | string(31) | No | @@version |
| I/O % (PERC_IO) |
Percentage of CPU time spent for I/O | -- | double | No | IO_BUSY / (CPU_BUSY + IDLE + IO_BUSY) * 100 |
| I/O Time (IO_TIME) |
Percentage of CPU time spent for I/O (in seconds and milliseconds) | -- | utime | Yes | @@io_busy / 1000 |
| I/O Timeticks (IO_BUSY) |
CPU I/O time (in ticks) | -- | ulong | Yes | @@io_busy * 1000 / @@timeticks |
| Idle % (PERC_IDLE) |
Percentage of time CPU is idle | -- | double | No | IDLE / (CPU_BUSY + IDLE + IO_BUSY) * 100 |
| Idle Time (IDLE_TIME) |
Percentage of time CPU is idle (in seconds and milliseconds) | -- | utime | Yes | @@idle / 1000 |
| Idle Timeticks (IDLE) |
CPU idle time (in ticks) | -- | ulong | Yes | @@idle * 1000 / @@timeticks |
| Lazy Writes/sec (LAZY_WRITES_SEC) |
Total number of pages flushed by Lazy Writer to a disk (1 page equals 8 kilobytes) | -- | double | No | master..sysperfinfo.lazy writer buffers/sec |
| Locks (LOCKS) |
Total number of locks | -- | ulong | No | master..syslockinfo |
| Log Writes/sec (LOG_WRITES_SEC) |
Total number of log pages written onto a disk | -- | double | No | master..sysperfinfo.log flushes/sec |
| Max Cache Scan (CACHE_MAX_SCAN) |
This field is reserved and cannot be used. | -- | -- | -- | -- |
| Net Queue (NET_QUEUE) |
This field is reserved and cannot be used. | -- | -- | -- | -- |
| Net Reads/Sec (NET_READS_SEC) |
This field is reserved and cannot be used. | -- | -- | -- | -- |
| Net Writes/Sec (NET_WRITES_SEC) |
This field is reserved and cannot be used. | -- | -- | -- | -- |
| Other Processes (OTHER) |
Number of processes of other types | -- | word | No | master..sysprocesses.status |
| Page Reads/sec (PAGE_READS_SEC) |
Total number of physical page read operations | -- | double | No | master..sysperfinfo.page reads/sec |
| Page Writes/sec (PAGE_WRITES_SEC) |
Total number of physical page write operations | -- | double | No | master..sysperfinfo.page writes/sec |
| Pkt Errors (PACKET_ERRORS) |
Number of packet errors | -- | ulong | Yes | @@packet_errors |
| Pkts Rcvd (PACK_RECEIVED) |
Number of packets received | -- | ulong | Yes | @@pack_received |
| Pkts Sent (PACK_SENT) |
Number of packets sent | -- | ulong | Yes | @@pack_sent |
| Process Count (PROCESSES) |
Total number of processes | -- | word | No | master..sysprocesses |
| RA Pages Fetched (RA_PAGES_FETCHED) |
Total number of pages prefetched into the cache by Read Ahead Manager | -- | double | No | master..sysperfinfo.readahead pages/sec |
| RA Pages Found (RA_PAGES_FOUND) |
This field is reserved and cannot be used. | -- | -- | -- | -- |
| RA Reads/sec (RA_READS_SEC) |
Total number of physical read operations executed by Read Ahead Manager | -- | double | No | master..sysperfinfo.page reads/sec |
| RA Slots Used (RA_SLOTS_USED) |
This field is reserved and cannot be used. | -- | -- | -- | -- |
| Reads Pending (READS_PENDING) |
This field is reserved and cannot be used. | -- | -- | -- | -- |
| Record Time (RECORD_TIME) |
Interval end time (GMT format) | -- | time_t | No | Remote Monitor Collector |
| Record Type (INPUT_RECORD_TYPE) |
Record type (always PD) | -- | char(8) | No | Remote Monitor Collector |
| Runnable Processes (RUNNABLE) |
Number of executable processes | -- | word | No | master..sysprocesses.status |
| Running Processes (RUNNING) |
Number of processes being executed | -- | word | No | master..sysprocesses.status |
| Server Name (SERVER_NAME) |
Name of machine on which Microsoft SQL Server is running | -- | string(257) | No | @@servername |
| Shared Intent Locks (SHARED_INTENT) |
Number of shared intent locks | -- | ulong | No | master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
| Shared Page Locks (SHARED_PAGE) |
Number of shared page locks | -- | ulong | No | master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
| Shared Table Locks (SHARED_TABLE) |
Number of shared table locks | -- | ulong | No | master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
| Sleeping Processes (SLEEPING) |
Number of sleeping processes | -- | word | No | master..sysprocesses.status |
| Start Time (START_TIME) |
Interval start time (GMT format) | -- | time_t | No | Remote Monitor Collector |
| Timeticks (TIMETICKS) |
Microseconds per tick | -- | ulong | No | @@timeticks |
| Total Errors (TOTAL_ERRORS) |
Number of disk errors | -- | ulong | Yes | @@total_errors |
| Total Reads (TOTAL_READ) |
Number of disk read operations | -- | ulong | Yes | @@total_read |
| Total Writes (TOTAL_WRITE) |
Number of disk write operations | -- | ulong | Yes | @@total_write |
| Trans/sec (TRANS_SEC) |
Total number of Transact-SQL command batches executed | -- | double | No | master..sysperfinfo.batch requests/sec |
| Update Page Locks (UPDATE_PAGE) |
Number of update page locks | -- | ulong | No | master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
| VA DeviceID(VADEVICEID) | Device ID of virtual agent. | -- | string(256) | No | Remote Monitor Collector |
| Version (SERVER_VERSION) |
Microsoft SQL Server version | -- | string(20) | No | SERVERPROPERTY('productversion') |
| Writes Pending (WRITES_PENDING) |
This field is reserved and cannot be used. | -- | -- | -- | -- |
Copyright (C) 2013, Hitachi, Ltd.
Copyright (C) 2013, Hitachi Solutions, Ltd.