SQL Diagnostic Manager for Microsoft SQL Server helps database administrators to find and fix Microsoft SQL Server performance problems in physical, virtual, and cloud environments. Unlike its competition, it provides effective scalability, advanced SQL query analysis and optimization, prescriptive analysis with corrective SQL scripts, powerful automated alert responses, broad PowerShell integration, complete customization, and extensive support for current and legacy Microsoft SQL Server and…
$1,996
per instance with first year maintenance included
Spotlight
Score7 out of 10
N/A
Spotlight from Quest Software is a database performance monitoring option.
DBA / Sr. Data Analyst in Information Technology at Boostability (Marketing and Advertising, 201-500 employees)
Chose IDERA SQL Diagnostic Manager for SQL Server
All the toolsets we looked at have the same basic feature sets. We felt like IDERA SQL Diagnostic Manager for SQL Server had more features (SQL Doctor features) and better historical features. More toolsets now have a lot of these features, but for eight years, IDERA SQL …
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Quest Software
No answer on this topic
Key User Insights
Would buy again
No answers on this topic
No answers on this topic
Delivers good value for the price
No answers on this topic
No answers on this topic
Happy with the feature set
No answers on this topic
No answers on this topic
Lived up to sales and marketing promises
No answers on this topic
No answers on this topic
Implementation went as expected
No answers on this topic
No answers on this topic
Features
IDERA SQL Diagnostic Manager for SQL Server
Spotlight
SQL Performance Monitoring
Comparison of SQL Performance Monitoring features of IDERA SQL Diagnostic Manager for SQL Server and 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.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
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.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
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.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
the platform offers a clean, easy to use interface. You can customize reports and dashboard. Integration is also pretty good, you can integrate to Xero, QBO and MYOB and excel spreadsheets. It also offers very broad supporting documents and webinars. There are only two downside of Spotlight; learning curve (it could be a bit difficult at the beginning to learn the system) and price point (For small businesses, Spotlight Reporting can be seen as relatively expensive compared to other reporting tools)
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
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
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
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.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
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.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
