Find SQL – New view to find ALL SQL queriesBefore 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
- Querying machine
Microsoft SQL Server TempDB AnalysisYou 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 AnalysisDPA 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 MetricsMaybe 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
Need assistance or want to try out DPA yourself? Nethouse is here to help!