Number of Blocking Processes (BlockerProcs)
Provides information about processes that are holding locks and blocking other processes longer than the time period set by 'Number of blocking processes' configuration which is defined in the time based parameters section and it can be configured by the user.
Generates annotation - ✅️
BMC PATROL properties
Property | Default value |
|---|---|
Application class | MSSQL_SERVER_SERVER_HEALTH |
Command type | NA |
Platform | All |
Icon style | State Boolean |
Unit | None |
Border range | 0 to 1 : Alarm |
Alarm1 range | 0 to 1 : Alarm |
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 Health |
Key Performance Indicator | Yes |
Monitor for abnormalities | No |
Graph by default | No |
Availability | No |
Response time | No |
Normal distribution | No |
Statistical | No |