DB Blocking Automated E-mail Alerting with Blocker SP ID & query's

  • Comments posted to this topic are about the item DB Blocking Automated E-mail Alerting with Blocker SP ID & query's

  • Rather than run  the job every 2 minutes why not use SQL Server Agent to run the job when it detects a blocked session?

    1) Set server "blocked process threshold (s)" to the number of seconds after which you want the alert fired
    2) Create an alert in the agent

    • type="SQL Server performance condition alert", 
    • counter = "Processed blocked", 
    • alert if counter ="rises above" , 
    • value = "0".

    3) On the "response" tab, execute your job.(or any job that queries who's blocking who) and email it to yourself.

  • Hi chuck.hamilton,

    Thanks for your suggestion, It's also a batter way to get the blocking detail.  I will try this as well.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply