We are excited to announce that the SolarWinds® Database Performance Analyzer (DPA) release 2019.4 is now available!
Note that this is the first release using the new DPA version numbering format.
DPA 2019.4 is the next release following DPA version 12.1.
DPA 2019.4 provides numerous enhancements including:
DPA 2019.4 and DPAIM 2019.4 add the ability to analyze Azure SQL Managed Instance databases for the first time.
They also add support for the following new database versions:
Create multiple email templates that can be customized for specific alert types with specific text and contextual variable values.
Custom email templates for alerts can be advantageous in many circumstances.
Examples include providing additional details useful for specific alerts, adhering to organizational message formatting standards, and enabling easier automated parsing of messages.
DPA 2019.4 has added significant email alert customization enhancements including the ability to:
The ability to create meta-data (custom property) variables and assign values to each monitored DB instance can provide useful contextual information to an alert. For example, custom properties could be used to identify what line of business or application uses the database, its business criticality, or even the responsible DBA's contact information. Having this information available can help expedite assignment and properly prioritize received alerts.
Custom properties can both be defined and assigned different values for each monitored DB instance via REST APIs. Custom property variables can also be added to alert email template definitions and have their values displayed in generated alert emails.
When performance tuning a table, many experienced DBAs verify the table and its related index definitions against a checklist of common best practices. Now DPA's Table Tuning Advisor automatically assesses and advises on table best practices. Not only does this save time for DBAs, but the recommendation is helpful for application developers who may not even be aware of the best practices in the first place.
The example above shows that 2 of 5 best practices are not being followed for a table.
A hidden and difficult-to-diagnose root cause of poor query performance occurs when the VM supporting a database sits waiting for all of its configured virtual CPUs (vCPUs) to become available. VMWare tracks this as Co-Stop time. Even if nothing changes for the database or its application, a change in configuration or addition of unrelated VMs on the same vSphere host may periodically contend for vCPU resources. Instead of rapidly executing a query, the DB instead sits paused, waiting to run.
For instances licensed with the VM Option, DPA now monitors two new CPU resources metrics (VM Total Co-Stop Time and VM Co-Stop Percentage) that track the time a DB's VM is queued waiting for contested vCPUs. If a query shows an unusually large amount of Memory/CPU wait time, you can check to see how long the database's VM was paused because of VM CPU resource contention.
DPA graph annotations are often used to provide additional contextual information about what occurred at a particular point in time. This information can be helpful to identify the reasons behind subsequent changes in resource usage or query performance.
For instances licensed with the VM Option, DPA now extends VM Event annotations to display in the Query Performance Analyzer graphs for all virtualization related metrics such as VM CPU Usage Percentage, VM Co-Stop, and VM Disk Usage Rate.
For example, the VM containing a database was VMotioned to another host with different resources and contending VMs. Soon after, the response time of several queries rapidly degraded. DPA detects the VMotion event and creates a corresponding graph annotation point. A DPA user looking at various trend resource graphs will see the annotation, the subsequent performance impacts, and realize the problem is related to resource contention in the new VM Host.
Multiple REST APIs have been added in this release, allowing enhanced integration and management automation of DPA. Some of the newly created APIs enable you to manage:
For customers using DPAIM to integrate DPA information into Orion Dashboards, Perfstack, and more, the new release of DPA Integration Module 2019.4 for Orion includes:
Don't see what you are looking for here? Check out the What We Are Working On for DPA (Updated October, 2019) post for what the DPA team is investigating.
If you don't see everything you've been wishing for there, add it to the Database Performance Analyzer Feature Requests.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process. Learn more today by joining now.