Reviews (1-25 of 75)
- Maintainability and accommodating Support service and easy to follow Release Notes/Documentation.
- The relevance of the pre-defined Reports and Checks.
- Simplicity of the tool. Easy to use and understand.
- 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.
- Near-instantaneous feedback on problem queries
- Allows us to evaluate changes in the application or its stored procedures over time
- We can drill down to the end-user level to identify potential issues, important with > 2000 sessions daily
- Can't think of any feature or ops related issues. Prior complaints have all been addressed in newer updates.
- Only main complaint is cost -- we would adopt for other servers if the incremental cost wasn't so high for a few additional instances (we have 3 servers we would like to use DPA with, but can't justify the x3 pricing per instance).
SolarWinds Database Performance Analyzer Review: "Why DPA can save your firm money, help developers, and ease DBA job."
- Top N SQL queries.
- Outstanding UI for rapid examination and drill down to detail data.
- Intuitive UI design - better than any other product in its category.
- Enabled us to immediately shift DB related performance matters first to developers so that our DBA's can focus on more important matters.
- Allow alerts to SMS (text message).
- Tells you which statements in which stored procedures need work or are catastrophic (if that applies).
- Helps you focus attention on what really needs work, very efficiently.
- I can't think of any examples for this question.
- Displaying baselines helps to show management how a change has affected performance positively or negatively.
- The tuning feature is helpful in showing areas that could be improved with an index or code updates.
- Wait statistics information is very helpful to diagnose database bottlenecks.
- Naming the hash takes more steps then it did in the past.
- It would be nice if there was a way to group the wait statistics by procedure.
- I search feature would be helpful.
SolarWinds Database Performance Analyzer Review: "Do you want to know the truth of why something happened (and be able to prove it)?"
- Problem categorization.
- Problem identification.
- Serious trending analysis.
- When presenting possible sources of issues, it may be better to first give a list overview, and then proceed to drill down into the details.
- Predict performance across all databases
- Predict unexpected behavior
- Make a correct forecast about how much memory and CPU could be needed for a particular job
- The agent usually consumes a lot of memory
- High cost, since it is charged per instance.
- An efficient and intelligent search feature would be helpful.
SolarWinds Database Performance Analyzer Review: "SolarWind's products make IT infrastructures work better"
- Multiple database real-time performance/status in single windows with an easy illustration using graphs.
- Query analyzer and identify plan text.
- Overall database status monitoring and reporting.
- Plan hash and plan adviser.
- DB color and grouping for interdependent query's relation.
- Point the users and identify single users for multiple DB Access Scenarios.
Well suited for database real-time status and performance monitoring and reporting, an easy illustration of a query in graphs for user understanding, interdependency and query identification and a single glass view for multiple different databases.
Not as good for failed jobs status for a database, identifying a single user while it's using multiple database correlations or logging into multiple databases. The Adviser plan and suggestions are not always helpful to the administrator in relation to the alerts or abnormal behavior.
- Very easy to use user interface. Also very handy for new users with a short time of introduction.
- Very good overview on all servers added. You can see in one sight which servers are busy.
- Well created metrics, a good starting point for adapting them.
- Alert system is very useful.
- No possibility to create overview groups to bundle SQL servers in more than one group.
- If an agent has an error there should be the possibility to send an alert.
- No support for by-products.
SolarWinds Database Performance Analyzer Review: "DPA allows Nasdaq DBAs to troubleshoot performance issues quickly and easily"
- Clear, Concise Performance Information
- Server Alerts are quick and easy to setup
- DPA could allow longer custom names, and reuse of names
- DPA could allow easier location of all executions of a query matching a certain pattern
SolarWinds Database Performance Analyzer Review: "DPA helps us with ongoing identification of slow running SQL code"
- Quickly points out what is slowing down our SQL server
- Provides daily statistics on most ran queries and their wait time
- Operates flawlessly with no maintenance
- Sometimes it cannot tell the SQL query text - I believe its when Entity Framework SQL is being ran
- Email notification when a SQL statement starts "killing" the whole server
- Full text search of specific SQL termS in all of the SQL code that it has captured
- I have used it to demonstrate disk issues to server admins by showing them the drastic increase in DB Commit times which turned out to be a failed NIC.
- I routinely use it to identify blocking sessions to verify ETL job issues.
- I use the waits and the top SQL to monitor system performance issues.
- I would like to have some visibility into the alert log in DPA.
- I would like to have tablespace/datafiles information regarding space and items contained in them.
Over the years DPA has helped us to resolve a lot of issues with blocking, locking, and excessive CPU utilization. We have done this both in real-time, during outages, and as part of our development pipeline.
- Real-time viewing into wait statistics, blocking and locking.
- Valuable query and table tuning advice.
- Historical tracking of wait times.
- The drill down usability is cumbersome.
- It's sometimes difficult to navigate exactly to where you want to be.
- Could use more information around parameters.
- Catches long-running queries that would normally have to sit and watch to catch.
- Ensures the resources on the server are adequate if not gives you a birds-eye view on when it gets bad and returns to normal. For example, maybe in the middle of the night when you are asleep, knowing the CPU is maxing wouldn't be an issue, as you would see this in the Hx information.
- If you have long-running queries and are aware of them, you can mark those with a name, either keep them on the Hx chart or set them aside to focus on new issues.
- There is not a lot, but one thing I would suggest is when SolarWinds gives you reported information— for example, this query has run 1500 times, for a total of 56 million reads—It doesn't have a way to break it down and show me all queries that have read 500K or larger. Much like a SQL profiler would.
SolarWinds Database Performance Analyzer Review: "DPA: Would not be able to do my job well without it!"
- The tuning advisor quickly guides me to where the biggest performance issues are.
- There's a lot of built-in "help," definitions and possible actions to take.
- Alerts and trending information are very helpful.
- I have to frequently and repeatedly click the "Dismiss" button on banner messages that appear at the top of the screen. They're just annoying.
- Detailed information on SQL queries.
- Good analysis of where problems are occurring.
- The lookups are very quick.
- The cost of this tool is pretty high, especially when using other SolarWinds products.
- A more user-friendly UI would be helpful.
- Notification of jobs failing.
- notification of someone making server level changes to an SQL server.
- Monitoring how busy the servers are.
- Make all the resource graphs a little longer, especially the 24 hours and 1 week. 25-26 hours and 8-9 days so it is easier to compare what is going on.
- Ability to customize the charts on the home screen.
- Make some of the most popular customer alerts apart of the default list.
Since we don't have a full-time DBA, we are not using DPA to its fullest, we mainly use it as a troubleshooting tool when needed.
There were a number of incidences when we had serious performance issues on the SQL Server, and DPA was able to help us to narrow down the type of issue, and the process that was causing the issue, which helped us to get the issue resolved quickly (by killing the process causing the deadlocks, etc.)
At the beginning of our DPA deployment, it also helped us to identify a number of expensive queries that will need to be optimized so that we can focus on improving these queries, and as the result of this, we improved the overall system performance.
- It provided a clear picture of how the system is performing, and which queries took the longest time to run.
- For the queries that took a long time to run, it provided us with the detailed analysis and recommendation on where was the problem and how to improve.
- When system has deadlocks -- it helped us to narrow down exactly which process was causing the problem, so that we were able to just kill that specific process to get the problem fixed, without the need to shut down all applications and reboot the whole SQL server.
- We also have one SQL server that has very light workloads, but from time to time DPA will still show CPU or query alerts on that server, which I believe were the false positives.
The more SQL Servers you have, the heavier the workloads on these servers, the better chance you can get a bigger ROI from BPA.
Compared to the impact to the business on potential downtime due to performance issues on SQL Servers, the cost of getting BPA in place is very minimum.
- Reporting, the detailed information regarding the issues it is showing.
- Easy to Use Interface.
- A better explanation of how to use the SQL plan should be implemented.
- Implement recommendations from the console.
history and detect current issues within our SQL Databases.
SolarWinds Database Performance Analyzer Review: "SolarWinds, Hit after Hit. Keep the great products coming."
SolarWinds Database Performance Analyzer Review: "SolarWinds DPA is an Excellent Performance Monitoring Tool for SQL Server"
- Excellent for trending SQL Performance over time.
- Excellent for monitoring deadlocks and blocking.
- Good for trending SQL query changes over time.
- It would be nice to have more built-in alerting capabilities.
- Indexing recommendations are also somewhat unclear. I have seen areas that say you could improve performance on a table for example but not giving any additional details beyond that.
- More in-depth recommendations, other tools like Idera Diagnostic Manager I feel are stronger in this area.
Alerting and notifications are not as strong as some other tools I have used.
Blocking and deadlocking features/analysis could be improved also.
- Real-time monitoring and notification of blocks and deadlocks on the database.
- Real-time notification of outages, including overnight issues that may arise.
- Ongoing monitoring, query by query, showing the impact of resources and utilization.
- Navigation is not always intuitive. Sometimes I need to drill down into 10-minute layers just to access a piece of information that I would have preferred to find at the hour or day level.
- DPA tells you if there are missing indexes.
- DPA gives you predicate warnings for SQL queries.
- DPA monitors main resource performance counters for the VM and host and also read and write latencies for data partitions.
- We DBAs often don't have enough insight into the type of hardware being used. For example I'd like to know if our SAN presents new pages as pre-initialized or the operating system re-initialize the pages.
- I'd like to be able to see in DPA if our infrastructure performs physical file fragmentation on our SAN.
- I would like to see IO blocks size that was used for SQL Server and other internals from infrastructure side that we DBAs don't have visibility.
SolarWinds Database Performance Analyzer Scorecard Summary
About SolarWinds Database Performance Analyzer
- SQL Server (including Azure SQL DB)
- Oracle MySQL
- DB2 (LUW)
- ASE (formerly Sybase)
What makes DPA stand out:
- Quick, easy, and reliable performance troubleshooting tracked in real time and historically
- Find inefficient workload, aggregated by table, for indexing opportunities—an “X marks the spot” tuning analysis
- Multi-vendor relational database support for your database environment in a single tool
- Blocking analysis: what is blocking and a hierarchy of what is being blocked, plus overall impact
- Integration with other SolarWinds products for more complete visibility (applications, servers, storage, hypervisor, network, and more)
- Quick, easy, and low-effort installation, configuration, and administration
SolarWinds Database Performance Analyzer Screenshots
SolarWinds Database Performance Analyzer Video
SolarWinds Database Performance Analyzer Downloadables
SolarWinds Database Performance Analyzer Integrations
SolarWinds Database Performance Analyzer Competitors
SolarWinds Database Performance Analyzer Support Options
|Free Version||Paid Version|
|Video Tutorials / Webinar|
SolarWinds Database Performance Analyzer Technical Details
|Deployment Types:||On-premise, SaaS|
|Operating Systems:||Windows, AWS Marketplace app|