Ads

25 December 2014

To Find Lead Blocking - Use Below Query

This will list out the lead blocker spid, based on this we can ask our application teams take decision to kill or not. This will be used in day to day basis when ever application team reports hampering performance or complaining the time taken to process is longer than the usual.

https://gallery.technet.microsoft.com/Lead-Blocking-Query-df3f0e21

No comments:

Post a Comment