DPA 2021.1 Released!

with No Comments
The wonderful SolarWinds DPA has just come in a new version – 2021.1, and with that some nice new features that we will take a look at.

Find SQL – New view to find ALL SQL queries

Before we typically just saw the slowest top n queries running on an instance. Now every query is there for you to search for and to analyze in more details. You don’t need to know the whole query to find it, DPA has a powerful build in search tool so you easily can find the query you are interested in. Search for any part of the query, the table names, column used or any other SQL statements. And that is not enough, you can combine that with filters as well. You can also filter by:
  • Database user
  • Application
  • Querying machine
  • Database

Microsoft SQL Server TempDB Analysis

You want to know what was happening in the TempDB when you did “something else more important than looking at your SQL”? Now DPA does that for you. TempDB health is critical for the performance of some queries. When active transaction results can’t fit in memory they are stored in TempDB instead. Knowing how much of TempDB is used can be very important.

Microsoft SQL Server Backup Analysis

DPA now tracks how backup jobs are ran, or don’t ran. The impact of backup jobs and how the transaction log is affected.

New Enhanced Charts for Resource Metrics

Maybe you saw that the graphs above didn’t look like they use to do. If you use Orion as well, maybe you recognize them. All the resource graphs in DPA is new and shiny. Easy to use and easy to see the actual values you are interested in. Just point in the graph and you will see the exact values. If the values are close to your thresholds you will see that info as well, just as in Orion.

And more…

Is there more new features? Yes, there is some more:
  • New Security Role for user management
  • DPA Repository support for MySQL 8
  • Reduced Privilege Registration of Databases
  • Support for Analyzing IBM DB2 11.5
  • … and of course the usual list of Security and Bug fixe
See them all on https://thwack.solarwinds.com/t5/DPA-Discussions/SOLARWINDS-DATABASE-PERFORMANCE-ANALYZER-DPA-2021-1-RELEASE-IS/td-p/616458
Need assistance or want to try out DPA yourself? Nethouse is here to help!
Follow Thomas Löfstrand:

With over 20 years of experience in the IT industry, Thomas have a solid experience from many aspects of the IT infrastructure area. For the past 15 years, monitoring of the IT environment has been the focus and Thomas is now one of the Nordic region's most experienced consultants in Solarwinds Orion. Experience that is used to build and analyze solutions that fit into the customer's environment and working methods. Thomas is recently chosen as a Solarwinds Channel Champion in recognition of his expert knowledge and experience.

Leave a Reply