Spotlight Cloud Reviews & Product Details

I like the best the feature to troubleshoot the exact area that can cause a data specific issue. Once the root cause is detected it is easier to fix the data to get the expected results on the front end. Review collected by and hosted on G2.com.

You should know the SQL very well however it is a prerequisite for most of the database management tools. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

- Server Overview Board

- Alert list

- Workload Analysis Review collected by and hosted on G2.com.

Don't dislike anything.

The only things that are causing us a bit of an issue are:

- the time of the Spotlight collection particularly the Fragmentation collection

- the Deadlock Graph does not appear to be available unlike the previous on-premise version

- the execution plan analysis does not seem to be as reliable as the previous on-premise version

- it keeps asking us to logon after a few minutes when moving from a screen to another

- reports are not as extensive as before Review collected by and hosted on G2.com.

Spotlight for SQL Server Cloud provides my team with an at-a-glance view of over 120 SQL Servers. Our team keeps the heatmap dashboard visible all day, allowing them to jump on any servers that go "red". Spotlight drill-downs provide actionable insights that allow my team to solve the underlying issues in a timely manner. The greatest benefit is that problems frequently get solved before our customers even notice. Review collected by and hosted on G2.com.

I wish I could acknowledge alarms with a single click instead of two clicks. Review collected by and hosted on G2.com.