Clear Analytics vs. IDERA SQL Diagnostic Manager vs. SolarWinds Database Performance Analyzer

Clear Analytics has almost all the features which are mostly required by the organizations for their data analytics and transformation activities. Clear Analytics is built on the support of a parallel query engine which makes it handle large volume requests and also provides optimized results. However, every solution has some limitations, Clear Analytics lacks advanced features such as Predictive Analytics which is a very demanding feature in the market as most organizations are adopting AI/ML automation for their businesses. Also, it needs to add a lot of advanced visualizations so that the user has the choice of selection. Overall a good solution to be recommended.

Incentivized

SQL Server [Business Intelligence] Manager is useful for tracking performance across SSIS, SSRS and SSA and have the data represented in dashboards. It helps improve performance and helps end users. However, several features are redundant for smaller organization that can use the tools that comes with existing Microsoft products. These features also takes time to learn and use.

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

• Quick management of the data through Excel thanks to the tools Clear Analytics provides such as filtering different information for an easier view.
• Ability to add new KPIs to measure different areas of our business.
• Drag and drop tool which makes an easier usage of Excel.
• Cost-effective. I find Clear Analytics to be affordable considering the number of features added and the unlimited sharing and editing it provides.

Incentivized

• SQLdm does a good job of providing information at a high level, but also allows me to drill down to specific queries and events if needed. I don't always need to sift through tons of details to get the information I need. It also gives a very wide range of information from SQL specific metrics, to OS metrics, to VM metrics, all the way up to host server metrics.
• I like how the alert and notification system can be customized. For example, if you know a certain server regularly has long-running queries, you can adjust the alert to not fire unless a query has been running for 30 minutes while the rest of the servers fire after 30 seconds. That is very helpful in not being bombarded at dinner with alerts from a server similar to, "I've been at 90% cpu for 26 milliseconds!!!!!!!...and now it's back down to 30%" Good information to know, but not something you need to literally lose sleep over.
• I like how you can configure different servers to be monitored differently. For example, you can have a group of servers called DEVELOPMENT that you can turn on heavier monitoring on so you can test how changes in applications might affect the SQL environment, but in the PRODUCTION group, you may only want to enable the heavier analysis and logging when performance issues are actively being reported.

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

• For Charts and Graphs , getting the Power Point Deck would be helpful. As of now we use the data from Excel Reports

Incentivized

• Windows client has some issues. When you have small time intervals for your data collection, it can cause the client to become unresponsive and require you to restart it.
• It takes more time to get the web client running than it does to get the windows client running.
• The visualizations have been the same for the last eight years--could use a little bit of a refresh.

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

I have really enjoyed working with Clear Analytics. This platform has contributed to increased production and reliable data control processes. It has flexible user interface that can be operated by any organization member. Reports are shared on simple and transparent way in the dashboard for easy access. Data analytics from all departments have created manageable working environment that have increased production.

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 have had multiple scenarios where I had to reach out to the support team of Clear Analytics, be it access-related, general queries, during initial implementation, etc. My overall experience has always been good. I got the needed support every time without any delay. I can definitely recommend Clear Analytics simply on the basis of its excellent support team.

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

There are other great tools that are out there but Clear Analytics is reasonable for our business and provides a lot of features that we specifically needed

Incentivized

IDERA SQL Diagnostic Manager for SQL, Redgate SQL, and MonitorLogicMonitor are similar products to each other. We decided on IDERA SQL Diagnostic Manager for SQL because our experience with locating heavy queries has been very good and it provides real-time monitoring of all servers and databases. It also allows you to have a large volume of historical data which allows you to analyze trends in the databases.

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

• Super useful to get started immediately
• Didn't have to rely on migrating data
• Easy to add members
• Easy to learn and build charts

Incentivized

• Allows us to quickly set up ETL processes as soon as we installed SQL Server.
• There's a lot of free/paid resources available online, decreasing development time.
• A tool with plenty of experienced developers.

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