Before we chose Spotlight Cloud, we had researched other options--including Quest's on premise software, Foglight. We quickly realized we needed a solution that could be accessed anywhere--not an on premise option, and Spotlight Cloud offered this in its SaaS design. We've been using Spotlight Cloud for more than two years now and it's become a critical part of our daily survival/business continuity. The time it saves and the ability it offers to be proactive vs. reactive is something I cannot imagine being without.

The biggest benefit that Spotlight Cloud has given me is time. As a small business I wear many hats and my time is already spread thin. By not having to endlessly watch my SQL Servers for issues, my time has been freed for more important tasks. This is, in a word: priceless.

There are a few issues with Spotlight Cloud I have experienced, mostly UI and navigation driven. For instance, any time I try to "Acknowledge" an alarm, a comment box opens with another acknowledge button that must be clicked, but this button is obstructed by the UI's "Help" bubble and results in me having to tab through the screen to close the dialog. Though I've mentioned this minor detail several times, it still exists. There are also helpful features that I don't use often so when I do I cannot easily remember/find where they are located. The ability to save a list of favorite features would go a long way toward helping this. And finally, the SQL Tuning Pack (an additional expense), has not been very useful, often slow, stalls the startup of SSMS, and is hard to understand what exactly it has "optimized."

Pretty good

I use the health check for each of my servers daily to find potential missing indexes and other recommendations. I use the workload analyzer when I notice server performance issues and need to troubleshoot more effectively. One of the best functionalities are the recommendations given when diagnosing an alarm. I've found those to be greatly useful and not really done by other monitoring solutions.

Sometimes when using the workload analyzer and trying to find which query is being troublesome... it just tells me the SQL Batch is out of context besides the query. This is not very useful to me but there might not be a way around it on your side..

If you are going to buy this product your better off buying the on prim version as opposed to the Saas. The on prim version is much more stable and easier to use.

The ability to find and tune problematic queries.

The refresh rate is a minute so at best you only know what happened in the last minute. The play back feature is hard to used and restets itself. Alarms are hard to snooze and acknowledge, sometimes after the refresh the alarm comes back.

O really love this product. I would suggest improving the support experience. I have not had a good result all the times.

Cloud synchronization is great. Deployment is straightforward and you have all your instances monitored in a matter of minutes. Push notifications are awesome.

Monitoring Always On availability groups is practically useless. No features at all. This should be reviewed and implemented.

I've really enjoyed utilizing spotlight cloud over the last year at multiple sites. The ability to execute various alarm actions and really setup workflows has made life quite a bit easier for a DBA that manages a multitude of servers. Support has been fantastic and they seem to be open to feature recommendations.

Cloud Based Customizable Alert Actions Support is great

No Azure/AWS Capabilities Security could use a bit more attention