DPA: FTW.
Updated March 22, 2022
DPA: FTW.
Score 8 out of 10
Vetted Review
Verified User
Overall Satisfaction with SolarWinds Database Performance Analyzer
We use DPA to manage a very large and somewhat cranky SQL environment for ambulatory healthcare end users (from providers and office managers to assistants and front desk personnel). The DB schema dates to the 1990s and requires regular supervision and management at a level the system vendor doesn't provide. Addressed problems include plan management, index addition and revision, partitioning and troubleshooting poor performance.
- Near-instantaneous feedback on problem queries
- Allows us to evaluate changes in the application or its stored procedures over time
- We can drill down to the end-user level to identify potential issues, important with > 2000 sessions daily
- Can't think of any feature or ops related issues. Prior complaints have all been addressed in newer updates.
- Only main complaint is cost -- we would adopt for other servers if the incremental cost wasn't so high for a few additional instances (we have 3 servers we would like to use DPA with, but can't justify the x3 pricing per instance).
- DPA allows our DBA to be more agile and find solutions to SQL problems faster. This results in better service to our end users, and better performance on the EHR system to our providers, allowing them to complete chart service for a patient much faster.
DPA has the best combination of capability, usability and availability in the SQL analysis market.
Using SolarWinds Database Performance Analyzer
- SQL performance monitoring
- Troubleshooting
- Statistical confirmation