Overall Satisfaction with SolarWinds Database Performance Analyzer
The database team uses DPA to manage up to 50 licenses. Only 5 team members who are DBAs actively use the tool. All SQL performance problems from large PeopleSoft DBS to Cots applications (500+) are covered. Performance problems can come from all directions so this tool is extremely useful because it's a catch-all.
- Peoplesoft DBs: we often use it to recommend indexes or find queries that need tuning.
- Availability group monitors and alerts so we know when there are problems.
- Trends over time: like blocking, deadlocks or stuck queries DPA helps pinpoint the cause.
- Bug with fantom availability group.
- Government lacks ROI