/*IfoundthisscriptbyKalenDelaneyonthissite.Ithinkthismayhelpyoursituation:Listing1:ProcedureThatFindstheHeadofaChainofBlockers*/USEmasterSETQUOTED_IDENTIFIEROFFGOIFEXISTS(SELECT*FROMsysobjectsWHEREname='sp_leadblocker'ANDtype='P')DROPPROCsp_leadblockerGOCREATEPROCEDUREsp_leadblockerA Read More
As with every good DBA's toolbox, my blocking list query using sys.dm_exec_requests is evolving.I've added the following features:The query execution plan of the active request in the QueryPlan column to the right.Variable at the top which changes the relationship of the join between sys.dm_ Read More