Where is the documentation for sql server blocked process report

Question

Is there any SQL Server reference documentation for the blocked process report, eg how to interpret the data stored in the xml report? I can find a bunch of mostly old blog articles that talk about certain aspects, but nothing comprehensive and up to date.

Answer 1

Hello @Rory ,

Sorry I can’t find the official documentation on how to interpret the data stored in the xml report comprehensively.

Hope these articles can provide some references:

https://cloudblogs.microsoft.com/dynamics365/no-audience/2015/01/16/using-sql-server-extended-events-to-produce-a-blocked-process-report/

https://blog.dbi-services.com/analyzing-easily-the-blocked-processes-report/

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.