Shared Files for Database Performance Analyzer
  • SQL Server Database Size Collector

    DESCRIPTION This alert will collect the size each database in a SQL instance. This example alert is used only for collecting data and would never alert anyone. This data is provided as input for another custom alert named "SQL Server Database Percent Growth". Also shown below is a query that will allow you to report on this data as collected in the Ignite alert tables. ALERT DEFINITION To create this alert, click on Alerts > Manage Alerts tab and create a Custom Alert of type Custom SQL...
    • 7 Nov 2022
  • SQL Server Database Growth

    DESCRIPTION This alert works in conjunction with the SQL Server Database Size Collector alert in this same section. Please install that alert as a requirement for this alert. This alert will review the last 2 days of data from the collector alert and calculate the growth. You can use the thresholds in the alert to get warned when a database grows by more than 10% is a given day as an example. ALERT DEFINITION To create this alert, click on Alerts > Manage Alerts tab and create a Custom Alert...
    • 7 Nov 2022
  • SQL Server Agent Not Running

    DESCRIPTION When the status of a SQL Server agent goes into a state other than "Running", this alert will return a value of 1 (true), otherwise it will return 0 (false). When configuring thresholds for this alert, use the value of 1 as the Critical level and DPA will let you know when the SQL Server agent is not currenty running. ALERT DEFINITION To create this alert, click on Alerts > Manage Alerts tab and create a Custom Alert of type Custom SQL Alert - Multiple Numeric Return and configure...
    • 28 Oct 2022
  • SQL Server Database Offline

    DESCRIPTION When the status of a SQL Server database goes into a state other than ONLINE, this alert will return a value of 1 (true), otherwise it will return 0 (false). When configuring thresholds for this alert, use the value of 1 as the Critical level and DPA will let you know when a database is not ONLINE. ALERT DEFINITION To create this alert, click on Alerts > Manage Alerts tab and create a Custom Alert of type Custom SQL Alert - Multiple Numeric Return and configure as needed.
    • 28 Oct 2022
  • Custom Alert - AG Data Loss Alert

    This alert will query data already collected by DPA to be used in a custom alert. It will trigger based on thresholds you establish for estimated data loss due to latent AG replication. ALERT DEFINITION To create this alert, click on Alerts > Manage Alerts tab and create a Custom Alert of type Custom SQL Alert - Single Numeric Return making it look similar to this example. Alert Name: AG Data Loss Alert Execution Interval: 4 Minutes Notification Text: Potential data loss if forced...
    • 4 Oct 2022
  • Oracle Tablespace Growth Percent

    Description This alert uses the data collected by the Collect Oracle Tablespace Sizes alert job and calculates the growth from one collection to the next. It can then alert when any tablespace grows by more than X% as defined in the thresholds. Alert Definition To create this alert, click on Alerts > Manage Alerts tab and create a Custom Alert of type Custom SQL Alert - Multiple Numeric Return. Configure the alert as needed and paste in the attached query.
    • 30 Sep 2022
  • Oracle - Collect Tablespace Sizes

    Description This alert is used for collection of data only and does not alert or send emails. The data for tablespace sizes is collected and then stored into the DPA alert tables within the repository. At the bottom of this page is a script that can be used to report on this data for charting. Alert Definition To create the alert, click on Alerts > Manage Alerts tab and create a Custom Alert of type Custom SQL Alert - Multiple Numeric Return. Configure the alert as needed and paste in the...
    • 30 Sep 2022
  • Execution Plan Change

    Description This alert provides a list of SQL statements that have experienced an execution plan change within the last hour or whatever the execution interval is defined as. Alert Definition To create the alert, click on Alerts > Manage Alerts tab and create a Custom Alert of type Custom SQL Alert - Multiple Numeric Return. Configure the alert as needed and paste in the attached query.
    • 30 Sep 2022
  • Oracle - Collect Bind Value Samples

    Description Sometimes a SQL statement will execute differently based on the bind value that gets pass in. To collect a sampling of those bind values, this alert can be used to retrieve the values and store them in the DPA alert tables. This alert will never send an email, but is used to collect the data only. At the bottom of this page is a query that can be used to report on this information from the DPA alert tables. Alert Definition To create the alert, click on Alerts > Manage Alerts...
    • 30 Sep 2022
  • Oracle Max Sessions

    DESCRIPTION This alert calculates the percent of sessions used, i.e. the number of current sessions divided by the maximum allowed sessions (SESSIONS parameter). ALERT DEFINITION To create the alert, click on Alerts > Manage Alerts tab and create a Custom Alert of type Custom SQL Alert - Single Numeric Return. Configure the alert as needed and paste in the attached query.
    • 23 Sep 2022
  • Sybase Max Locks

    DESCRIPTION This alert will calculate the ratio of current number of locks (counts rows in syslocks) against the max locks available (number of locks from sp_configure / sysconfigures). ALERT DEFINITION To create the alert, click on Alerts > Manage Alerts tab and create a Custom Alert of type Custom SQL Alert - Single Numeric Return. Configure the alert as needed and paste in the attached query.
    • 23 Sep 2022
  • Oracle Scheduler Job Failures

    Description Some customers execute database jobs using DBMS_SCHEDULER and this alert will notify you of failures in those jobs. Because DPA custom alerts work with numeric returns, this SQL statement changes the status value to one of 0 (normal), 10 (stopped) or 20 (failed) in increasing severity. The thresholds in the alert should be defined accordingly. Alert Definition To create the alert, click on Alerts > Manage Alerts tab and create a Custom Alert of type Custom SQL Alert - Multiple...
    • 23 Sep 2022
  • Oracle Max Locks

    Description This alert will review the number of locks currently being used and compare to the max_locks parameter. Alert Definition To create the alert, click on Alerts > Manage Alerts tab and create a Custom Alert of type Custom SQL Alert - Single Numeric Return. Configure the alert as needed and paste in the attached query.
    • 23 Sep 2022
  • Oracle Flash Recovery Area Free Space

    Description This alert will utilize the V$RECOVERY_FILE_DEST view to calculate free space for each recovery area. If there are multiple recovery areas, this alert will return all that are running low on free space. Alert Definition To create this alert, click on Alerts > Manage Alerts tab and create a Custom SQL Alert with Multiple Numeric Return type. Configure the alert as needed and past in the attached query.
    • 23 Sep 2022
  • Sybase Spinlock Contention

    DESCRIPTION When modifications are made to a cache in Sybase, a spinlock (or mutex) denies all other tasks access to the cache while the changes are being made. Although spinlocks are held for extremely brief durations, they can slow performance in systems with high transaction rates. If spinlock contention is more than 10%, consider using named caches or adding cache partitions. This alert will return a list of all caches along with their spinlock contention which DPA will then compare to the...
    • 23 Sep 2022
  • SQL Server Long Running Query

    DESCRIPTION This alert is for SQL Server instances only and will tell you when SQL statements are currently running and have been for more than a defined amount of time. The query limits the result set to any session that has been running for more than 30 seconds. If you want to catch queries that have been running for more than 5 minutes, set you Critical threshold to 300 seconds for Min and leave Max empty. Also set the execution interval for the alert to 5 minutes or less. ALERT DEFINITION...
    • 23 Sep 2022
  • Oracle Long Running Query

    DESCRIPTION This alert is for Oracle instances only and will tell you when SQL statements are currently running and have been for more than the defined amount of time. For example, if you want to catch any session that runs a query for more than 5 minutes, set your Min threshold to 300 seconds and leave the Max empty meaning anything higher. Also, set the execution interval to 5 minutes or less. ALERT DEFINITION To create the alert, click on Alerts > Manage Alerts tab and create a Custom Alert...
    • 23 Sep 2022
  • Oracle Login Failures

    Description If your Oracle database is configured for auditing, this alert will monitor for logon failures using the DBA_AUDIT_SESSION view. Alert Definition To create the alert, click on Alerts > Manage Alerts tab and create a Custom Alert of type Custom SQL Alert - Single Numeric Return. Configure the alert as needed and past in the attached query.
    • 22 Sep 2022
  • Query Execution Count Anomaly

    Description This alert will tell you when an SQL statement has executed more often in the last 2 hours than it normally does. This example uses a 150% threshold, meaning the SQL has executed 1.5 as many times as normal. The alert definition uses the last 14 days for each SQL statement as the baseline for execution counts per hour. It then compares the number of average executions in the last 2 hours with the baseline to derive the percent increase. It also uses summary data so running it more...
    • 22 Sep 2022
  • Plan Change Caused More Wait Times

    Description This alert will determine if any SQL had a plan change within he last 90 min (configurable in script) that resulted in a higher amount of wait time on average for the query. Plan changes are not necessarily bad, but if the wait times go up, that is a good indication the new plan is not as good as the previous. Alert Definition To create the alert, click on Alerts > Manage Alerts tab and create a Custom Alert of type Custom SQL Alert - Multiple Numeric Return. Configure the alert...
    • 22 Sep 2022