SolarWinds Database Performance Analyzer vs. SolarWinds SQL Sentry

I believe that SolarWinds Database Performance Analyzer is a great choice for an organization that does not have a specific DBA or one that is still growing into the role. SolarWinds Database Performance Analyzer is filled with hints, tips, and explanations of the various readings and metrics. This is very useful to help understand what is happening and why, what it means, and what some potential solutions are towards remediating any issues. This is extremely valuable for our development team, allowing them to be more proactive with the queries they write in viewing how they perform and where bottlenecks might be.

Incentivized

Of all the tools I've used, SolarWinds SQL Sentry's Top Query has been the single most helpful tool in helping me identify which queries are putting a load on our servers and at what times. This greatly simplifies my job in prioritizing tuning. Having Plan Explorer directly linked to the tool is icing on the cake.

Incentivized

• Ability to drill down to wait for the issue and have a clear path as to what may be causing the issue.
• Ability to quickly add a new target and the ease of installation and upgrades.
• Reporting features to group my most troublesome customers into a daily report in one email.
• Excellent customer support on any issues I can't immediately solve.

Incentivized

• Alerting is very flexible and configurable to our needs
• Linking alerting into third party alerting tools via PowerShell was easy
• Collecting and rolling up SQL statements make it much easier to troubleshoot performance problems
• Drilling into PLE and what’s happening when it drops out
• Ease of drilling into time-frame to figure out what was the issue at that time
• Being able to query the SentryOne database for management reports is awesome (Deadlocks and Blocking)

• Resiliency of the Monitoring checks after the server underwent maintenance reboot. My experience is the monitor (Action) needs to be started manually. If possible it can automatically detect service/server then start to monitor again when system is back up.
• Much lighter UI.
• Granularity up to minutes.

Incentivized

• It would be nice if the reports can be interactive like drill down, clickable content, etc.
• Navigation could improve and become more intuitive.
• Calendar of events could also improve - wish the date and time range could be specified instead of just by day or interval.

Incentivized

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

Incentivized

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

Incentivized

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.

Incentivized

I don't know how we survived before without this tool, the added value that you get from it to do deep dive performance analysis, reactive problem solving and proactive monitoring and alerting is limitless. We have only scratched the surface of what we can do with this tool at my company. The support and ROI that SentryOne provide is exceptional and one of my favourite vendors to deal with.

Incentivized

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.

Incentivized

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

Incentivized

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.

Incentivized

The main platform is very well supported. Requests for help with customizing alerts and monitors have been rapidly and thoroughly responded to. Our use of the chain feature seems to be out of the ordinary and our defect reports there while understood and taken seriously, tend to be lower priority than defects in the main platform. They will work diligently to give us a workaround but correction in the standard release is a little slower in the chain feature.

Incentivized

sql sentry expert came onsight to review the performance of installation and gave us a good insight to using the tool

Incentivized

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.

Incentivized

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).

Incentivized

I have used Spotlight (for Oracle on RAC) but it has been several years. The dashboard was crisp, clean, and intuitive, but the tool had a significant overhead. However, no competitor made a tool that met our needs at the time. I have also used Idera's SQL Diagnostic Manager in more than one company. That tool is helpful for a larger environment than we currently have. But I think it is better at alerting than DPA but worse at just about everything else. The good thing is you can flag an alert as acknowledged, so you stop getting emails. The bad thing is I don't think I could use it to troubleshoot issues like I do with DPA. I do not have enough experience to provide helpful feedback on the others selected.

Incentivized

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.

Incentivized

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.

Incentivized

• Paid for itself in days. We had a stored procedure that could not meet its SLA, DPA highlighted the issue and contributed to the resolution.
• We had a stored procedure that we were able to calculate as running in 9 milliseconds, unfortunately, we had transactions coming in 7 milliseconds, resulting in duplicate transactions, indicating that a mutex function was needed.

Incentivized

• 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

Incentivized