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
https://gallery.technet.microsoft.com/Lead-Blocking-Query-df3f0e21
No comments:
Post a Comment