Hi Everyone,
The system_health session is an extended event session that is included by default with SQL Server. This blog post goes over how to easily read and interpret System Health extended event and sp_server_diagnostics with an example. For this post, we will focus on what sp_server_diagnostics reports during the period of 3/15/2023 at 4:00am to 3/15/2023 at 11:20am.
Let us say you are being approached to figure out the reason for a glitch during this time window, even if you did not have any monitoring solution in place, you can still tap into system_health session since