DPA, the database admin's friend.
February 02, 2019

DPA, the database admin's friend.

Anonymous | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with SolarWinds Database Performance Analyzer

It is used by our IT department to watch for database issues on oOraclecle and MSSQL environments. We use the info to determine if changes need to be made in the application code for our developers or support calls to the third party products we use. When issues arise we are able to give them info to find and fix any bugs.
  • We can see any SQLs that are using more resources then they normally do and see if software updates have any issues.
  • It gives us historic information about the server. It shows CPU, memory and individual SQL utilization.
  • It shows us the SQL that is running so we can use that to show developers or support personal what may be causing an issue.
  • It would be nice to be able to pick the window for data related to the CPU utilization, etc. IE, pick the week of Jan 6th through the 12th instead of this week, one month, etc.
  • Most everything else works very well.
  • We have had developers make changes to their code that caused the software to be slower. We gave them the SQL that was causing the issue and they removed old records and sped up the system a good 20%.
  • It also helps us with server sizing to make sure we do not buy more hardware then we need. We had one company tell us we needed a faster server to speed up the software and we were able to show them that adding more server power would not fix the issue.
I think if you have any database servers that are used for more then one database it would be a must. The ability to make sure that one database is not hogging the entire server and causing slowness for others is a very good thing to have. If you only have only one database it would be useful, but it might not be needed.