Reviews (1-25 of 90)
- Peoplesoft DBs: we often use it to recommend indexes or find queries that need tuning.
- Availability group monitors and alerts so we know when there are problems.
- Trends over time: like blocking, deadlocks or stuck queries DPA helps pinpoint the cause.
- Bug with fantom availability group.
- Suggest indexes.
- Indicate the wait time for all processes, so you rank the issues and fix them by priority.
- You can send URL/ links to other to show them the exact point of problem. Easy for collaboration.
- Bookmark of problem, so we can revisit the issue and compare it before and after the changes.
- More details on deadlocks/blocking, etc.
- Notification, kind of monitoring, if wait time exceeds some threshold.. or review the wait time of specific bookmarks or issues.
Some queries, which only run very rare, but require a lot of waiting time whenever they do run (all queries that take longer than 60secs).
- Provides meaningful status at a glance.
- Highly configurable alerts (less spam/noise).
- Could allow better tuning for summary page information. Sometimes data is a bit stale.
- Could use better database level summary information in addition to server/instance level.
- Automated Collection into a queryable repository - Hands-off, detailed collection assures us that the bulk of any performance issues are noted, so that their data can be presented on-demand in a readily consumable form. Drill-into features enable detailed analysis.
- Performance Trend Analysis - Monthly top-consumers visualized in meaningful stacked-charts, with anomaly highlights and per-query, per-day detail enables hot-spot drill-down analysis.
- Resource Utilization Warnings - Best-practice warning and critical measure applied to all facets, visualized in real-time are essential features that trigger troubleshooting.
- Usability within the Trends and Current pages need improvement - Version 11 introduced a new Tuning feature, and changed the way one could quickly name a query and chose whether it would be of further interest, or is more infrastructure-oriented such that exclusion is warranted. Usability took a downward slide.
- Resource Utilization has preset periods which, for longer durations, overly smooth charts. Custom periods are much needed via the UI, rather than repository-querying.
- Storage analysis, similar to resource usage, needs custom periods and far greater ability to delineate between drives and files than v11 currently offers. (One rarely uses the Storage I/O tab)
- Quickly identifies slow running queries.
- Identifies which database is causing issues on a server.
- Provides an easy to read way of seeing stats on all servers quickly.
- No way to mark a query activity as normal, for example a slow running SPROC that has to be that way.
- Not many options to restrict access.
- Allows instant identification of highest impact performance issues
- Provides visibility of database load across the application
- Easy to configure and use
- It's a great product. I really can't identify any cons.
- monitor databases
- monitor servers
- monitor on virtualisation isseus.
- adding permissions for users or domain groups
- adding boxes is not easy
- being able to remove servers after x month (automagically or via an API)
- Pinpoints potential issues with databases.
- Suggests remediation for these problems.
- Allows you to narrow down to particular points in time where the problems were observed.
- It does take a while to gather enough data to suggest problems and fixes. Generally speaking, while you'll get some data back in an hour or two, you want at least 2 days of monitoring to get the best results.
- Licensing is a bit restrictive.
- Switching licenses between monitored nodes is a bit annoying.
- Track historical performance.
- Isolate the issue by providing a specific area of query impacting performance.
- Can track which user is causing the issue.
- Provides quick indexes where it makes sense.
- Auto tuning - It doesn't have the ability to implement the changes like Oracle Enterprise Manager.
- DPA free version is good but fully functional version should be allowed free for a limited number of instances to give users the ability to try functions without a need to make a purchase.
- 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).
- Monitors both SQL query performance and back end VM resources.
- Easy to read trend charts, bottlenecks or spikes show up immediately.
- East to drill-down into specific issues.
- Very good settings for alerts.
- Poor interface for managing alert times or blocking out alerts at times of the week. Very tedious process.
- The alert configuration is very robust, allowing simple OOTB alerts as well as complex query-based alerts.
- Blocking event tracking makes it easy to identify if a user's performance issue is a truly server-related performance problem.
- Historical tracking of queries allows me to easily identify frequently used statements that might need tuning.
- Some of the navigation leads to points that cannot be easily backed out of.
- Some navigation points lead around in circles.
- I would like to see index usage statistics as well as fragmentation.
- 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.
- 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.
- 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 Scorecard Summary
About SolarWinds Database Performance Analyzer
- Oracle Exadata
- Oracle EBS
- Microsoft SQL Server
- Azure SQL Database
- Azure SQL Database Managed Instance
- SAP ASE
What makes DPA stand out:
- Quick, easy, and reliable performance
troubleshooting available in real time and historically
- Machine learning anomaly analysis to bring intelligence to go beyond traditional threshold based analysis
- Find inefficient workloads, aggregated by table, for indexing opportunities—an “X marks the spot” tuning analysis
- Cross-platform database support for a single-pane-of-glass view into your environment
- Blocking analysis: what is blocking and a hierarchy of what is being blocked, plus overall impact
- PerfStack™ integration with other SolarWinds products for more complete visibility (applications, servers, storage, hypervisor, network, and more)
- Agent-less architecture with the ability to scale from a few instances to thousands, low 1% average overhead
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
- Has featureFree Trial Available?Yes
- Does not have featureFree or Freemium Version Available?No
- Does not have featurePremium Consulting/Integration Services Available?No
- Entry-level set up fee?Optional
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|