2012年7月17日
How to using Procedure found Lead Blocker
/*IfoundthisscriptbyKalenDelaneyonthissite.Ithinkthismayhelpyoursituation:Listing1:ProcedureThatFindstheHeadofaChainofBlockers*/USEmasterSETQUOTED_IDENTIFIEROFFGOIFEXISTS(SELECT*FROMsysobjectsWHEREname='sp_leadblocker'ANDtype='P')DROPPROCsp_leadblockerGOCREATEPROCEDUREsp_leadblockerA Read More
posted @ 2012-07-17 11:55 Fandy Xie Views(276) Comments(0) Diggs(0)
How to using sys.dm_exec_requests to find a blocking chain and much 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
posted @ 2012-07-17 11:48 Fandy Xie Views(364) Comments(0) Diggs(0)