Solarwinds DPA - Tools to help your DBA
April 12, 2016
Solarwinds DPA - Tools to help your DBA
Score 10 out of 10
Vetted Review
Verified User
Overall Satisfaction with Solarwinds Database Performance Analyzer for SQL Server
We use Solarwinds Database Performance Analyzer to monitor 4 SQL Servers and over 300 databases. DPA allows us to see a holistic view of each server and then drill into problem databases or queries to see specifics. This has allowed us to identify problem queries before they can impact any other clients or the entire server. Daily reports and trend analysis helps us keep up our standards as the load increases.
- Trend Analysis for database server resources
- Deadlock detection and reporting
- Index recommendations
- Drilling down to individual queries inside of individual databases
- Alerting is cumbersome to set up
- Allowed us to scale our SQL Servers to best fit the current load
- Helps plan for growth and business impacts of adding additional clients
- Allows for real time review of resources so we can adjust to any issues that are occuring