SolarWinds Database Performance Analyzer vs. SolarWinds SQL Sentry

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
SolarWinds Database Performance Analyzer
Score 8.4 out of 10
N/A
SolarWinds Database Performance Analyzer (DPA) enables deep visibility into database performance and expert advice for performance optimization and tuning. What can you monitor with DPA? Oracle Oracle Exadata Oracle EBS Microsoft SQL Server Azure SQL Database Azure SQL Database Managed Instance MySQL DB2 SAP ASE Aurora MariaDB DPA monitors physical, virtual,…N/A
SolarWinds SQL Sentry
Score 8.9 out of 10
N/A
SolarWinds SQL Sentry is designed to help data professionals optimize SQL Server database performance in physical, virtual, and cloud environments. SQL Sentry delivers metrics to help users find and fix database performance problems and provides scalability, boasting demonstrated success monitoring 800+ SQL Server instances with one monitoring database. With SQL Sentry, the user can monitor: SQL Server Azure SQL Database SQL Server Analysis…
$0
Free
Pricing
SolarWinds Database Performance AnalyzerSolarWinds SQL Sentry
Editions & Modules
No answers on this topic
Plan Explorer (SQL Server Query Tuning)
$0
Free
SQL Sentry for Azure SQL Database
$161
Per year per database (annual subscription)
SQL Sentry
1,450
Per year per instance (annual subscription)
Offerings
Pricing Offerings
SolarWinds Database Performance AnalyzerSolarWinds SQL Sentry
Free Trial
YesYes
Free/Freemium Version
NoNo
Premium Consulting/Integration Services
NoYes
Entry-level Setup FeeOptionalNo setup fee
Additional Details
More Pricing Information
Community Pulse
SolarWinds Database Performance AnalyzerSolarWinds SQL Sentry
Considered Both Products
SolarWinds Database Performance Analyzer
Chose SolarWinds Database Performance Analyzer
SolarWinds was chosen by our system administrator before I joined the company. It was what he found when he searched for SQL Monitoring tools. After a demo of SQL Sentry/Sentry One, he wants to pursue that tool instead of SolarWinds Database Performance Analyzer (DPA). We find …
Chose SolarWinds Database Performance Analyzer
Overall DPA is the best tool that I have used because of its simple interface and ability to dig in within a few clicks to see the root of a performance issue, but Idera and SQL Sentry have some areas where they are better than DPA, such as blocking and deadlocks.
I also feel …
Chose SolarWinds Database Performance Analyzer
DPA is a market leader and goes beyond what most products in the space can offer. It's a battle between SQL Sentry and DPA for the lead and everybody has their favorite. I personally prefer DPA for ease of install, management and better tuning and query advice options.
Chose SolarWinds Database Performance Analyzer
Quest Spotlight had a 70-page installation manual - quite daunting. SolarWinds Database Performance Analyzer, on the other hand, is pretty straightforward to install and use. I'm looking forward to exploring SQL Sentry but haven't gotten far into it yet.
Chose SolarWinds Database Performance Analyzer
The main thing was their popularity for the products they are providing. Also, we had great customer support for other SolarWinds products also.
Chose SolarWinds Database Performance Analyzer
I like the web-based interface and wait stats analysis of DPA. Some of the other tools have more features, but DPA feels like a more polished tool, and the features it has work well. It's been a while since I've looked at the competitors' products. DPA works well for us, and …
Chose SolarWinds Database Performance Analyzer
DPA simply provides another angle over the performance of the server, plus it is very quiet and has little overhead. I also like how historical performance data is stored, and although it does not really let you decide how it is aggregated, it is good enough.
Chose SolarWinds Database Performance Analyzer
I have done my comparison against SQL Sentry and I feel like Solarwinds Database Performance Analyzer for SQL Server is more of a graphical tool, so it lets you see wait time for a database instance. That's really nice when you're dealing with similar instances. We haven't …
Chose SolarWinds Database Performance Analyzer
I haven't seen a better tool for analyzing and tuning queries based upon wait times. However, for operational monitoring, finding current blocking, and at times slow queries that aren't run frequently, it lacks true benefit. Best use is for long term production query tuning and …
Chose SolarWinds Database Performance Analyzer
DPA was the best bang for the buck since we already had Orion monitoring. So being able to integrate was a huge factor.
SolarWinds SQL Sentry
Chose SolarWinds SQL Sentry
SQL Sentry has a LOT more information in it than the SolarWinds DPA product. Its reporting tool isn't as good either.

The IDERA product isn't as reliable as SQL Sentry and its reporting isn't nearly as good. The IDERA UI is a resource hog and isn't as intuitive.
Chose SolarWinds SQL Sentry
We chose SolarWinds SQL Sentry because it met more of our requirements than any other single tool. Proactive monitoring, quick collection times (every few seconds vs minutes), flexible custom alerting as well as in-depth data for performance analysis (Top SQL is by far my …
Chose SolarWinds SQL Sentry
I have used tools from Idera, redgate, and also Solarwinds. SQL Sentry is one of the better tools out on the market in my opinion.
Chose SolarWinds SQL Sentry
I use Toad and SolarWinds. Spotlight used too much of a server's resources. Sequel Pro was not as well-rounded for SQL reviews.
Chose SolarWinds SQL Sentry
Every resource has a different way of allowing users to access performance data and events, I simply think that SQL Sentry does it the best by displaying a dashboard that allows seeing the data in angles that no other has.
Chose SolarWinds SQL Sentry

The sheer amount of information, ability to tune almost all areas of alerting and thresholds, and the low impact of monitoring as well as transparency into how their monitoring processes may impact performance gives them the advantage over these others. In some cases their …

Chose SolarWinds SQL Sentry
I felt they were all comparable to each other. SolarWinds DPA had the best interface but we chose SQL Sentry due to the difference in cost.
Chose SolarWinds SQL Sentry
I found SQL Sentry to be the best bang for the buck by a good margin. Redgate makes great software too, so that is a big compliment in my book.
Chose SolarWinds SQL Sentry
SQL Sentry has a dashboard and tools that better suit our needs as a business. The tab based layout we found was easier to use and for the layman to understand. The top SQL feature has been invaluable to us for locating problems in real time.
Chose SolarWinds SQL Sentry
As a whole Sentry offers the most complete SQL Server monitoring package.
Chose SolarWinds SQL Sentry
PA has the lightest monitoring footprint of any of the other third-party applications out there. The featureset of PA includes things such as virtualization monitoring, top SQL statements, and granular historical trending that other products miss or gloss over. The sheer amount …
Chose SolarWinds SQL Sentry
It was the easiest to use and setup. It was effortless to install and setup. We immediately saw the results without the need to go through a bunch of setup screens.
Chose SolarWinds SQL Sentry
For us, there were 3 big items that swung SQL Sentry.
1) customization of alerts and notification
2) polers in other domains allow for a more secure deployment. In addition, the polers allow for redundancy, ensuring we are spending time fighting fires, not fixing the fire …
Top Pros
Top Cons
Features
SolarWinds Database Performance AnalyzerSolarWinds SQL Sentry
SQL Performance Monitoring
Comparison of SQL Performance Monitoring features of Product A and Product B
SolarWinds Database Performance Analyzer
-
Ratings
SolarWinds SQL Sentry
8.4
102 Ratings
1% above category average
Performance dashboard00 Ratings9.2102 Ratings
Intelligent alerting00 Ratings7.996 Ratings
Top SQL00 Ratings8.6102 Ratings
Historical trend data00 Ratings8.6100 Ratings
Virtualization support00 Ratings8.764 Ratings
Best Alternatives
SolarWinds Database Performance AnalyzerSolarWinds SQL Sentry
Small Businesses

No answers on this topic

No answers on this topic

Medium-sized Companies
Redgate SQL Monitor
Redgate SQL Monitor
Score 8.2 out of 10
Redgate SQL Monitor
Redgate SQL Monitor
Score 8.2 out of 10
Enterprises
Redgate SQL Monitor
Redgate SQL Monitor
Score 8.2 out of 10
Redgate SQL Monitor
Redgate SQL Monitor
Score 8.2 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
SolarWinds Database Performance AnalyzerSolarWinds SQL Sentry
Likelihood to Recommend
9.3
(113 ratings)
8.6
(102 ratings)
Likelihood to Renew
8.6
(4 ratings)
8.8
(16 ratings)
Usability
9.0
(6 ratings)
9.0
(12 ratings)
Availability
9.1
(1 ratings)
7.1
(2 ratings)
Performance
9.1
(1 ratings)
7.1
(2 ratings)
Support Rating
9.3
(6 ratings)
7.5
(14 ratings)
In-Person Training
-
(0 ratings)
8.0
(1 ratings)
Implementation Rating
7.3
(2 ratings)
8.8
(8 ratings)
Configurability
7.3
(1 ratings)
7.9
(2 ratings)
Ease of integration
8.2
(1 ratings)
5.0
(1 ratings)
Product Scalability
8.2
(1 ratings)
7.0
(1 ratings)
Vendor post-sale
9.1
(1 ratings)
8.5
(2 ratings)
Vendor pre-sale
9.1
(1 ratings)
8.5
(2 ratings)
User Testimonials
SolarWinds Database Performance AnalyzerSolarWinds SQL Sentry
Likelihood to Recommend
SolarWinds
This is an easy 10 because I actually have recommended this product to multiple clients and colleagues! Any shop that writes its own SQL queries will benefit from the insight provided by SolarWinds Database Performance Analyzer, so they know which of their queries is causing a bottleneck. Small shops or databases with only a few tables likely will see far fewer opportunities for optimization.
Read full review
SolarWinds
This solution is perfect for a team with a large server count and, at least, moderate experience supporting a SQL Server environment. If the environment is smaller or the team has less experience working with SQL Server performance tuning methodologies, then the tool may be overwhelming for the users.
Read full review
Pros
SolarWinds
  • 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
Read full review
SolarWinds
  • The Top SQL functionality has been extremely useful for identifying poorly performing queries by resource consumption.
  • The flexibility of creating your own Advisory Conditions has allowed us to integrate our custom internal alerts into a centralized dashboard and alerting platform.
  • Being able to highlight any chart on the dashboard and then tool-matching that window across all the other charts makes it much easier to correlate the different performance metrics against each other.
Read full review
Cons
SolarWinds
  • 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.
Read full review
SolarWinds
  • Tuning advice: With all the graphs and data available, it's not always easy to determine the best thing to do. I'd like to see SentryOne provide some best practice analysis based on the historical information collected for the server being looked at.
  • They could add help tips or links to help documents, when you select a graph on the dashboard. Inexperienced users tend to put blinders on and focus on one thing when they see a high counter or something out of the ordinary. It would be very useful to include a link that provides underlying help. The link would provide an explanation of the counter in detail and offer possible explanations as to why the counter is off.
Read full review
Likelihood to Renew
SolarWinds
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
Read full review
SolarWinds
Absolutely. SQL Sentry is an absolute must have for any company with a SQL Server estate. It provides a force multiplier to effectively manage SQL Server, and the feature sets are second to none. The support and expertise at SentryOne is incredible. They are very supportive of both the platform users and helping your business with the product
Read full review
Usability
SolarWinds
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.
Read full review
SolarWinds
I accept that the flexibility of the alerting comes at a price. Other than the alerting SQL Sentry's interface is intuitive. Connecting to a new SQL instance, given that all the needed ports are open in your firewalls is straight forward. Reviewing the performance and queries for an instance is available in with a right click. As you dig in new tabs are created to present the detailed data. I find the ability to filter and rollup metrics on a query very helpful in dealing with the "it's running slow". You can easily compare the metrics of run times for the same query to let the user know, it's probably data your doing a billion reads instead of the usual 100 thousand.
Read full review
Reliability and Availability
SolarWinds
No answers on this topic
SolarWinds
The system is working perfectly in capturing data, but we do experience issues with SQL Timeout when viewing results in the remote clients. This may be due to the fact that our monitoring service is consuming most of the CPU, and it is the same server that is hosting the SQL Repository. We could probably fix the issue by separating the SQL instance from the monitoring service.
Read full review
Performance
SolarWinds
No answers on this topic
SolarWinds
In most cases the pages load very quickly. In our particular case, we need to do some movement of services to separate our monitoring service to separate infrastructure from the repository. When we first started with SQL Sentry on 5 licenses, we did not have any issues. Since we have now grown that to 25, we are experiencing some challenges. We do not believe this to be a tool problem
Read full review
Support Rating
SolarWinds
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.
Read full review
SolarWinds
From their infancy as a smaller company to now as a global player they have always kept focus on prioritising he customer. They know their product and the technology it supports and are easily accessible for both resolving problems with the product all the way to adding value through additional training and assisting with getting return on investment through utilisation of the many features the product provides.
Read full review
In-Person Training
SolarWinds
No answers on this topic
SolarWinds
sql sentry expert came onsight to review the performance of installation and gave us a good insight to using the tool
Read full review
Implementation Rating
SolarWinds
Follow the guidelines for the capacity of the servers. We found that the DPA databases were getting rather large and also that there are ways to reduce their size built into some of the options.
Read full review
SolarWinds
Was suggested that we install the process monitors on a dev or qa database server, but we found it more useful to create an IT db server and put it there (along with a few other apps that we use for monitoring).
Read full review
Alternatives Considered
SolarWinds
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.
Read full review
SolarWinds
SQL Sentry offers more features and is customize-able to fit our business needs. It has more centralized management and support. The company's technical support is also top notch. It is also worth mentioning that SentryOne Team Blog is an excellent source. One can find lots of valuable troubleshooting skills on the blog site - very educational and informational.
Read full review
Scalability
SolarWinds
No answers on this topic
SolarWinds
We are running 25 instances through a single monitoring service and it is able to keep up. We are finding that this many instances in our environment is about as many as can be handled. We will need to deploy additional monitoring services. Luckily, there is no additional licensing costs to deploy additional monitoring services. For us, it's just an additional Azure VM.
Read full review
Return on Investment
SolarWinds
  • It has allowed us to progress as an organization with much less reliance on a direct DBA than would traditionally be required
  • Allowed us to be much more proactive in our performance monitoring and responding to issues that would affect users.
Read full review
SolarWinds
  • Better customer service as it alerts me automatically to loss of service issues so I can react and either get things fixed before it impacts the customers or to let my management know as soon as possible
  • It helps me find expensive SQL so our customers get better performance and we make better use of our resources
Read full review
ScreenShots

SolarWinds Database Performance Analyzer Screenshots

Screenshot of DashboardScreenshot of Alerts and reportsScreenshot of Application-centric view of DPAScreenshot of Blocking deadlock analysisScreenshot of Collaboration across teamsScreenshot of Intuitive performance monitoring

SolarWinds SQL Sentry Screenshots

Screenshot of SQL Sentry DeadlocksScreenshot of SQL Sentry Top SQL