APC_plans_that_are_not_corrected.sql

/*
Original link: https://blogs.msdn.microsoft.com/sqlserverstorageengine/2017/07/18/monitoring-automatic-tuning-actions-using-xevents/
Author: Jovan Popovic
*/

IF SERVERPROPERTY('ProductMajorVersion') < 14
RAISERROR ('Your version of SQL Server is not supported! This extended event works only for version >= 2017 RC1', 20, 1) WITH LOG;

IF EXISTS (SELECT 1 FROM sys.server_event_sessions WHERE name = 'APC_plans_that_are_not_corrected')
    DROP EVENT SESSION [APC_plans_that_are_not_corrected] ON SERVER;
GO

CREATE EVENT SESSION [APC_plans_that_are_not_corrected] ON SERVER
ADD EVENT qds.automatic_tuning_plan_regression_detection_check_completed(
WHERE ((([is_regression_detected]=(1))
  AND ([is_regression_corrected]=(0)))
  AND ([option_id]=(1))))
ADD TARGET package0.event_file(SET filename=N'plans_that_are_not_corrected')
WITH (STARTUP_STATE=ON);
GO

ALTER EVENT SESSION [APC_plans_that_are_not_corrected] ON SERVER STATE = start;
GO