Shared Files for Database Performance Analyzer
  • 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