Watch out for performance problems due to antipattern queries in SQL

Example script to set up the EE Session:

CREATE EVENT SESSION FindAntipatterns ON DATABASE 
ADD EVENT sqlserver.query_antipattern (
    ACTION ( sqlserver.client_app_name, sqlserver.sql_text, sqlserver.query_hash
    )
    WHERE sqlserver.client_app_name <> N'Microsoft SQL Server Management Studio'
      AND sqlserver.client_app_name <> N'Microsoft SQL Server Management Studio - Transact-SQL IntelliSense'
      AND sqlserver.client_app_name <> N'DacFx Deploy'
    )
    ADD TARGET package0.ring_buffer (
        SET max_memory = 1024   -- Units of KB.
    )
    WITH (  EVENT_RETENTION_MODE = ALLOW_SINGLE_EVENT_LOSS, 
            TRACK_CAUSALITY = OFF,
            STARTUP_STATE   = ON
);

ALTER EVENT SESSION FindAntipatterns ON DATABASE STATE = START;

/*
ALTER EVENT SESSION FindAntipatterns ON DATABASE STATE = STOP;
DROP EVENT SESSION FindAntipatterns ON DATABASE;
*/