<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Top Rated
209 Ratings
8 Ratings

SolarWinds Database Performance Analyzer

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Top Rated
209 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.7 out of 100
8 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.9 out of 100

Likelihood to Recommend

SolarWinds Database Performance Analyzer

Solarwinds Database Performance Analyzer is well suited in below Scenarios - 1. End to End Database Instance Monitoring.2. Database in Clusters Monitoring such as Availability Group in MS SQL, CDB in Oracle etc3. If you want detailed monitoring with historical analysis.4. SQL Statement Deep Dive Analysis for WAIT Time reason, Blockers, Deadlocks etcSolarwinds DPA is not well suited if you are looking for Detailed VM, OS monitoring where Database is installed.
Nikhil Kumar Sharma | TrustRadius Reviewer

Spotlight

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!!!").
Anonymous | TrustRadius Reviewer

Feature Rating Comparison

SQL Performance Monitoring

SolarWinds Database Performance Analyzer
Spotlight
7.8
Performance dashboard
SolarWinds Database Performance Analyzer
Spotlight
8.6
Intelligent alerting
SolarWinds Database Performance Analyzer
Spotlight
8.0
Top SQL
SolarWinds Database Performance Analyzer
Spotlight
7.3
Historical trend data
SolarWinds Database Performance Analyzer
Spotlight
8.0
Virtualization support
SolarWinds Database Performance Analyzer
Spotlight
7.0

Pros

SolarWinds Database Performance Analyzer

  • Maintains historical SQL execution data, enabling forensic analysis
  • Has the ability to slice and dice the data so that you can drill down to the execution of a single SQL statement being executed by a stored procedure
  • Alerts to when the consumption pattern changes
  • Shows historical average run times against the current, illustrating problems when they arise
  • Provides tuning advice based on best practices
Anonymous | TrustRadius Reviewer

Spotlight

  • 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.
Anonymous | TrustRadius Reviewer

Cons

SolarWinds Database Performance Analyzer

  • Alerts seem to be lacking in DPA compared to competitor's tools. They can be setup but are not quite as easy or as helpful as some other tools I have used.
  • Grooming/pruning the repository database isn't very easy. We don't manage a lot of instances but our repo DB has grown pretty significantly.
  • At times when I am drilled-down to a chart, it can be difficult to navigate around from that point to another time range/query/metric.
Anonymous | TrustRadius Reviewer

Spotlight

  • Have not found any issues at this point.
Kathy Nahle | TrustRadius Reviewer

Likelihood to Renew

SolarWinds Database Performance Analyzer

SolarWinds Database Performance Analyzer 8.7
Based on 4 answers
We have relied on this product for a very long time and it continues to exceed expectations. The product is a vital part of our organization at this point, it would not be very ideal for us to abandon it. We use it almost every day and depend on its alerts for critical parts of our business
Anonymous | TrustRadius Reviewer

Spotlight

No score
No answers yet
No answers on this topic

Usability

SolarWinds Database Performance Analyzer

SolarWinds Database Performance Analyzer 9.2
Based on 6 answers
I don't want to think about managing clusters of SQL servers in the future without this tool. We have demoed other tools and SolarWinds Database Performance Analyzer is the gold standard for usability and insight into what your servers are doing. The UI is a bit dated, but everything is laid out in a logical manner and drilling down into queries or timeslices is extremely intuitive.
Joseph Dixon | TrustRadius Reviewer

Spotlight

No score
No answers yet
No answers on this topic

Support Rating

SolarWinds Database Performance Analyzer

SolarWinds Database Performance Analyzer 9.5
Based on 6 answers
I have had to use their support on a few occasions, for reasons that I am not clear about until recently I have always had problems upgrading the software (although the last 2 updates have gone without issue which I am very pleased to say).On those unfortunate occasions, the support has been brilliant with either excellently documented guides on how to resolve the issue by myself or have been hands-on with calls and screen sharing to remotely fix the issue. Every time the problem was sorted and more importantly, nothing was lost (apart from a bit of time). And as I stated above whatever the problem was that was causing my upgrade issues appears to have been resolved in the last 2 updates.
Anonymous | TrustRadius Reviewer

Spotlight

Spotlight 8.6
Based on 4 answers
Though our support needs have been minimal, we have gotten good responses when we have needed it.
Anonymous | TrustRadius Reviewer

Implementation Rating

SolarWinds Database Performance Analyzer

SolarWinds Database Performance Analyzer 9.1
Based on 1 answer
Very satisfied
Anonymous | TrustRadius Reviewer

Spotlight

No score
No answers yet
No answers on this topic

Alternatives Considered

SolarWinds Database Performance Analyzer

At the time, we found SolarWinds Database Performance Analyzer to be easier to setup and to have a richer feature set than Redgate SQL Monitor, plus, from what I remember, the DPA pricing worked better for us over the course of a year. We're very happy with all the features DPA has to offer.
Anonymous | TrustRadius Reviewer

Spotlight

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.
Anonymous | TrustRadius Reviewer

Return on Investment

SolarWinds Database Performance Analyzer

  • I cannot provide quantitative data, but can give you some real positive impact example .
  • We had several points in the Internet banking applications which do not work as well as desired. Using DPA we identified the heaviest SQL queries and initiate a change request to the vendor. After implementing the received changes we are able to reduce response time by an order of magnitude.
Anonymous | TrustRadius Reviewer

Spotlight

  • 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.
Kathy Nahle | TrustRadius Reviewer

Screenshots

Spotlight

Pricing Details

SolarWinds Database Performance Analyzer

General

Free Trial
Yes
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
Optional

Spotlight

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Rating Summary

Likelihood to Recommend

SolarWinds Database Performance Analyzer
9.2
Spotlight
8.9

Likelihood to Renew

SolarWinds Database Performance Analyzer
8.7
Spotlight

Usability

SolarWinds Database Performance Analyzer
9.2
Spotlight

Reliability and Availability

SolarWinds Database Performance Analyzer
9.1
Spotlight

Performance

SolarWinds Database Performance Analyzer
9.1
Spotlight

Support Rating

SolarWinds Database Performance Analyzer
9.5
Spotlight
8.6

Implementation Rating

SolarWinds Database Performance Analyzer
9.1
Spotlight

Scalability

SolarWinds Database Performance Analyzer
8.2
Spotlight

Add comparison