SolarWinds AppOptics vs. SolarWinds Database Performance Analyzer

AppOptics is good for small to medium-sized organizations with less than 150 servers or less than 40 services to monitor. It performs well for this use case where people need to get an overview of application performance, and 95%ile data is okay. Somewhere every data point and every record is critical; it should be avoided.

Incentivized

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.

Incentivized

• Request tracing with code profiling.
• Automated alerting on latency and response codes for each API.
• Low resource overhead while collecting data from our application servers.
• Highly performant dashboard that enables us to make progress rapidly.
• Very resilient. We have not seen a downtime in their service in the entire year that we have used them.
• Identify database and cache requests that are taking longer than expected

Incentivized

• 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

Incentivized

• The only thing that I would add is the possibility to display every single query our servers receive to eventually analyze them and query through them. We could also generate nice visualizations from that. Right now I believe we can only see averages.

Incentivized

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

Incentivized

We have been using AppOptics for over 3.5 years and expect to continue to renew it for the foreseeable future

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

As far a usability is concerned for AppOptics, it is just as matter of few minutes away even if you start from scratch, as all you need to do is register on the site and you will get the URL and password. And after this all you have to do is follow the instruction, as per the configuration wizard (tool tip) within the console for various technology such as SQL, IIS, .NET

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

Solarwinds AppOptics is rated as 9 out of 10 and the reason is there are still few areas where AppOptics needs to improve such as Service Now Integration, GCP Cloud Support, Better Dashboard visualization for application transactions flow. Other than these feature everything is there in AppOptics and that's a reason given 9 points out of 10.

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

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

What we found positive in AppOptics from others is:

• Easy to install and manage.
• Various stack support.
• Point to point deep-dive metrics and correlation.
• Metrics like DB connection, query analysis, latency in API calls, and other connections, response codes for various APIs, etc are the key ones in our case, which AppOptics provides efficiently.
• Alerts can be sent on different channels.

Incentivized

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.

Incentivized

• Application monitoring troubleshooting became more accurate. Accurate results save more man-hours of manual troubleshooting.
• As Realtime monitoring and alerts provide more flexibility, downtime can be minimized and Accurate Root causes can be provided.
• Dashboards can be useful for making future strategy based on trends.
• Installation and integration is easy.

Incentivized

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

Incentivized