IDERA SQL Diagnostic Manager for SQL Server vs. Spotlight

If you have several SQL servers and don't have a lot of time or resources to constantly monitor them, SQLdm will be very helpful. For one or two servers, it might be overkill. All of our servers are virtual, so having a tool that can monitor host metrics as well as guest metrics is a plus as well.

Incentivized

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.

Incentivized

• Database query optimization.
• Monitoring of databases in real time.
• Performance analysis and trends in the database.

Incentivized

• Great SQL server monitoring
• Rewind and playback of previous times

Incentivized

• Windows client has some issues. When you have small time intervals for your data collection, it can cause the client to become unresponsive and require you to restart it.
• It takes more time to get the web client running than it does to get the windows client running.
• The visualizations have been the same for the last eight years--could use a little bit of a refresh.

Incentivized

• My only complaint was the cost.

Incentivized

I've never had to contact support, as of yet I have had no issues or problems with the tool. This is after 5 years of use.

Incentivized

IDERA SQL Diagnostic Manager for SQL Server is an excellent tool, however I think Solarwinds Database Perfromance Analyzer is a slightly stronger more well rounded product

Incentivized

Spotlight is more usable, better at meeting requirements. Integration with Xero is one of the strengths (as others integrate too but Spotlight seems better connection). We also like the way group consolidation work in Spotlight.

Incentivized

• It saves me a significant amount of time each week, freeing me up for other important tasks. I couldn't possibly monitor each server individually to the extent that SQLdm does.
• With the wealth of information I can get to easily, I can be more proactive in taking care of my environments rather than reactive. The times when other people notice something happening before I do are few and far between.

Incentivized

• Spotlight is reasonably inexpensive, and any one of the multiple things we use it for more than justifies the cost.

Incentivized