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
clientoption1
and 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
Last activity: May 18, 2025, 05:08 AM