DPA is hell lot of a Business for Database world
Updated March 25, 2022

DPA is hell lot of a Business for Database world

Nikhil Kumar Sharma | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with SolarWinds Database Performance Analyzer

We are using Solarwinds Database Performance Analyzer for few of our customers to help in monitoring their Database Environment which includes Microsoft SQL, Postgre SQL, Oracle etc. Solarwinds DPA is primarily used by Database Administrators, Application Engineers (Read Only) and Tools Administrators. There are few interaction with Key Management stakeholders for data analysis but its relatively less.
  • Multi Vendor Databases Monitoring
  • Agentless Monitoring
  • Less Dependency on DB Admins
  • Less Resources consumption on target databases
  • API based integrations
  • Cloud Database Monitoring such as Google native SQL service
  • Modern (no SQL ) database monitoring
  • Dashboard Flexibility
  • Reporting Flexibility
  • Multi Vendor Database Monitoring
  • API Integration with Ticketing Tools
  • Rich Raw data for reporting
  • Flexibility to run DPA on relatively less configuration server
Solarwinds Database Performance Analyzer is well suited in below Scenarios -
1. End to End Database Instance Monitoring.
2. Database in Clusters Monitoring such as Availability Group in MS SQL, CDB in Oracle etc
3. If you want detailed monitoring with historical analysis.
4. SQL Statement Deep Dive Analysis for WAIT Time reason, Blockers, Deadlocks etc

Solarwinds DPA is not well suited if you are looking for Detailed VM, OS monitoring where Database is installed.

Using SolarWinds Database Performance Analyzer

  • One single tool to management almost all sort of RDBMS Databases
  • Query Optimization and Tuning Advisors availability out of the box
  • Data flow and table interconnection visualization
  • Lead Locks details with query causing the dead lock
  • Wait time from different personas - VM, User, Query, Application etc.
  • VM Level resources monitoring with DB Performance metrics.
  • Observability in depth for queries running in the run time and taking more time to execute
  • Table tunning advisors provides recommendation about what can be improved
  • Wait time analysis from different perspective is another great innovative way to see how is your DB performing.
  • Database Management though DPA
  • Building/Creating Tables in DPA
  • Maintenance jobs via DPA