0

I'm trying to work with the blocked process reports captured using Extended Events and, while I can find numerous blog articles and Q&A about specific details (e.g.1 2 3), I can't find any documentation from MS about the contents of the report & how to interpret each field.

For example, I'd like to know:

  • What are clientoption1and clientoption2
  • Why do I sometimes get an object_id that doesn't exist in my database (like this question)
  • What does index_id indicate (probably answered at link above)
  • How to decode waitresource (here's a start)
  • ... and the list goes on.

I don't just want answers to these questions, I want something more complete.

Is this an undocumented feature or am I just crap at finding it?

Improve this question
8
  • 1
    dba.stackexchange.com/questions/238982/blocked-process-report / michaeljswart.com/2011/04/… might be useful resources
    – Aaron Bertrand
    Sep 29 '20 at 21:21
  • Thanks, yes I've found those helpful. But still, nothing comprehensive from MS.
    – Rory
    Sep 29 '20 at 21:27
  • 2
    If you only want something from MS, you might want to contact MS.
    – Aaron Bertrand
    Sep 29 '20 at 21:30
  • Well, I'm hoping for something comprehensive and well-structured, no you're right it needn't be from MS. Most of the articles and answers I find are quite narrowly focused or just a poor rewrite of someone else's post. Many are also really old, so possibly superseded by better ways of doing things.
    – Rory
    Sep 29 '20 at 21:36
  • 1
    Better ways of doing things with the blocked process report that hasn't changed since 2005? Meh, I doubt it.
    – Aaron Bertrand
    Sep 29 '20 at 21:37
0

fwiw (which isn't much), I asked MS about this and they filed it under "sure, we'll do that later", recommending these docs for now:

  • Blocked Process Report Event Class - describes the event class (I think the article is talking about traces not extended events, but presumably it's still relevant), but doesn't give info about the xml report contents.
  • Understand and resolve SQL Server blocking problems - quite a comprehensive article but unfortunately doesn't talk about the contents of the blocked_process_report.
  • This article addresses the xml_deadlock_report Extended Event for deadlock reports. That's not for blocked process reports but it looks like some of the fields that are documented are the same
Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.