349
Overview
Along with your own extended events sessions that you can create, there are built-in extended events sessions that you can use to help monitor SQL Server.
Explanation
SQL Server System_health Extended Events Session
This extended events session is installed by default during the installation of SQL Server and starts automatically when the SQL Server instance is started. It collects system information that can help you monitor the overall health of your SQL Server system.
Some of the events that this session monitors are:
- errors with severity >= 20
- deadlocks
- latch waits > 15 sec
- lock waits > 30 sec
- connectivity errors
- security errors
SQL Server Alwayson_health Extended Events Session
This extended events session is created when you create an availability group. It captures a subset of the availability group events that are related to the AlwaysOn feature.
Some of the events that this session monitors are:
- replica state changes
- errors in connectivity
- ddl_executed
- errors – replica role change
Additional Information
