{"ID":"e1809f74-1b4e-4f22-a63f-246765e4d7a8","VersionNumber":15,"Name":"AWS Timeouts Detected","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

Returns a count of Top SQL timeouts for Amazon AWS targets. Alert will trigger if there is a count higher than 0.

 

Author: Dexter Cox

\r\n\r\n","AppliesToObjectTypeID":"894de672-3fc0-4779-9a0d-880d4c207c77","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\":\"f2e88d72-73c6-4ce1-b92a-029c313e707f\",\"Query\":\"SELECT COUNT(*) FROM [SentryOne].[dbo].[PerformanceAnalysisTraceData] patd\\r\\nJOIN EventSourceConnection esc ON patd.EventSourceConnectionID = esc.ID\\r\\nWHERE esc.ObjectName LIKE '%AMAZONAWS%'AND Error > 0 \\r\\nAND NormalizedStartTime > dateadd(minute, -5, getutcdate())\",\"InstanceType\":0},\"ComparisonType\":2,\"Right\":{\"ValueTypeID\":\"07f87b7f-c063-47a2-a5be-772ba85ed827\",\"Value\":\"0\"},\"ID\":\"1\"}],\"BooleanOperationType\":0,\"ID\":\"0\"}","EvaluationFrequency":"00:05:00","IdlePeriod":"00:00:00","MaximumAllowedDuration":"00:00:05","AntiConditionID":"744b67ef-bf51-4cdd-bb89-1ca87997553a","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":2,"Signature":{"ConditionID":"e1809f74-1b4e-4f22-a63f-246765e4d7a8","VersionNumber":15,"AppliesToObjectTypeID":"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\":\"f2e88d72-73c6-4ce1-b92a-029c313e707f\",\"Query\":\"SELECT COUNT(*) FROM [SentryOne].[dbo].[PerformanceAnalysisTraceData] patd\\r\\nJOIN EventSourceConnection esc ON patd.EventSourceConnectionID = esc.ID\\r\\nWHERE esc.ObjectName LIKE '%AMAZONAWS%'AND Error > 0 \\r\\nAND NormalizedStartTime > dateadd(minute, -5, getutcdate())\",\"InstanceType\":0},\"ComparisonType\":2,\"Right\":{\"ValueTypeID\":\"07f87b7f-c063-47a2-a5be-772ba85ed827\",\"Value\":\"0\"},\"ID\":\"1\"}],\"BooleanOperationType\":0,\"ID\":\"0\"}","PublisherID":0,"PublishDateUtc":"2020-05-11T20:36:50","Rights":0,"SignatureVersion":1,"SignaturePublicKey":"uzJQ9gzevXFwOgw/hkcAtD+cA/bBbD1PRzhEZCxbZ6YwjJ1c9bbfXFItLQNwnm8bdWh2k57//qbpEj5DFHOW2EAjHc2Zw5m/vACm6OzelubPS5hbWvzshlaBJKm7KrpWQpPZClx/5eVvUVzOtlz+44RRTiOszObT58acJAQwA70=AQAB","Signature":"ojUqeUzc/dE1qibktglcOrqtSHYXfAabH9j91vaDXfUZPmUpA+dPLwKZFIRIwHwUgGtRNTGYaC4lFqGPKmRJduJ/zhTJVdPXGTD5kwE8Mg95j1eYGCR0DlW6/YWfOQ5HS4XjX2AJPGreWVP0Hs3D3hcDARTfC4Ta4TYTjWSqI1Q=","IsSelfPublishedCondition":true},"Tags":null,"Areas":[],"ConditionSystemVersion":3,"MinDBSchemaVersion":null,"MaxDBSchemaVersion":null,"Items":[]}