SP I promised during TechNet Gig on SQL Performance which will identify blocking spid at top of blocking chain : sp_blocker_pss80

Please follow the link below to the MS KB article containing the above SP.

Note the ‘fast’ parameter to improve performance by reducing the amount of extra diagnostic info returned.


Hope you find it useful!


Comments (0)