Perfect SQL Monitoring solution for IT, Support and Dev Teams
What do you like best?
Spotlight cloud's best feature for me is the Heatmap. I can view the status of hundreds of SQL and Windows Servers at a glance, with simple color coding that makes it easy to tell which servers need attention.
My IT Staff have the dashboard up all day and can quickly drill down to view details about why a server status has changed. Since implementing Spotlight, they've caught missed SQL Jobs, or jobs with errors, space related issues, and performance related issues. The IT Team can see when a CPU core is maxing out and can investigate further to find out if something abnormal is happening.
My Support staff can use the Health check to troubleshoot performance issues raised by clients, and the work load analyzer allows them and the dev teams to drill down to specific SQL Statements that may be experiencing issues.
As a cloud application, the headaches of managing our own monitoring servers in-house are gone.
What do you dislike?
I have trouble thinking of anything that I dislike. There are features that I would like to see added to future versions, such as the ability to assign an alias or name for a query in the Workload Analyzer, but otherwise, once my team and I started using the features of Spotlight, we couldn't imagine going back to our old monitoring solutions.
What problems are you solving with the product? What benefits have you realized?
IT awareness of what's going on across hundreds of servers on one pane of glass.
Performance troubleshooting / staying ahead of performance issues before customers have a chance to report them.