Stop buying hardware to improve your SQL server performance. Try DPA first!
Overall Satisfaction with SolarWinds Database Performance Analyzer
Discovering data performance issues. Creating an index based on the suggestions by DPA. It can be accessed by all developers to review their query or performance-related issues.
Pros
- Suggest indexes.
- Indicate the wait time for all processes, so you rank the issues and fix them by priority.
- You can send URL/ links to other to show them the exact point of problem. Easy for collaboration.
Cons
- Bookmark of problem, so we can revisit the issue and compare it before and after the changes.
- More details on deadlocks/blocking, etc.
- Notification, kind of monitoring, if wait time exceeds some threshold.. or review the wait time of specific bookmarks or issues.
- Very positive, we'd never be able to find out all the bad queries without it. Saved $ on upgrading hardware/resources on our SQL server.
- We reduced wait time from > 24 hrs a day to a few hours a day.
- No need to put more memory and faster SAN/RAID.
Interface, presentation, wait time...
We are more concerned with improving query performance than hardware/resource usage.
We are more concerned with improving query performance than hardware/resource usage.
Comments
Please log in to join the conversation