mssqltips logo

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




More SQL Server Solutions











Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name
*Email
Email me updates

Signup for our newsletter

I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.






download





get free sql tips

I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



Learn more about SQL Server tools