We’re pleased to announce that the Third Release Candidate of SolarWinds® DPA 2020.4 is now available.
You can find the available release candidates for DPA in the SolarWinds® Customer Portal.
DPA 2020.4 RC3 resolves a problem experienced by a few customers where the DPA Server periodically crashes after a few days.
In this release, you’ll find the following enhancements:
We look forward to hearing your feedback on this release candidate as you begin to use these new features in your day-to-day workflow.
Installed DPA 2020.4 this morning, no issues with installing (brand new server). After a few hours of data gathering I could not wait anymore so I had to try it out.
Find SQL: Very nice feature! Simple/advanced mode: feel it’s not that intuitively how to alter that.
New graphs in resources, I like! TempDB usage is very nice. The backup graphs, not sure how to use many of them.
Thanks for the feedback!
On your comment of the simple/advanced mode not being intuitive: Is it the toggling between simple/advanced that isn't intuitive or how to use simple vs. advanced mode syntax and options?
By the way, did you follow the links to the FindSQL documentation, and was the content there helpful? Anything missing or confusing?
On the backup graphs, were there any particular graphs you would like to see better descriptions of?
Here's some more information for 3 of these:
Thanks for the info!
Simple/advanced: I would think of the popup in FindSQL as a help-text/tips-text. I would not expect to have a switch there. The link that alters between simple and advanced could easily be mistaken for a link to additional help or so. For filters there is a distinct button, but for simple/advanced its a link in a popup. Easy when you know about it but could be clearer.
FindSQL documentation. Just briefed over. Think the tool is simple to use without help, except for above 🙂
Fund though that on https://www.solarwinds.com/documentation/dpa/flare/20204/content/dpa-manage-sql-statements.htm there is text missing.
Backups, the lab server that I monitored was not that representative and I was a bit to eager to test. Understand all the graphs meaning, maybe not always the practical usage. I use SAM as well for many of these things. Two thoughts, on several graphs it would be nice to see the data per database. What database is missing backups? What database is filling it's log. And also, it would be nice to be able to exclude some database from this report as the might be databases that don't need backup - thus clouding the graphs.
Feel free to ask more! We have been a solarwinds partner for over 15 years and also have a team of SQL DBA's among one MCM, MS Certified Master.
FYI: DPA 2020.4 RC2 is now out.
Regarding the simple/advanced switch for FindSQL being inside an information box, I totally agree that is unexpected. We're going to adjust that to a different mechanism. Hopefully, we can fit that into the final release candidate.
On your other comment about the resource graphs, those graphs are currently limited to metrics at the DB instance level. However, for the backup related alerts, we've made those output the list of databases not meeting the thresholds.
There are several metrics, that we'd like the ability to provide not only finer granularity at the db level but in some cases at the table level. What would you think about something like upon clicking the server/instance level graph causing a details table to display showing rows for individual databases or tables depending on the metric?
Have you had a chance to download the second release candidate DPA 2020.4 RC2 to see if the problem is now fixed?
By the way, any other feedback on the new resource metrics graphs and the new FindSQL SQL filter and text search capability? I'm hungry for any additional feedback on those features.
Installed RC2 today, fresh install. Everything seem to be working. Has tested several things. Created new resources and found graphs for them as well.
It looks so much better now than before 🙂
One feature I used a lot with old graphs was seeing graphs for 6 months/1 year. To fast and easy see long term trends.As I did a fresh install I didn't have that much data to test that but hope it will work fast an nice now also.
Showed the new look and features to my DBA colleges and they liked it as well. Good work!
DPA 2020.4 RC2 adds support for analyzing IBM Db2 11.5 databases
@cpriddy I'm assuming this just means it has been tested and nothing broke?
Yet, I see DPA is still using the db2jcc-3.64.114.jar file - that is a Db2 9.7 Fixpack 8 JDBC Type 3 driver.
"The IBM Data Server Driver for JDBC and SQLJ is upward compatible with the next version of a DB2 database if the applications under which the driver runs use no new features"
So - only 9.7 FP8 features can be used by DPA. No 10.1, 10.5, 11.1 or 11.5 features. And technically, not upwardly compatible with V11.x of Db2.
Also JDBC 3 drivers are no longer supported or provided in Db2 11.5 - only JDBC 4 drivers:
Important: db2jcc.jar and sqlj.zip are no longer supported. Starting with the version of the IBM Data Server Driver for JDBC and SQLJ that is delivered with Db2 Version 11.5, db2jcc.jar and sqlj.zip are not included.
It doesn't seem that there has actually been much effort made as far as looking at new features in Db2 11.5 or actually enhancing monitoring.
Are there any plans to genuinely enhance DPA Db2 monitoring?
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.