| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | monikerRange |
|---|---|---|---|---|---|---|---|---|
Alter an Extended Events Session |
Use the SQL Server Extended Events Wizard to alter an Extended Events session. Changes you can make depend on whether the session is active and inactive. |
WilliamDAssafMSFT |
wiassaf |
05/24/2019 |
sql |
xevents |
tutorial |
=azuresqldb-current||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current |
[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance]
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.
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