Shared Files for Database Performance Analyzer
  • Database SQL Alert

    I had a customer ask if they could get alerted from DPA when any SQL statement exceeded X seconds in a 10 minute timeframe. This is the alert (Custom SQL Alert - Multiple Numeric Return type) we ended up with and here is the SQL statement used: SELECT 'DB: ' + db.name + ' - SQL: ' + convert(varchar(20), sw.izho), sum(sw.qp/100) timesecs FROM ignite.consw_#DBID# sw INNER JOIN ignite.cono_#DBID# db on db.id = sw.ixoy WHERE sw.d >= datediff(mm, -#FREQUENCY#, current_timestamp) GROUP BY db.name...
    • 23 Jun 2022
  • SQL Server Restart Alert

    DPA has a base alert named Database Availability that will notify you if an instance is down. However, alerts can only execute at most once per minute, and if an instance goes down briefly with an immediate restart, the alert can miss the downtime. This new custom alert will let you know anytime a SQL Server instance restarts no matter how long it takes. Note: that this alert will not warn you about downtime until the instance has restarted. Because of that, this alert should be used in conjunction...
    • 26 May 2022
  • DPA Free Disk Space Alert using PowerShell

    Alerting on free disk space for your SQL Server instance is not a base alert within DPA. This is because the information is not readily available from within the database instance via a query. However, using xp_cmdshell and a PowerShell command, we can add a custom alert to DPA to handle this. Note: the xp_cmdshell option is disabled by default on SQL Server instances. For this alert to work properly, xp_cmdshell must be enabled. When creating the alert in DPA, create a Custom Alert of type "Custom...
    • 31 Mar 2022
  • Sessions Blocking for More Than X Minutes

    When it comes to blocking, DPA can currently alert when the cumulative blocking time goes beyond a threshold. The alert can be found under the category of Wait Time and is named Total Blocking Wait Time. However, one drawback to alerting on cumulative blocking time, is that it can potentially be noisy in a busy server. For example, lets take 2 blocking scenarios: 10 root blocker sessions each blocking 20 other sessions for 15 seconds 1 root blocker session blocking 2 other sessions for 150...
    • 13 Jan 2022
  • Long Running Queries

    Description It's important to identify and investigate if there are any long running queries in your PostgreSQL database(s). These long running queries may interfere in overall database performance and could be the result of a stuck background process. This alert utilizes pg_stat_activity to monitor all non "autovacuum" related queries and notifies you if there are queries running longer than the defined thresholds. Alert Definition To create the alert, click on Alerts > Manage Alerts tab...
    • 1 Apr 2021