Overall Satisfaction with SQL Sentry Performance Advisor
SQL Sentry was purchased to monitor our new Business Intelligence Infrastructure. The tool allows us to see at a glance if we have any performance issues; we also utilise the alerting feature heavily to make sure that even when we are not in the office or connected we can still see how the server is performing.
- Alerting features are a must, it takes a little while to tune them to your system but once you have them, they will save you and your team countless hours of recovery / server maintenance as you can stop the issue before it even becomes one.
- Performance Manager is great to understand not only how your server is performing now but also any time in the past. We utilise this to drill into any unusual activity with ease due to the UI being so intuitive and self explanatory. Again a massive time saver
- The cloud based reporting is very useful for a quick health check when you are not near your laptop.
- The event manager can really cluttered when using it on a business intelligence server with jobs running throughout the day. It would be great to see this in a different visualisation that could really help you spot the key hot spots, possibly create an impact metric that displays the jobs size depending on how much resource the job took to complete.
I selected this tool over SQL Monitor as it provided the all round package, it seemed to dig deeper into the server that SQL Monitor and the interface is so much nicer to use,
SQL Sentry hits the spot when using it for a business intelligence server.