Spotlight Reviews & Insights

Score7.1 out of 10

15 Reviews and Ratings

Community insights

TrustRadius Insights for Spotlight are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.

Business Problems Solved

Spotlight on Oracle has proven to be a valuable tool for users in monitoring and managing their Oracle Databases. By eliminating the need for running DBA Scripts or using Oracle's Enterprise Manager, this software simplifies server-related tasks and helps users be more proactive in supporting systems and applications. The interface of Spotlight on Oracle is highly regarded as the best monitoring tool on the market, providing insights into top sessions, top SQL, and CPU consumption, making it one of the best tools for monitoring Oracle databases.

DBAs have experienced reduced time spent on manual checks and verification of databases by using Spotlight on Oracle for critical SQL Server monitoring and management in production environments. Its time management capabilities have been beneficial for DBA teams in real-time monitoring of production and development instances. Additionally, the ability to rewind and see a snapshot of what was happening at the time of a problem occurrence has proved useful for identifying the cause of off-hours issues. While there is some concern that the Quest Foglight may replace Spotlight, users hope that this is not the case as they find Spotlight on Oracle to be a complex but convenient component for performance tuning SQL servers.

Reviews

4 Reviews

Great Value for Forecasting and Reporting Software

Rating: 8 out of 10

Incentivized

May 13, 2024

Use Cases and Deployment Scope

We use Spotlight for two main reasons; first, it is syncs with Xero accounting system so most of our clients are on Xero. Second, it has a easy to use interface and lots of different report packages. We meet with out clients on monthly, quarterly basis and use Spotlight for financial reporting, forecasting and budgeting.

Pros

Provides an extensive chart gallery with templating, customization
Consolidates multiple client organizations (We are using Xero)
Full 3-way forecasting with flexible rules
Financial and non-financial KPI reporting

Cons

Cash Flow analysis could be better, there are many different scenarios to calculate the cash flow but flexibility is not great.
Incorporating machine learning algorithms for predictive analytics could enhance forecasting accuracy

Likelihood to Recommend

Spotlight’s ability to consolidate data from various entities and provide insightful reports is highly beneficial. It streamlines financial reporting, allowing professionals to focus on advisory services and strategic decision-making.Small businesses, nonprofits, and organizations that need regular board packs or executive summaries find Spotlight useful. Less Appropriate: Certain industries (e.g., specialized manufacturing, healthcare, or research) have unique reporting needs. Spotlight’s generic templates may not cover all industry-specific metrics or compliance requirements.

Verified User

Professional in Finance and Accounting (11-50 employees)

Vetted Review

5 years of experience

Spotlight is a great tool for insight into SQL Server

Rating: 8 out of 10

Incentivized

February 21, 2020

Use Cases and Deployment Scope

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.

Pros

Great SQL server monitoring
Rewind and playback of previous times

Cons

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.

Likelihood to Recommend

Spotlight is great when you need a tool to give a quick look at a SQL server as a whole. It gives you the ability to see a lot of things, which can be vital in diagnosing problems or identifying stressors. Less great is the open-end of some of the diagnoses it makes, and things it identifies as "problems" (unless you love users coming to you and saying something like "Spotlight says there's a problem with our page latch!!!").

Verified User

Manager in Information Technology (201-500 employees)

Vetted Review

10 years of experience

Spotlight Review

Rating: 10 out of 10

Incentivized

October 16, 2019

Use Cases and Deployment Scope

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.

Pros

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.

Cons

Have not found any issues at this point.

Likelihood to Recommend

Spotlight is well suited for any Oracle database and supports multiple versions. Nothing special is needed to support multiple versions.

Kathy Nahle

Senior Enterprise Oracle DBA in Corporate at AdventHealth (10,001+ employees)

Vetted Review

5 years of experience

Dell Spotlight

Rating: 8 out of 10

Incentivized

May 26, 2016

Use Cases and Deployment Scope

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.

Pros

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.

Cons

My only complaint was the cost.

Likelihood to Recommend

I like it anywhere a you need to see current state at a glance.

Verified User

Professional in Information Technology (10,001+ employees)

Vetted Review

4 years of experience

Loading Reviews List....