Built in SQL Server Extended Events Sessions



By:
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.

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 to 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

Last Update: 6/14/2019






Comments For This Article





download


get free sql tips
agree to terms


Learn more about SQL Server tools