September 4, 2013 at 10:12 am
a short piece on how to identify a blocking chain and find the root blocker.
September 4, 2013 at 10:31 am
If you don't mind waiting a few months, I can pick this one up.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 4, 2013 at 10:41 am
I'd prefer to get a few of these done in the next month or two.
September 4, 2013 at 11:02 am
'k. The earliest I could get started is after PASS. Too much happening before that.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 4, 2013 at 6:35 pm
I have a routine I use regularly based on the DMVs to trace a blocking hierarchy which I'd be happy to share/explain.
September 4, 2013 at 6:39 pm
Take it, plamber. Give us a description of a blocking chain, show your code with an example that decodes a few blockers to find the root.
September 4, 2013 at 7:50 pm
Submitted - fingers crossed my first attempt at a public piece of writing passes muster.
September 5, 2013 at 8:08 am
no worries. We'll give you feedback and work through it.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply