Compare IDERA SQL Diagnostic Manager for SQL Server vs. Quest Spotlight

Cancel
You must select at least 2 products to compare!
Most Helpful Review
Use Quest Spotlight? Share your opinion.
Find out what your peers are saying about Oracle, IDERA, Quest Software and others in Database Development and Management. Updated: September 2020.
438,725 professionals have used our research since 2012.
Quotes From Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros
"Memory and CPU utilization features are good.""We're able to diagnose issues prior to their actually becoming issues. Without the alerting, we wouldn't have a clue as to what was going to happen. With the alerting, it gives us a heads-up that a specific threshold has been met, and we need to take specific action.""The most valuable features are disk space projections for planning, and also the Snapshotting ability, to look back in time, to see what was going on the server at a particular time. It's basically the output of an sp_who2."

More IDERA SQL Diagnostic Manager for SQL Server Pros »

"I consider the solution very scalable."

More Quest Spotlight Pros »

Cons
"They can improve checking the status of the CPU, memory, and IO utilization from each task.""I'm going to do an upgrade which may resolve my issues, but one area for improvement is its ability to handle the amount of data that we collect with it. We're likely one of the largest installations, with over 300 servers being collected with this product, and sometimes there are gaps. That would really be my only concern, in terms of how the data is collected and stored, for consistency.""We don't find that it helps us with performance monitoring and diagnostics. We find that SentryOne does that better. Also, in terms of alerts, we had to customize them dramatically so that we didn't get alerted on every little thing.""I would absolutely love to create customized dashboards but, unfortunately, they don't provide me the information that I need to create the report. The report I need is the detail or the transaction detail that's happening on those Snapshots. I'd like to be able to go back through time and search for things. I don't have that functionality, which is very disappointing. That's pretty bad and frustrating because I could query it and find out so much information about what's hitting my environment and when, but instead, they want control over it and to not give me that information. So it's encrypted. I can't pull it out and that is really bothersome.""The initial setup gives too many user rights to the server, so you have to put a user that is part administrator's group - that's the preferred way - on each server, which is kind of a risk. You want to do least privilege and you're not doing that."

More IDERA SQL Diagnostic Manager for SQL Server Cons »

"There's no reporting with this tool, and there really should be. They should add that into future releases."

More Quest Spotlight Cons »

Pricing and Cost Advice
"We were upgraded to Premium Support without their actually asking us, when we were quoted. Then I asked for Standard Support and that they had to re-quote us that. But they don't do that by default. They upcharge you by default, which I didn't think was very nice, without even asking."

More IDERA SQL Diagnostic Manager for SQL Server Pricing and Cost Advice »

Information Not Available
report
Use our free recommendation engine to learn which Database Development and Management solutions are best for your needs.
438,725 professionals have used our research since 2012.
Questions from the Community
Ask a question

Earn 20 points

Top Answer: I consider the solution very scalable.
Top Answer: The pricing is too expensive. They should work on a better pricing strategy. The solution should improve its capacity to photograph situations and conserve it for the amount time I need, whether it's… more »
Top Answer: We primarily use the solution for monitoring databases.
Ranking
Views
4,470
Comparisons
2,789
Reviews
4
Average Words per Review
628
Avg. Rating
7.5
Views
2,709
Comparisons
2,091
Reviews
1
Average Words per Review
229
Avg. Rating
9.0
Popular Comparisons
Compared 7% of the time.
Also Known As
IDERA SQL DM, IDERA SQL Diagnostic Manager Dell Spotlight
Learn
IDERA
Quest Software
Overview

IDERA SQL Diagnostic Manager is a robust performance monitoring, alerting and diagnostics solution for Microsoft SQL Server on-premises and in the cloud. It proactively notifies of health, performance, and availability problems via a desktop, web, and mobile console. It minimizes costly server downtime with agentless, real-time monitoring and customizable alerting for quick diagnosis and remediation.

Unlike its competition, it provides effective scalability, advanced SQL query analysis and optimization, prescriptive analysis with corrective SQL scripts, powerful automated alert responses, broad Microsoft PowerShell integration, complete customization, and extensive support for current and legacy SQL Server and Windows.

Quest Spotlight ensures peak performance around the clock with unmatched monitoring, diagnosis and optimization of SQL Server environments. Spotlight provides access to the details you need for optimal fitness of your SQL Server databases. Get overviews of health and performance, automated alerts and actions, and mobile device support.
Offer
Learn more about IDERA SQL Diagnostic Manager for SQL Server
Learn more about Quest Spotlight
Sample Customers
Padnos, University of Notre Dame, D4, Infeon Technologies, Chevron, LC Waikiki, Sisters of Saint Francis Health Services, Seattle Cancer Care Alliance, CVE, Colorado State University, St. Charles, Chaucer PLC, 1-800-Flowers, Ancoris, Money Management, National Opinion Research Center, California Department of Health, Plexus; Aviva, Burlington Northern Santa Fe, CBS, Comcast, Google, Merck, Regions Financial, Schneider Electric, Tata Consultancy Services, Verizon Communications, Zurich Financial ServicesJenkon
Top Industries
VISITORS READING REVIEWS
Computer Software Company27%
Insurance Company14%
Comms Service Provider12%
Government6%
VISITORS READING REVIEWS
Computer Software Company44%
Insurance Company9%
K 12 Educational Company Or School6%
Legal Firm5%
Find out what your peers are saying about Oracle, IDERA, Quest Software and others in Database Development and Management. Updated: September 2020.
438,725 professionals have used our research since 2012.
IDERA SQL Diagnostic Manager for SQL Server is ranked 5th in Database Development and Management with 3 reviews while Quest Spotlight is ranked 7th in Database Development and Management with 1 review. IDERA SQL Diagnostic Manager for SQL Server is rated 7.4, while Quest Spotlight is rated 9.0. The top reviewer of IDERA SQL Diagnostic Manager for SQL Server writes "Proactively alerts us on a wide variety of issues, but it has not scaled out well with our large environment". On the other hand, the top reviewer of Quest Spotlight writes "A solution with good monitoring features, good stability and has the ability to scale". IDERA SQL Diagnostic Manager for SQL Server is most compared with Redgate SQL Toolbelt, SolarWinds Database Performance Analyzer, SQL Sentry, Quest Foglight for Databases and SCOM, whereas Quest Spotlight is most compared with Oracle Enterprise Manager, Quest Foglight for Databases, SolarWinds Database Performance Analyzer, Toad Data Modeler and SQL Sentry.

See our list of best Database Development and Management vendors.

We monitor all Database Development and Management reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.