How to Setup Blocking Alerts on SQL Server

Spread the love

It’s very common for Database professionals to experience blocking. Even though blocking is a usual activity, it can convert into an issue anytime. And becomes pain point when DBAs are not around to monitor blocking in real-time.

For the alternative of real-time monitoring, we can setup alert for blocking using WMI based event BLOCKED_PROCESS_REPORT. With event alert, we can even record the session details by using custom code like procedure [sp_whoIsActive]. For the similar purpose, I recorded below Video presentation.

I hope the video tutorial answered all the queries. Friends, please feel free to correct me by comments. If you like the video, do Like & Share. Happy Coding 🙂

8 Comments

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.