cpriddy · Staff Product Manager

Thanks for catching that some of the original 2023.2 document links later adjusted to become 2023.2.1 file names. I've updated several links in the blog to be correct

Hi James, The current email templates provide numerous variables about the alert, database, links to alert details, and also custom properties. Go to Alerts->Manage Alerts->email templates to create and configure email templates using multiple variables. The custom properties capability was introduced a couple of releases…

Support for Db2 11.5 has been added as of the DPA 2021.1 Release.

For everyone wanting to programmatically manage DPA Alerts, Alert Groups, and Email Templates, DPA 2019.4 now provides REST APIs to: * Manage Alert Group Database Instance assignments * Manage Alert Email Templates * Manage Alert Definitions * Manage Database Custom Properties and Database Instance value assignment In…

The DPA 2023.2.1.504 Service Release is back up and available for download from the SolarWinds Customer Portal. Thanks again for identifying the problem.

For everyone wanting to customize DPA Alert Emails, DPA 2019.4 now provides the ability to: * Create multiple Alert Email Templates with custom subject and body content * Designate a Default Email Template * Configure an alert to use a specific email template or use the currently designated default * Add variables to…

@"the_ben_keen" You can now analyze Google Cloud SQL for MySQL database instances with DPA 2022.2!

Database Performance Analyzer release 2020.2 now officially supports PostgreSQL including the following: * Standard PostgreSQL * EDB Postgres Advanced Server (EPAS)* Including the Oracle Syntax option * Amazon RDS for PostgreSQL * Amazon Aurora for PostgreSQL * Azure DB for PostgreSQL See the Thwack DPA 2020.2 Release…

For everyone wanting to customize DPA Alert Emails, DPA 2019.4 now provides the ability to: * Create multiple Alert Email Templates with custom subject and body content * Designate a Default Email Template * Configure an alert to use a specific email template or use the currently designated default * Add variables to…

Zachary - There is an early DPA PostgreSQL Beta (really an Alpha) going on currently. We are in need of people to capture information about their environment and their queries for us to help us validate assumptions and also test out our SQL parsing/normalization to unique hash ids. The DPA PostgreSQL Beta includes 3…

We're systematically working on the UI to make different pages take advantage of a wide screen. For instance, you can see in the DPA 2021.3 release that the Resources tab metric graphs and Query Performance Analyzer pages will expand to width of your browser. 

The syntax specified above for Rule 3 is a bit confusing as it might imply you are wanting rule 3's "Custom Properties: Rule = ..." clause to pull out only the custom property clauses in the other two rules but ignore the database type. Ignoring the syntax, my interpretation of your intent is that you want Rule 3 to match…

The ability to customize the subject and body of an email, including the ability to drag and drop multiple variables related to the instance or alert, has been provided as of release 2019.4.

For everyone wanting to customize DPA Alert Emails, DPA 2019.4 now provides the ability to: * Create multiple Alert Email Templates with custom subject and body content * Designate a Default Email Template * Configure an alert to use a specific email template or use the currently designated default * Add variables to…

Db2 11.5 is now supported in the DPA 2021.1 release made generally available January 20, 2021

As of the DPA 2020.2.1 (SR1) release, customers can use the mass registration option to register the following database types without requiring advanced permissions: * Oracle * Amazon RDS Oracle * Microsoft SQL Server * Amazon RDS SQL Server * SAP ASE (Sybase) DPA registration wizards require system administrator…

For everyone with Azure SQL Managed Instances, DPA 2019.4 RC now supports monitoring Azure SQL Managed Instances in addition to Azure SQL Databases. Find out more at Database Performance Analyzer Release Candidate

Sorry @"k_bolt", Thanks for the note. The DPA 2023.2.1.504 release seems to have slipped from the Customer Portal. The DPA Integration Module (DPAIM) has the correct Orion/HCO version of 2023.2.1 but that won't help with getting the correct DPA Server version download. We're working to get the latest DPA service release…

DPA 2019.4 now provides the ability to create custom email templates and generate email previews for all alert levels defined for an Alert. Check out Database Performance Analyzer Release Candidate

Hi skamen No specific timeline for Aurora PostgreSQL. Definitely in the backlog to provide, but it may not make it into the first release.

For those interested in DPA SAML support, which SAML Identity Providers (e.g., Okta, Azure, ... ) should DPA prioritize?

Numerous metrics tracking TempDB has been added to the Resources tab as of DPA Release 2021.1. 

DPA 2020.2 Release now supports this feature request. On supported Alert types there is now a "NORMAL" status that you can assign a notification list for email or SNMP traps. If the notification policy is set to "Notify when level changes", and the alert returns to NORMAL from another status, the clearing or normal alert…

Hi @"diablojeep" DPA is not directly communicating with or monitoring communication from DB application clients like Dapper. DPA is only presenting/storing information about the query that it accesses from SQL Server dictionary views and stored procedures. So the SQL Server itself is executing the modified query as if…

@"holbms" Here's a recent Thwack article "How to Send DPA ALerts to Ticketing Systems Like SolarWinds ServiceDesk and ServiceNow" describing how to setup Orion/HCO translation of DPA notification traps into SNOW incidents. Also @"dkoceja" - we've announced in the Thwack DPA What We're Working On that we are working on a…

If you know what SQL statement or tables/columns is used for SQL Jobs admin, you could use the DPA "FindSQL" feature and filter SQL statements by portions of the text and what time, users, applications, or client hosts requested their execution. However, DPA shouldn't be used as an auditing tool. While DPA collects…

Not sure about which training session may include. But the DPA Administration Guide can give you the basics of how but here's a sequence of screen captures to show how I set up a custom property "Application Name(s)" and assign values for that custom property to different DB instances, then create a rule to match Oracle…

Alert Groups are setup so that you can assign a subset of alert definitions to a specific set of DB instances. You cannot take advantage of rules to automate inclusion/exclusion either of the list of selected alerts or the list of DB instances to assign the alerts. All alert and instances in the alert group must be…

Hi @"guruN" You can accomplish the above by using two features in DPA (Alert Rules and Custom Properties): * Creating Custom Properties (e.g., RelatedApplication) and assign values for the custom property to your DB instances (e.g., set DB 1, 2, 5 RelatedApplication custom property value to "ecommerceApp" and for DBs 3 and…

Hi @"astsane" , The registration/integration of Orion/HCO DPA Integration Module (DPAIM) with one or more DPA Servers, can be tricky at times. Please refer to the following online documentation about DPAIM setup and use: * Starting with the overview -View DPA data in the SolarWinds Platform * DPA and SAM integration with…