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
clientoption1
andclientoption2
- 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?