Overall Satisfaction with SQL Sentry Performance Advisor
We use Performance Advisor daily to watch and troubleshoot active processes on our production and business critical servers. It is being used for servers that are used by all teams in our organization. The tool gives us immediate ability to target and resolve specific issues on our business critical servers.
- Shows a comprehensive view of running processes/workloads.
- Gives the ability to drill down to specific long running queries.
- Allows us to review and fix lock/block scenarios.
- The flexibility of the interface. We would like to be able to watch several servers within a single screen and display only components that really matter (CPU & Wait times).
- Can't lock scale on wait times - we'd like to lock the scale of the waits windows to 5 seconds, so we know to look at it if it's over. With the changing scale, it's hard to know if there is a problem.