Spotlight is a great tool for insight into SQL Server
Spotlight provides a variety of insights into our SQL server. Used primarily in the IT department, it notifies us of stress on the server …
Spotlight
Spotlight
Spotlight
Overview
What is Spotlight?
Spotlight from Quest Software is a database performance monitoring option.
Read moreRecent Reviews
Product Details
- About
- Tech Details
- FAQs
What is Spotlight?
Spotlight from Quest Software is a database performance monitoring option.
Spotlight Technical Details
| Operating Systems | Unspecified |
|---|---|
| Mobile Application | No |
Comparisons
View all alternativesCompare with
Reviews and Ratings
(12)
Attribute Ratings
Reviews
(1-3 of 3)- Popular Filters
Companies can't remove reviews or game the system. Here's why
February 21, 2020
Spotlight is a great tool for insight into SQL Server
Spotlight provides a variety of insights into our SQL server. Used primarily in the IT department, it notifies us of stress on the server and allows users to help target specific processes contributing to that stress. It also allows us to rewind to the time a problem occurs and see a snapshot of what was happening, which is useful when trying to identify the cause of off-hours issues.
- Great SQL server monitoring
- Rewind and playback of previous times
- Some things like the "server health" ratings are tied to preset properties and are less useful if those are not important in your environment.
- It can be challenging to adjust thresholds to try to make alerting and status more accurate.
76%
7.6
- Spotlight is reasonably inexpensive, and any one of the multiple things we use it for more than justifies the cost.
October 16, 2019
Spotlight Review
All the DBAs in our team use Spotlight, which currently is at 6 people. We bring up in the morning and continue to monitor all day. This gives us a great view of active production databases. We are able to view top sessions, top SQL and see CPU consumption. It is actually one of the best tools we have used for monitoring Oracle databases.
- The screen is color-coded, so when Red or Orange is displayed you are able to drill down into that setting and figure out what is going on.
- This tool also integrates with the OEM agents which will also have implemented.
- Spotlight also works great without RAC databases, able to view at the cluster level or drill down to instances and VM's.
- Have not found any issues at this point.
50%
5.0
- We have not encountered any issues and continue to keep Spotlight's version current.
- Very simple to set up and add databases. The only thing that has to happen to the database is that a user ID needs to exist.
Spotlight is easier to view than OEM. OEM is better for historical information.
May 26, 2016
Dell Spotlight
The DBA team uses it for real-time monitoring of a couple dozen of the production instances as well as spot monitoring of development instances when troubleshooting issues. We also make it available in a read-only mode to our clients so they can monitor their production instances as well. It's not the company supported/supplied software, but since that doesn't work well enough, we've supplemented it with Spotlight for our most important instances.
- I love the main page that provides a color code list of all the servers so I know very quickly where to focus my attention first.
- I love how easy it is to configure new notifications.
- I love how easy it is to configure a new server to monitor.
- My only complaint was the cost.
68%
6.8
- It had a positive impact in two main areas. First, it was easy for the DBA team to configure it to watch and alert on the most important instances. And second, it was very easy to provide clients read-only access to the dashboard so they could watch their servers as well, i.e. they weren't always pestering us for current status.
I think Dell is better with its dashboard and ease of use, but SQL Sentry is better at customization. We used Spotlight at my previous company, and SQLSentry at my current company.