• What We Are Working On for DPA (Updated March 13, 2019)

    To receive updates on the DPA roadmap, JOIN thwack and BOOKMARK this page   Here is a partial list of the things we are currently working on. Your comments and feedback are always welcome, and have been vital in...
    Profile Photo
    last modified by cpriddy
  • Create-Update NAMEs for HASHes.txt

    First attempt to create NAMEs for HASHes and insert them into the CON_SQL_NAME table. There are known limitations: - the CON_SQL_NAME table requires a unique HASH and a unique NAME - the CON_SQL_NAME table does NOT ...
    Profile Photo
    last modified by athornbury1
  • Custom Alert - Jobs running longer than usual

    This computes the average duration of a job from the job history tables, and computes a number representing how many times longer it is currently running than usual.   For example. Job1 usually takes 30 minutes...
    Profile Photo
    last modified by glutenfreesql
  • AUTOMATIC SCHEDULLER AS  A TASK OR REPORT WITH GRAPHICS  OF OPCION "RESOURCES"

    I would like to know and suggest the opcion to add the graphics or other information and send it by mail in AUTOMATIC way or using the SCHEDULLER as a task scheduled at night to send by mail. I found a manually opcion...
    Profile Photo
    last modified by oscarguevara
  • Job Failure

    Description This alert will look for jobs that have failed since the last time this alert executed.  The #FREQUENCY# variable provides the number of minutes between each run of the alert (specified in the Executi...
    Profile Photo
    last modified by mandevil
  • PSDPA - Database Performance Analyzer PowerShell Module

    With the release of the Database Performance Analyzer 12.1 and the Management API, I have started developing a PowerShell module called PSDPA. The module is now available through the PowerShell Gallery and GitHub. I w...
    Profile Photo
    last modified by awickham10
  • Custom Alert - Oracle Tablespace Free Space

    Description This alert uses the system view named DBA_TABLESPACE_USAGE_METRICS (Oracle 11.2+) to calculate the free space remaining in all tablespaces. It includes both data and temp tablespaces as well as takes autoe...
    Profile Photo
    last modified by ashrecksiedler
  • Custom Alert - Average Blocking Time per Session

    Description This alert will calculate the average blocking time per session and helps you understand the severity of the issue. It is similar to the Total Wait Time for Blocking - Repository alert in that it uses the ...
    Profile Photo
    last modified by mandevil
  • Custom Alert - SQL with specific text executed

    Description This alert will watch for SQL statements that execute and contain a specific string. For example, if you think a specific table is no longer being used and you want DPA to let you know if it sees any SQL w...
    Profile Photo
    last modified by darichar
  • Custom Alert - AG Data Loss Alert

    DESCRIPTION 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 DEFINI...
    Profile Photo
    last modified by mandevil
  • SQL Server Max Server Memory

    DESCRIPTIONGet the Max Server Memory and plot it over time. Adjust the frequency accordingly, but typically, this metric will not change often.   METRIC DEFINITIONTo create the custom metric, click on Options -&g...
    Profile Photo
    last modified by mandevil
  • Monitor SQL Server Agent - No XP Proc

    Description This custom alert is an improved and more generic alert than here: SQL Server SQL Agent Alert - Monitor SQL Agent. It also does not use external stored procedures and instead uses a DMV internal to the da...
    Profile Photo
    last modified by KMSigma
  • Custom Report - Metric Values

    Description The query below will provide detailed metric values for any metric in the instance, e.g. the metrics shown on the Resources tab in DPA>   Query DECLARE @DBID varchar(100), @MetricName varchar(50), ...
    Profile Photo
    last modified by darichar
  • "DPA Rotator" - Automatically Cycle Through Important DPA Pages

    UPDATE 2018-11-02: New version available (see attached dpa_rotator2.html) - pages can now be scaled (zoomed in or out) - small progress bar at the top - pages truly pre-load for instant display - can be run locally, o...
    Profile Photo
    last modified by mheydman
  • SQL Server SQL Agent Alert - Monitor SQL Agent

    Description This alert uses the external stored procedure named xp_servicecontrol which is not supported. See this custom alert for an alternative: Monitor SQL Server Agent - No XP Proc   This alert will run a...
    Profile Photo
    last modified by darichar
  • Custom Reports - VMware Events

    This custom report can be used to show all events for a specific VM by name. Events include powering on/off a VM, a VM moved from one ESX host to another, etc. before running this script, modify the value of @VMName a...
    Profile Photo
    last modified by darichar
  • Custom Report - VMware Metric Detail

    This custom report will return VMware metric details for the metric name provided in the @MetricName variable and the database name provided in @DBName. The report will also be limited to the date range specified in t...
    Profile Photo
    last modified by darichar
  • O/S CPU Queue Length - uses WMI

    Description DPA stopped using the sp_OA procedures to collect O/S level metrics and started using DMVs. However, the metric O/S CPU Queue Length was not available within a DMV so it was excluded. This document explain...
    Profile Photo
    last modified by darichar
  • CUSTOM METRIC - SYBASE CPU BUSY

    DESCRIPTIONThis custom metric will collect the percentage of CPU work the Adaptive Server spent since the last time Adaptive Server was started.    METRIC DEFINITIONTo create the custom metric, click on Opt...
    Profile Photo
    last modified by ashrecksiedler
  • Custom Alert - Monitor Service Broker Queue Tables

    Description This alert will count the rows in any queue tables and alert you when they are high. If they are high, this could indicate tasks are not getting processed in a timely fashion or processed at all.   Al...
    Profile Photo
    last modified by darichar