![[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 Locks Detail (PD_LOCK) record indicates information related to Microsoft SQL Server 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 |
|---|---|---|---|---|---|
| Exclusive Extent Locks(EXTENT_LOCKS_EXCLUSIVE) | Number of exclusive extent locks | -- | ulong | No | master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
| Exclusive Intent Locks (INTENT_LOCKS_EXCLUSIVE) |
Number of exclusive intent locks | -- | ulong | No | master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
| Exclusive Page Locks (PAGE_LOCKS_EXCLUSIVE) |
Number of exclusive page locks | -- | ulong | No | master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
| Exclusive Table Locks (TABLE_LOCKS_EXCLUSIVE) |
Number of exclusive table locks | -- | ulong | No | master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
| Max Users Blocked (MAX_USERS_BLOCKED) |
Maximum number of users who were blocked by other users during the monitored period | -- | ulong | No | master..sysprocesses.blocked |
| Record Time (RECORD_TIME) |
Interval end time (GMT format) | -- | time_t | No | Remote Monitor Collector |
| Record Type (INPUT_RECORD_TYPE) |
Record type (always LOCK) | -- | char(8) | No | Remote Monitor Collector |
| Shared Intent Locks (INTENT_LOCKS_SHARED) |
Number of shared intent locks | -- | ulong | No | master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
| Shared Page Locks (PAGE_LOCKS_SHARED) |
Number of shared page locks | -- | ulong | No | master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
| Shared Table Locks (TABLE_LOCKS_SHARED) |
Number of shared table locks | -- | ulong | No | master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
| Start Time (START_TIME) |
Interval start time (GMT format) | -- | time_t | No | Remote Monitor Collector |
| Total Blocking Locks (TOTAL_BLOCKING_LOCKS) |
Number of locks that are blocking other processes | -- | ulong | No | master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
| Total Exclusive Locks (TOTAL_EXCLUSIVE_LOCKS) |
Total number of exclusive locks | -- | ulong | No | master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
| Total Extent Locks (EXTENT_LOCKS_TOTAL) |
Total number of extent locks | -- | ulong | No | master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
| Total Intent Locks (INTENT_LOCKS_TOTAL) |
Total number of intent locks | -- | ulong | No | master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
| Total Locks (TOTAL_LOCKS) |
Total number of locks being used by Microsoft SQL Server | -- | ulong | No | master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
| Total Page Locks (PAGE_LOCKS_TOTAL) |
Total number of page locks | -- | ulong | No | master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
| Total Shared Locks (TOTAL_SHARED_LOCKS) |
Total number of shared locks | -- | ulong | No | master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
| Total Table Locks (TABLE_LOCKS_TOTAL) |
Total number of table locks | -- | ulong | No | master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
| Update Extent Locks (EXTENT_LOCKS_UPDATE) |
Number of update extent locks | -- | ulong | No | master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
| Update Page Locks (PAGE_LOCKS_UPDATE) |
Number of update page locks | -- | ulong | No | master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
| Users Blocked (USERS_BLOCKED) |
Number of users who are blocked by other users | -- | ulong | No | master..sysprocesses.blocked |
| VA DeviceID(VADEVICEID) | Device ID of virtual agent. | -- | string(256) | No | Remote Monitor Collector |
Copyright (C) 2013, Hitachi, Ltd.
Copyright (C) 2013, Hitachi Solutions, Ltd.