The system_health Session
The system_health session is a predefined Extended Events session that collects system data to help troubleshoot issues in the Database Engine. The session collections information associated with high-severity errors, deadlocks, nonyielding scheduler problems, and sessions that have had to wait a long time for locks or preemptive (OS) waits. This session starts when SQL Server starts and outputs data to a ring buffer as well as a file on the file system. You can disable or modify this session, but it is recommended that you do not because it can trap a lot of useful information that can be used to troubleshoot and fix SQL Server problems.
Get Microsoft SQL Server 2012 Bible now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
