The most recent content from our members.
Description This alert will tell you when an SQL statement has executed more often than it normally does. This example uses a 200% threshold, meaning the SQL has executed twice as many times as normal. The alert definition uses the last 14 days for each SQL statement as the baseline for execution counts per day. It then…
DESCRIPTION This alert is for Oracle instances only and will tell you when SQL statements have executed more than a defined amount of time. This example uses a 300 second threshold, meaning any SQL statements that have been executing for longer than 300 seconds (5 minutes) will be alerted. The alert query executes against…
Description This alert will tell you when an Oracle monitored instance has a SQL that executed more often than it normally averages. This example uses a 200% threshold, meaning the SQL executed twice as many times as normal, as the critical level and 150%-200% as the warning. The SQL code in the alert definition uses the…
Description This alert will tell you when an Oracle monitored instance has a query that returned more rows than it normally averages. This example uses a 200 % threshold (the SQL returned twice as many rows as normal) for the Critical level and 150%-200% for the Warning. The SQL code in the alert definition uses the last…
Description This alert will look for a plan change for the top 50 SQL statements (for the last 14 days). If there are plan changes detected, one email will be sent with all SQLs that experienced plan changes. This alert will work for Ignite 8.2 and higher for SQL Server instances. Alert Definition To create the alert,…
It looks like you're new here. Sign in or register to get started.