Alter an Extended Events Session

 

Applies To: SQL Server 2016

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2014)yesAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

After you create an Extended Events session, you can alter it according to your needs using the SQL Server Extended Events Wizard.

You cannot alter a target for active and inactive sessions, and you cannot change the advanced properties configurations for an active session.

You can make the following alterations to both active and inactive event sessions:

  • Add or remove events from the session, and alter the event configurations such as event fields, filters and actions.

  • Add or remove a target from the event session.

  • Enable the Start the event session on server startup option.

You can make the following additional alterations to an inactive event session:

  • Enable the Track the relationship between events option.

  • Change the advanced properties configuration.

System_CAPS_ICON_note.jpg Note


The SQL Server Extended Events Wizard does not support event session modification.

  • In Object Explorer, expand Management, expand Extended Events, and then expand Sessions.

  • Right-click the session you want to alter, and then click Properties.

  • In the Properties dialog box, make the appropriate changes, and then click OK.

ALTER EVENT SESSION (Transact-SQL)
Create an Extended Events Session Using Query Editor

Community Additions

ADD
Show: