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
- Why do I sometimes get an
object_idthat doesn't exist in my database (like this question)
- What does
index_idindicate (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?