{"ID":"25d5612e-6152-45d5-9857-a69997282f57","VersionNumber":1,"Name":"XE Session - Event Warning","Description":"\r\n\r\n\t\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\r\n\t\r\n\t\t

Alerting on running XE sessions.

 

Alerting on any session that is retreiving any of the below events:

query_post_compilation_showplan

query_post_execution_showplan

query_pre_execution_showplan

 

\r\n\r\n","AppliesToObjectTypeID":"0a11a887-823a-4461-87af-321cad1c3623","ConditionCategoryID":"805a84c9-7f1b-4b4d-a9ad-3dddcf9e0f17","OwnerObjectID":"b7c74f24-1a45-4115-8262-d7613878bbd6","OwnerObjectTypeID":"894de672-3fc0-4779-9a0d-880d4c207c77","RuleDefinition":"{\"OperationTypeID\":\"6c3d38f1-9317-4258-972a-cfee0a0d76b5\",\"Children\":[{\"OperationTypeID\":\"8fa3cd6a-960c-43bb-96e0-94092fc2c296\",\"ValueDataTypeID\":\"b35a57f5-b8f6-4e4e-9380-e9d328e3eabf\",\"Left\":{\"ValueTypeID\":\"aa61ee90-8a95-4fdf-a208-b9a4afa26d9d\",\"Database\":\"master\",\"Query\":\"SELECT s.name, COUNT(1) AS EventWarnings\\r\\nFROM sys.dm_xe_sessions AS s\\r\\nINNER JOIN sys.dm_xe_session_events AS e\\r\\nON s.address = e.event_session_address\\r\\nWHERE event_name='query_post_compilation_showplan' OR event_name='query_post_execution_showplan' \\r\\nOR event_name='query_pre_execution_showplan'\\r\\nGROUP BY s.name\",\"InstanceType\":1},\"ComparisonType\":2,\"Right\":{\"ValueTypeID\":\"07f87b7f-c063-47a2-a5be-772ba85ed827\",\"Value\":\"0\"},\"ID\":\"1\"}],\"BooleanOperationType\":0,\"ID\":\"0\"}","EvaluationFrequency":"00:00:30","IdlePeriod":"00:00:30","MaximumAllowedDuration":"00:00:05","AntiConditionID":"3336c0d2-cc51-482a-8199-f2df6e9b0e92","MinWindowsVersion":null,"MaxWindowsVersion":null,"MinSQLServerVersion":null,"MaxSQLServerVersion":null,"MinSSASVersion":null,"MaxSSASVersion":null,"MinVmwareVersion":null,"MaxVmwareVersion":null,"MinSqlDbVersion":null,"MaxSqlDbVersion":null,"MaximumInstanceCount":1,"ColorIndicator":null,"Severity":1,"Signature":{"ConditionID":"25d5612e-6152-45d5-9857-a69997282f57","VersionNumber":1,"AppliesToObjectTypeID":"0a11a887-823a-4461-87af-321cad1c3623","RuleDefinition":"{\"OperationTypeID\":\"6c3d38f1-9317-4258-972a-cfee0a0d76b5\",\"Children\":[{\"OperationTypeID\":\"8fa3cd6a-960c-43bb-96e0-94092fc2c296\",\"ValueDataTypeID\":\"b35a57f5-b8f6-4e4e-9380-e9d328e3eabf\",\"Left\":{\"ValueTypeID\":\"aa61ee90-8a95-4fdf-a208-b9a4afa26d9d\",\"Database\":\"master\",\"Query\":\"SELECT s.name, COUNT(1) AS EventWarnings\\r\\nFROM sys.dm_xe_sessions AS s\\r\\nINNER JOIN sys.dm_xe_session_events AS e\\r\\nON s.address = e.event_session_address\\r\\nWHERE event_name='query_post_compilation_showplan' OR event_name='query_post_execution_showplan' \\r\\nOR event_name='query_pre_execution_showplan'\\r\\nGROUP BY s.name\",\"InstanceType\":1},\"ComparisonType\":2,\"Right\":{\"ValueTypeID\":\"07f87b7f-c063-47a2-a5be-772ba85ed827\",\"Value\":\"0\"},\"ID\":\"1\"}],\"BooleanOperationType\":0,\"ID\":\"0\"}","PublisherID":0,"PublishDateUtc":"2020-12-01T13:24:28","Rights":0,"SignatureVersion":1,"SignaturePublicKey":"uzJQ9gzevXFwOgw/hkcAtD+cA/bBbD1PRzhEZCxbZ6YwjJ1c9bbfXFItLQNwnm8bdWh2k57//qbpEj5DFHOW2EAjHc2Zw5m/vACm6OzelubPS5hbWvzshlaBJKm7KrpWQpPZClx/5eVvUVzOtlz+44RRTiOszObT58acJAQwA70=AQAB","Signature":"Hfwe4rhNgxImTRELMv780ziBl1ZnfBNrVB6rjoqNUEUz5JCjhXMUfcIdiXGVY3yjlo4N9iSZRErTiq5/4w8bqt6Li/7kZrMg2RSz5rlKR6US/RGU+fLWprnceH0Ie5tTMT8VvmJDosrPjxuK3QPLcF4HRJP+Q58kuILJTHsQRNw=","IsSelfPublishedCondition":true},"Tags":null,"Areas":[],"ConditionSystemVersion":3,"MinDBSchemaVersion":null,"MaxDBSchemaVersion":null,"Items":[]}