HOW TO: Detect Blocking Issues

RockSolid monitors blocking in real-time and can alert on blocking issues as they occur, or provide historical data to aid in post incident root cause analysis.

How To Enable Blocking Data Collection

To enable the collection of blocking data, all that is required is to ensure RockSolid is configured to collect performance data at the instance level.

To facilitate the collection of blocking data, RockSolid will automatically deploy a job to the relevant SQL Server instances called "ROCKSOLID - Monitor database blocking".

No user action is required to maintain this job.

How To Enable Blocking Alerting

Blocking alerting is enabled at the database level.  Blocking alerting can be configured to alert based on the standard RockSolid blocking escalation process, or configured to run in a more sensitive mode for databases which are very sensitive to blocking related issues.

To Configure Blocking Alerting

Navigate to the relevant level in the database hierarchy and select the settings tab to view the policy.

  • Click the Performance tab
  • Under Database Usage set Blocking Analysis to on

To Configure Sensitive Blocking Alerting

RockSolid by default will use an internal algorithm for determining if current blocking is normal or should be escalated as a blocking issue.  This algorithm looks at various factors relating to the blocking including duration and processes impacted.  This is suitable for most environments.

However if a database is highly sensitive to blocking, the RockSolid user can configure a specific blocking threshold (duration in mins) after which the blocking alerts will be raised regardless of concurrency impact.

Navigate to the relevant level in the database hierarchy and select the settings tab to view the policy.

  • Click the Performance tab
  • Under Database Usage set Blocking Analysis to on
  • Set Blocking Sensitive to on
  • In the blocking duration enter the number of minutes, once exceed will raise the blocking alert.  Minimum duration is 1 minute.

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.