Sample Header Ad - 728x90

Where is the documentation for SQL Server's blocked process report?

1 vote
1 answer
279 views
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?
Asked by Rory (1330 rep)
Sep 29, 2020, 08:57 PM
Last activity: May 18, 2025, 05:08 AM