Average Wait Time (ms) (AverageWaitTimems)
The average amount of wait time (in milliseconds) for each lock request that resulted in a wait.
The performance-related mappings are defined in the PerfmonMapping.xml file available in the %PATROL_HOME%\mssql\configuration directory on the PATROL Agent computer.
BMC PATROL properties
Property | Default value |
|---|---|
Application class | MSSQL_SERVER_PERFMON_LOCKS |
Command type | NA |
Platform | All |
Icon style | Graph |
Unit | Ms |
Border range | Undefined |
Alarm1 range | Undefined |
Alarm2 range | Undefined |
Scheduling (poll time) | Inherited |
Active at installation | Yes |
Parameter type | Consumer |
TrueSight/ BMC Helix Operations Management properties
Property | Default value |
|---|---|
Monitor type | MS SQL Server Perfmon Locks |
Key Performance Indicator | No |
Monitor for abnormalities | No |
Graph by default | No |
Availability | No |
Response time | No |
Normal distribution | No |
Statistical | No |