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 🙂