G2 Crowd builds the world's largest business commerce platform fueled by $100M in funding 🚀
Solarwinds Database Performance Analyzer

Solarwinds Database Performance Analyzer

4.5
(107)

Solarwinds Database Performance Analyzer monitors on-premises, on VMware®, and in the Cloud, including Amazon® AWS and Azure™ virtual machines. Agentless architecture, safe to use in production

Work for Solarwinds Database Performance Analyzer?

Learning about Solarwinds Database Performance Analyzer?

We can help you find the solution that fits you best.

Compare Solarwinds Database Performance Analyzer to Similar Solutions

Solarwinds Database Performance Analyzer Reviews

Ask Solarwinds Database Performance Analyzer a Question
Write a Review
Filter Reviews
Filter Reviews
  • Ratings
  • Company Size
  • User Role
  • Industry
Ratings
Company Size
User Role
Industry
Showing 107 Solarwinds Database Performance Analyzer reviews
LinkedIn Connections
Solarwinds Database Performance Analyzer review by John R.
John R.
Validated Reviewer
Verified Current User
Review Source

"DPA: Good Tool for Historical Reviews (SQL Server)"

What do you like best?

• Ability to review previous SQL Server queries/performance.

• Review poor-performing queries over time to know areas to focus on.

• Find out what was going on when we get call(s) from users about slow performing queries (or underlying reports).

• Ability to review blocking issues from a historical point of view.

What do you dislike?

• Inability to review SQL Server from a "resources" point of view and drill down into specific queries details.

• Inability to "group" queries together when the "filters" (i.e., where clauses) change but the overall query is the same.

• Cannot easily find a query using a "text search" without detailed knowledge of the underlying SQL database "repository" that is used to display the data in product.

• The tool, but itself, is *very* light on the resources side (CPU/memory/disk) compared to other vendors. You will need to purchase additional SolarWinds tools ($$).

Recommendations to others considering the product

There are many good tools on the market. We chose Solarwinds DPA (formerly Confio Ignite) due to the ease we could connect our SQL Server "repository" (internal network) to "cloud based" SQL servers without having to poke a lot of holes (open ports) in our internal network.

What business problems are you solving with the product? What benefits have you realized?

Ability to respond to poor server performance, mostly from calls from users who are having performance issues. We have been able to capture the poor performing SQL, review it and make various tuning adjustments (improve the overall query, indexes, etc.).

Most of the time, you do not get a call about performance when it is happening... you get calls/emails after the fact... which is one of the reasons for a good SQL performance monitoring tool.

Sign in to G2 Crowd to see what your connections have to say about Solarwinds Database Performance Analyzer
Solarwinds Database Performance Analyzer review by anup s.
anup s.
Validated Reviewer
Verified Current User
Review Source

"Must Have tool for Any SQL DBA "

What do you like best?

Ability to see current activities from multiple aspect/view is best thing for me.

When there is a an issue with any Server and need to quickly narrow down to the right place of root cause this is a tool allows me to focus on right places and remove all sorts of noise from data.

Tagging and Annotation is another great feature.

Ability to see the historical details/plan/ is very helpful while working on Query performance.

What do you dislike?

1) I can not search the specific text on any of the sub screen when drill down to session/sql/machine etc... tabs.

2) there is only one way to search the SQL by actual text is "SQL TEXT" and that is not complete. it would be good to have some place we can search specific sql I am looking for.

3) any adhoc sql/queries are not grouped to gather (like procedures) and hence its historical details can not be viewed. it will be good to have some way of connecting those adhoc sqls using same plan and being able to generate execution history.

4) on the same adhoc plan tab, for any given plan we have to drill down each sql manually one by one. it would be god to have some kind of summary popup/tool-tip when we hover over the plan in DPA.

What business problems are you solving with the product? What benefits have you realized?

It is a go to tool for me in my current work place for finding/analyzing/solving any type of SQL DB issues.

it removes the waste from screen speed up the process that increases the over all cycle time for resolving any DB issue.

What Application Performance Monitoring (APM) solution do you use?

Thanks for letting us know!
Solarwinds Database Performance Analyzer review by Parag K.
Parag K.
Validated Reviewer
Verified Current User
Review Source

"A very useful database monitoring tool which eases troubleshooting very much "

What do you like best?

The best thing about DPA is it identifies the performance issue with in seconds and by focusing on wait stats identifying the root cause is very easy. We can see instantaneously if blocking was occurring at any specific time and what were the root blockers. The good thing is it gets down to minutes and even seconds of time in terms of granularity. It also allows to set up various custom alerts which is very beneficial

What do you dislike?

The thing I found to be wanting in solarwinds DPA is the graphs for various metrics can capture time - value pair of only one metric. I can't capture multiple instances of a metric (for example - multiple replication distribution agents latency values ) from with in DPA

Recommendations to others considering the product

The tool is recommended because its very easy to use and rich in feature set

What business problems are you solving with the product? What benefits have you realized?

We mainly use DPA for performance monitoring and optimization of our SQL databases. It allows benefits like blocking identification, capturing resource bottlenecks like CPU, memory etc and we set up numerous customized alerts in solarwinds DPA.

Solarwinds Database Performance Analyzer review by Greg A.
Greg A.
Validated Reviewer
Verified Current User
Review Source

"Database Performance Analyzer review"

What do you like best?

The software is easy to upgrade and administer.

SolarWinds provides good support.

The main dashboard shows which database instances are experiencing the greatest wait times. It also shows those with the greatest upward wait times. There is a status summary with counts that are color coded for quickly finding issues. Below that, is a listing of all the instances with a color coded status across multiple categories. From there, you can start drilling down into specific instances and see top SQL statements, Waits, Programs, Users, etc. It is very easy to see trends or if it was just an abnormality. You can see across days or drill down into specific hours. It also provides advisors and quick resources (e.g. wait descriptions).

What do you dislike?

The cost for licensing Oracle RAC instances is expensive. Each instance costs $3,495 at list price which adds up quickly.

Recommendations to others considering the product

Should be at the top of your list.

What business problems are you solving with the product? What benefits have you realized?

When new queries are introduced into the environment and are detrimental, we quickly see when it started and the frequency that it occurs.

We also use this to quickly focus on the top queries causing issues instead of isolated incidents.

Solarwinds Database Performance Analyzer review by Richard C.
Richard C.
Validated Reviewer
Verified Current User
Review Source

"Window to my SQL server"

What do you like best?

You can easily find the most expensive queries. we have found that DBA's and developers a like both like that application, I work in support so i can also see how the server is performing and then contact the DBA or Deve guys to say ... hay... look at what your latest software patch is doing to the DB. one of my favorite things is that you can pull data from Database Performance Analyzer into some of solarwinds other software like into Software Application module.

What do you dislike?

SSAS .. when are we going to be able to monitor that? I'm sorry to say that the Price is the thing that is the thing I dislike the most. The amount of time i have to say well another license will cost £X that is when they normal leave my desk very quickly.

Recommendations to others considering the product

We love the application and so do the developers, DBA and people like myself, people in application support we all use it, we have found it a bit expensive. The layout is great easy to navigate, we have just started use the alerts and the reporting features which seems to be working well. We also use Solarwinds Software Application Module which you have cnn link the two softwares together so you can have data and information that Database performance analyser gathers pulled into the software application modules dashboards.

What business problems are you solving with the product? What benefits have you realized?

Developers can see the performance on the database with out having direct access to the database.

Solarwinds Database Performance Analyzer review by kaka t.
kaka t.
Validated Reviewer
Verified Current User
Review Source

"Solarwinds for IT Management "

What do you like best?

Master database and SQL query tuning counselors . Recognize database issues continuously . Cross-vendor database bolster from a solitary interface . Integration with the Orion Platform . These are the best things when using Solarwinds and which also helps in improve the performance .

What do you dislike?

The Solarwinds solutions starts at $1995 which is quite costly as compared to Nagios XI which is cheaper and also has great web accessible interface .

Recommendations to others considering the product

It provides quick, easy, and low-effort installation/configuration and administration as compare to other competitor like Nagios XI

What business problems are you solving with the product? What benefits have you realized?

We mostly use it to find solution for complex problems because when teams collaborate , they needs to solve problem faster and efficiently . Also we can monitor database in hybrid environments which is quite helpful .

Solarwinds Database Performance Analyzer review by M R.
M R.
Validated Reviewer
Review Source

"Keep on top of your databases with ease."

What do you like best?

DPA is a great tool for any database administrator. It helps you have a simple oversight of all your databases and highlights possible problems or performances issues, that could be affecting the end user. It highlights problems with historical statistics and helps you keep on top of maintenance and troubleshooting, these are just some of things we love.

What do you dislike?

It doesn't feel like an independent module and requires SAM to get full use out of it. The cost of licensing could be cheaper, especially when you need other modules to really utilise it fully. Acquiring the licensing and other modules in one hit can be expensive.

Recommendations to others considering the product

If you're tired of running queries or being in the dark when it comes to your database problems then DPA is a great tool. It will save you time and help you spot problems much quicker than manual troubleshooting. It's worth checking out the trial and seeing it in action for yourself. It doesn't take too long to set up.

What business problems are you solving with the product? What benefits have you realized?

It highlights speed issues and has drawn our attention to bottlenecks almost instantly, without the need of too much work. It can highlight issues quickly and prevent downtime and complaints, by giving us the ability to react to problems quicker. It saves us so much time and is well worth it.

Solarwinds Database Performance Analyzer review by Franklin W.
Franklin W.
Validated Reviewer
Verified Current User
Review Source

"DPA is everything your DBA desires"

What do you like best?

Even though SQL server has the information available to your DBA, it doesn't compile and present it the same way that DPA does. Not only that, but you can title specific sql actions to maintain a visual on the actions that are common and causing the highest wait times.

What do you dislike?

I dislike that the trial was only 14 days... `

Recommendations to others considering the product

The setup is pretty simple... just make sure you have the right credentials for each instance!

What business problems are you solving with the product? What benefits have you realized?

We have already realized over 10 different issues that we were able to quickly resolve across multiple departments simply by letting it do it's thing. My DBA was giddy with excitement and we totally ended up purchasing it because of the impact it had on our business.

Solarwinds Database Performance Analyzer review by Mark W.
Mark W.
Validated Reviewer
Review Source

"Making DB management so much easier!"

What do you like best?

DBA by solarwinds is another excellent module for DB management and monitoring. If you have felt like you're blind to DB performance issues, DB problems or anything else then this product will change the way you work. It will help you find problems much faster and even prevent potential downtime, by bring things to your attention before they cause problems. The varied views help you have a quick oversight of all your DB without going in and out of various windows. The historical information is another by win for DBA, allowing to monitor query performance etc.

What do you dislike?

DBA lacks search capability at the moment and this would be something that would improve it, if it was implemented. It would also be nice if it was closer integrated with the rest of the solarwinds platforms, as it feels like a separate product entirely at times, though this isn't that big a deal.

Recommendations to others considering the product

If you feel like you're always blind to DB problems and are not sure where to start then DBA could be the way to go. Check out a trial first to see it in action and i'm sure you'll start to see what it has to offer and how it can improve your day to day workload.

What business problems are you solving with the product? What benefits have you realized?

It's hugely increased workflow and productivity and prevented definite downtime on more than one occasion. It's also helped us keep our DB more streamlined to prevent slow down for end users.

Solarwinds Database Performance Analyzer review by Matt R.
Matt R.
Validated Reviewer
Review Source

"DPA makes life so much easier in the Database world."

What do you like best?

The UI is a great way of drawing your attention to the potential or ongoing problems with your DB. You can see at a glance or an even more in depth view if you so wish. It has helped us build trends and resolve problems by simply allowing the program to monitor our DB. If you're looking for a program to monitor and even predict potential issues with you DB this is it.

What do you dislike?

It doesn't integrate into NPM as well as other modules and doesn't offer some of the detailed views and charts that NPM generally offers. Other than that it's great.

Recommendations to others considering the product

If you are looking for software to monitor and bring DB problems to your attention then this is it. It's extremely helpful, not too hard to set up and will give you peace of mind once you're live.

What business problems are you solving with the product? What benefits have you realized?

It prevents downtime or even future downtime, by allowing us to nip potential issues in the bud before they happen. Also a much easier way of seeing the DB etc.

Solarwinds Database Performance Analyzer review by Grant A.
Grant A.
Validated Reviewer
Review Source

"DPA personal review"

What do you like best?

I personally love the real time aspect to troubleshooting. It is often something other products can deflect. It fully integrates into other Solarwinds products like NPM. Cross vendor support is also a great benefit, SQL, Oracle, MySQl, SAP, and cloud offerings.

The live charts are worth their weight in gold. being able to see and then go back in time to check before the issue happened is wonderful and one of its best features. I have used other products that over look this and the fact you can alter the granularity yourself is great.

What do you dislike?

some of the features are needed to get the most out of the other solarwinds products. you often feel like you have to buy the set to get the most befit.The cost of the product can quickly rise. The start price is great but in reality its vastly higher when you factor in a larger environment. I know its cheaper then other solutions however when you factor in you really need other modules to make sure you're getting most out of it (SAM) it really does rack up the cost.

Recommendations to others considering the product

personally I would use this in conjunction to owning the other solar winds products. NPM and SAM are a must

What business problems are you solving with the product? What benefits have you realized?

bottlenecks. It comes with a lot of of the box and is able to detect issues I wasn't aware of. It makes you seem like a Database performance specialist even with limited knowledge. We have seen a few speed issues just from the real time performance charts.

Solarwinds Database Performance Analyzer review by Matt W.
Matt W.
Validated Reviewer
Review Source

"Casual SQL user"

What do you like best?

I like that I can very easy to identify performance issues and find the most of the time find the root cause in a single pane of glass. This is really helpful for example when users are complaining of slowness issues on a business critical application and this tool can potentially provide the answer in a short of amount of time if the issue lies on at the database level. There are many positives to the product, but being able to pinpoint an issue is huge.

What do you dislike?

It would be nice to be able to create traces on the fly based on findings from DPA. It would also help be nice if the product were more customizable. More intuitive reporting would be nice, but I've found that Solarwinds reporting in general is sort of difficult and is not limited to just the Database Performance Analyzer module.

Recommendations to others considering the product

I think this is a great tool to monitor databases and to identify issues that could potentially affect critical business applications. Anyone who is looking for a product that provides a high level of functionality in a single pane of glass would definitely benefit from Solarwinds Database Performance Analyzer. I am sysadmin and a very casual SQL user and this product is very easy to follow and understand even though I am not proficient in database administration.

What business problems are you solving with the product? What benefits have you realized?

We are able to find root cause for critical application issues and to keep an eye on performance to proactively attack and/or prevent potential issues.

Solarwinds Database Performance Analyzer review by Consultant in Information Technology and Services
Consultant in Information Technology and Services
Validated Reviewer
Verified Current User
Review Source

"DPA - Precise Performance Measurement"

What do you like best?

It's very simple to deploy and starts collecting data as soon as we link it to a database. I like that we can drill down to one second interval. Plus it retains the data for 5 years. One of the greatest advantage is that it as minimal impact on the monitored SQL server.

There is the resource adviser which gives us an idea of where the issue probably is and where to start the investigation.

We use this in addition to SolarWinds Orion SAM - which as AppInsight for SQL template. This gives us additional metrics we can look for to see if it's more of a server issue (memory, CPU, storage, etc).

During the first usage we were immediately able to see the high wait times and that it was attributed to the NETWORK_IO. This is something we can investigate and is in our control.

What do you dislike?

Would be nice to customize the views, similar to Orion. So different users have a customized view. The user administration is pretty basic and isn't built for multi tenancy. But this tool is primarily for the DBAs and I have not seen anyone else use it.

Recommendations to others considering the product

DPA is very detailed in it's analysis - it's really meant for DBAs. I have seen some system admin use it - but not that effectively.

What business problems are you solving with the product? What benefits have you realized?

Excessive wait times and what's causing it. There are things which can't control, such as badly written queries; however there are things within our control like server memory, CPU allocation, IO bandwidth, storage latency, etc. These are the factors we can concentrate on to improve the overall response time of the database and reduce waits as much as possible.

Solarwinds Database Performance Analyzer review by Michael P.
Michael P.
Validated Reviewer
Review Source

"Easy to Understand and Use for Everyone"

What do you like best?

DPA makes troubleshooting database problems easy for those that do not have a database background. Regardless of your knowledge of database, you will be able to find root cause in DPA.

What do you dislike?

The architecture limits a single poller to about 250 instances. Each poller has it's own corresponding database. I would prefer that there is a higher level parent / child relationship instead of breaking out each pair.

Recommendations to others considering the product

DPA provides insights into database problems for all skill levels. If you have never logged into a database before or if you are a database admin, you will find that DPA provides valuable information to help make your job easier.

What business problems are you solving with the product? What benefits have you realized?

DPA has provided insight into our databases for all areas (Dev, Ops, Tech, etc.). The detail of information has eliminated a lot of troubleshooting time to find root cause. We have used other database tools in the past, but none compare to the value that DPA provided.

Solarwinds Database Performance Analyzer review by Ethan B.
Ethan B.
Validated Reviewer
Review Source

"Solarwinds DPA must have"

What do you like best?

The amount of information given to you in one place. They make it easy to track down the issue at hand. You need need to do any other queries for trying to find the issue you have. Bring up Solarwinds DPA and you can get all the information you need. There is even a new feature that you can use DPA information and show it along side information from other modules so you have data to compare at a particular time frame.

What do you dislike?

Is there something I should dislike? The Solarwinds interface can be slow at times and I know there are ways to make it more responsive but have not gotten to optimization yet. Sometimes there can be an overwhelming amount of data. They do a really good job at delivering you anything and everything you need, just need the time to sort it all out.

Recommendations to others considering the product

need to give it a try and see all the information it can give you. If you have at least one DB install this software and see what information you can get you never seen before.

What business problems are you solving with the product? What benefits have you realized?

Database bottlenecks have been much easier to locate. We recently just had an issue with a system constantly going down and we created a performance analysis comparing data from the server hardware, system, DPA and the network to find the issue. Being able to see all the data we needed including the deep dive into the DB helped us pin down the exact issue and rule out what was not the issue.

Solarwinds Database Performance Analyzer review by Christopher G.
Christopher G.
Validated Reviewer
Review Source

"Best database performance monitoring"

What do you like best?

I like that you are able to see everything involved with the databases. It is very easy to see what queries are taking the most time and you can see the exact query that is being executed. It is easy to setup and you can get monitoring going very quickly. The performance of the actual DPA application is very fast. Upgrades are very quick as well. They usually only take about 20 minutes. It supports all common DB languages. A wizard allows the adding of database instances very quickly.

What do you dislike?

The product needs more integration into the Orion platform, especially for reporting. It would be nice if the alerts and reporting were setup like the Orion platform. This product was purchased by SolarWinds and does not yet have the same feel as the Orion platform. I am sure this is on the radar and will take time. I would also like to customize the charts more that are pulled from DPA, in the Orion interface. It also needs to have some sort of agentless monitoring. The cost can be significant when monitoring a lot of instances.

Recommendations to others considering the product

If you want to see database performance and more than you will ever use, use this product. You wont be sorry.

What business problems are you solving with the product? What benefits have you realized?

We use it mainly to solve problems with application performance. Often, it is the application's database that is the issue. DPA shows us that it really isn't even the the actual database, but improperly written queries.

Solarwinds Database Performance Analyzer review by karthik A.
karthik A.
Validated Reviewer
Review Source

"“DPA is much easier to use and far more effective than the other tools I’ve used.”"

What do you like best?

Anyone can easily understand even if they are seeing Database parameters for first time like SQL queries Transaction time, Table Locks and tools from Solarwinds are much easier to operate than any other tools.

The new feature introduced in latest releases "Correlation of metrics" is most helpful and easier to find what is causing the issues. can drill down to blocked SQL Server queries to discover why the database server blocked them.Monitoring expensive queries lets you see poorly written queries, queries that take too long to respond, queries affected by CPU time, efficient queries that are delayed by slower queries.

Multi-Dimensional Performance Analysis makes me troubleshooting simple.

Gained time to focus on more important or strategic parts of my job.

What do you dislike?

There is no negative feedback on Solarwinds Modules except the license part.

Recommendations to others considering the product

Best in the Tools

What business problems are you solving with the product? What benefits have you realized?

SolarWinds DPA provides visibility across application requests, SQL statements, database resources,

host/OS, network, virtualization, and storage performance. DPA incorporates wait-time

analysis so the focus is not only on health, but on the speed at which the database responds to

application requests. With “slow” rapidly becoming the new “broken,” SolarWinds DPA empowers

database administrators, developers, and all IT pros to quickly pinpoint the root cause of

performance issues. It then provides valuable advice for quickly resolving the issues.

Solarwinds Database Performance Analyzer review by Chinmay C.
Chinmay C.
Validated Reviewer
Review Source

"Database Performance Analyzer - Keep your DB in safe hands"

What do you like best?

Drill down into your SQL Server database to pinpoint the root cause of poor performance.

When a SQL Server database instance includes Availability Groups (AGs), the DPA homepage provides the following information:

The AG status icon AG_status_icons.png identifies database instances that include AGs. The color of the dot indicates the AG status.

An AG status summary box shows the number of database instances with partially healthy or unhealthy AGs. As with other status summary boxes, click the filter next to a status to display only those instances.

AG_filter.png

When you drill in to a database instance that includes AGs, click the AG Status tab to see the status of AGs, databases, and replicas, including synchronization and failover status information.

What do you dislike?

wrong parsed query in mysql slave

Alerting needs to be more crisp

Custom Report for Resources for a Program in DPA

Automatic exporting for DPA logs should be added into newer versions

Recommendations to others considering the product

The UI and ease of use is better with SolarWinds DPA

What business problems are you solving with the product? What benefits have you realized?

Currently all of our DB's are under DPA monitoring.

Its ease of use makes itself more prompt than the other tools.

The application is mostly used for the AWS environments.

Oracle 10gR2 (10.2.0.5) is not supported with DPA 10.2.579

Solarwinds Database Performance Analyzer review by Administrator in Hospital & Health Care
Administrator in Hospital & Health Care
Validated Reviewer
Verified Current User
Review Source

"Deep Dive Analytics for all Engineers"

What do you like best?

The ease of use for non-DBAs and constant improvements to the platform. The product as a whole is very easy to implement in large-scale environments and the current roadmap is following the industry trend of moving relational databases to the cloud (aka, Amazon RDS, etc.)

What do you dislike?

Lack of a customizable reporting engine to create reports for external stakeholders.

Recommendations to others considering the product

Take advantage of the free demo and lookup the DPA Training YouTube Playlist on the SolarWinds channel.

What business problems are you solving with the product? What benefits have you realized?

We monitor production databases from across the enterprise; which allows us to correlate incidents through our full stack; from customers > websites > app > db > virtualization > storage > network. The insights we gain from DPA commonly allow us to provide engineers with metrics showing necessary improvements to codebase (developers), database schema (DBAs), and server right-sizing (virtualization and storage engineers).

The end result is FAST identification of root-causes without back and forth finger pointing. The ease of use for non-DBAs is an extremely important feature as well, as we have a wide range of consumers of this data.

Solarwinds Database Performance Analyzer review by Administrator in Information Technology and Services
Administrator in Information Technology and Services
Validated Reviewer
Verified Current User
Review Source

"DPA Keeps SQL Running Smoothly."

What do you like best?

I love the query advice tab. It is great to have specific issues highlighted and ready for review. The real-time tab is always useful for our help desk team. Solarwinds Thwack user community is full of amazing resources and tips for getting the most out of your DPA install. You really can't say enough about Solarwinds' after install support for their products.

What do you dislike?

I dislike that we only have a single instance licensed. We regularly repoint DPA to whatever database is generating users calls. It'd be much better if we were able to monitor all of our databases at once. Management consistently balks at the cost of additional licensing (this seems to be a regular concern with our Solarwinds products).

Recommendations to others considering the product

It is worth comparing this to the Idera offerings. They also do a nice job monitoring SQL performance.

What business problems are you solving with the product? What benefits have you realized?

My employer does application and database hosting. We recently used DPA to identify an issue with a query more quickly than the 3rd party application developers were able to. Our client was very pleased with our speed to resolution, especially considering the so called experts were still chasing their tails.

Solarwinds Database Performance Analyzer review by dale f.
dale f.
Validated Reviewer
Review Source

"DPA review"

What do you like best?

We've been using DPA for a couple of years now for our production Oracle instances. It's been incredibly valuable. Within a couple of weeks of installation, we were able to identify and correct an issue with some reporting that had been plaguing us for months. Even though we have and use Grid Control on a daily basis, without that additional wait info that DPA brought to the table we could not nail down the source of the problem. We now use it for our production MS Sql Server and MySQL instances and our DBAs are in it all day making sure everything is running well and identifying and quickly addressing issues that we see. Fantastic tool.

What do you dislike?

After 2 years, I can't say I've found anything that I wish it did that it doesn't already do. Great tool, and the price is outstanding compared to competing products.

What business problems are you solving with the product? What benefits have you realized?

All the things that happen on a daily basis in any production RDBMS environment. Performance tuning, changing (in some cases dropping) or adding indexes. Identifying poorly performing queries and giving hard data on where the problems lie to our developers so they can correct it. We literally use it all day every day. If you have Orion, the integration with other Orion tools makes end to end analysis and troubleshooting even easier.

Solarwinds Database Performance Analyzer review by Kyaw T.
Kyaw T.
Validated Reviewer
Review Source

"Productivity gains from quick troubleshooting."

What do you like best?

We purchased Confio Ignite (now DPA) as it was called back, hoping to alleviate the time taken when performance issues occurred. Due to budget constraints, we have only one SQL Server DBA which was borderline OK as far as workloads go. However, we would fall behind whenever performance issues popped up or when troubleshooting needed to take place. DPA has worked wonders for our DBA and enables him to rapidly pinpoint where the performance issue is with a SQL Server database. We have also started to use DPA to provide alerts when things are not 100% OK in our SQL Server environment.

What do you dislike?

The graphs showing top SQL statements and top waits, etc. are difficult to interpret because the colors used in the bar graphs are shades of the same color. It is often difficult to distinguish between the shades to determine which queries are the top offenders when the shades of red or green or blue are so close together. Note that this is not the case when you log in to look at details. However, the high level charts in emails are difficult to make out. I feel I should not have to log in to be able to make out the details - I am busy enough as it is.

Recommendations to others considering the product

There are a lot of features in DPA that make it worthwhile in itself. Try the free trail to get a feel for it. Additionally, SolarWinds has built an ecosystem around it. We run SQL Server on VMware and having the ability to monitor the VM on which SQL Server is running is very useful for a DBA (the VMware module adds VM stats to DPA - it is a separately purchasable module and not part of DPA). It lets the DBA independently monitor and verify the performance and state of the VM w/o having to bother the system administrator. This lets the DBA determine whether or not the host VM is having resource issues, etc.

What business problems are you solving with the product? What benefits have you realized?

1. I get quick resolution to performance issues that used to take a lot longer to troubleshoot.

2. I get alerts in advance of something bad about to happen. We do not have to wait for application users to alert us to issues.

3. We have started to use DPA for our Oracle standard edition as it works so well with SQL Server. Although we have Oracle Enterprise Manager for our Oracle Enterprise databases, this does not cover monitoring Oracle Standard Edition databases.

Solarwinds Database Performance Analyzer review by Varaprasad I.
Varaprasad I.
Validated Reviewer
Review Source

"One of the best performance analyzers on the market"

What do you like best?

The stunningly easy way to see a visual with the expensive queries bringing down system's performance. Works really well with both Oracle and SQLServer. DBAs life has become so easy due to this software

What do you dislike?

Price is on the higher end, but definitely realizes the ROI in the mid-long term. This software becomes a little redundant once everyone moves to a c full cloud storage solution. Trial period for 14 days was too little to evaluate but was able to extend thru the account manager

Recommendations to others considering the product

Evaluate your long term ROI versus short term since you may not get full ROI within 1-2 years. You will however see the results immediately

What business problems are you solving with the product? What benefits have you realized?

Definitely shorter turn around time to resolve issues as this software pin points the bottle necks right away.

There's an alerting mechanism that sets our DBA team to be more proactive

Solarwinds Database Performance Analyzer review by Cláudia J.
Cláudia J.
Validated Reviewer
Review Source

"Easy tools and efficient"

What do you like best?

Interface friendly, easy customizations, emission reports, creations alerts, instalations and show where have problem in data base, do what it says. Easy for add and remove data base, i think is better do work in option of remove the daba base only monitoring, but not lost your informations, and if after the user beed see her can do.

What do you dislike?

Months ago I have a problem in migrations server, when I try a new integrations with NPM. After more troubelshotter and grant help solarwinds team, all was it ok. Maybe to work in to simplify this process is better.

Recommendations to others considering the product

Ah add another tada base for monitoring. EX: Postgre, and Dababase not SQL .

What business problems are you solving with the product? What benefits have you realized?

Whem a daba base server os sistem are slow we can see before of the final user, for us this is a great reasons for user DPA.

Solarwinds Database Performance Analyzer review by Rasik R.
Rasik R.
Validated Reviewer
Review Source

"DPA to trust your database"

What do you like best?

When a SQL Server database instance includes Availability Groups (AGs), the DPA homepage provides the following information:

The AG status icon AG_status_icons.png identifies database instances that include AGs. An AG status summary box shows the number of database instances with partially healthy or unhealthy AGs. As with other status summary boxes, click the filter next to a status to display only those instances.

What do you dislike?

Alerting needs to be more promising

Custom Report for Resources for a Program in DPA

Automatic exporting for DPA logs should be added into newer versions

Recommendations to others considering the product

Great tool!!!

Ease of access

Ease of use

Easy to deploy

Very light weight

Data integrity is maintained

What business problems are you solving with the product? What benefits have you realized?

Its ease of use makes itself more prompt than the other tools.

The application is mostly used for the AWS environments.

Oracle 10gR2 (10.2.0.5) is not supported with DPA 10.2.579

Solarwinds Database Performance Analyzer review by Chad B.
Chad B.
Validated Reviewer
Review Source

"Solarwinds DPA"

What do you like best?

I love the integration with the existing Orion platform, as we also use Network Performance Monitor and Network Configuration Management. Agentless architecture. Gives direct insight on database performance, showing top queries, wait times, identifying database problems in real time. We currently only use SQL Server, but as our company grows, it's nice to know that there's cross-vendor support all from this one interface, in case we acquire an office that uses Oracle or MySQL.

What do you dislike?

I'd like to see more input on solutions to the detected problems.

Recommendations to others considering the product

Database Performance Analyzer is an absolute must for all DBAs, especially in the small to medium business world since we're often multitasking different roles beyond database administration.

What business problems are you solving with the product? What benefits have you realized?

Getting our SQL servers to run more efficiently. As a relatively inexperienced DBA, DPA has helped me more easily identify sources of problematic performance.

Solarwinds Database Performance Analyzer review by Richard P.
Richard P.
Validated Reviewer
Review Source

"Excellent insight into what your Databases are really doing"

What do you like best?

The simple, yet very powerful interface makes DPA (Database Performance Analyzer) a product that is easy to implement and use. The power of the product gives insight that would otherwise only be available through hours of trial and error testing and processing. SQl can be complex to diagnose, but with DPA that time and effort is greatly reduced.

What do you dislike?

While the product is very complete it can't make users actually pay attention. Our DBAs have access, but don't rely on the product as much as they should. But then this is a shortcoming of pretty much anything.

Recommendations to others considering the product

Download the free trial and you'll find it easy to install configure and use.

What business problems are you solving with the product? What benefits have you realized?

We had some slow performing SQL databases and DPA helped us identify underlying issues that couldn't be solved just be adding more CPU or memory

Solarwinds Database Performance Analyzer review by Luke D.
Luke D.
Validated Reviewer
Verified Current User
Review Source

"Sometimes the SQL is better than the original"

What do you like best?

I really liked the capability of monitoring the SQL performance of different queries

What do you dislike?

If I had to pick a least favorite piece of the whole process, it would be installing the application in the first place, because no one ever likes that, even though the documentation was very well done.

Recommendations to others considering the product

Definitely download the trial and try running some of your more processor intensive queries and actions. See what the software can really do and see what it is the best at.

What business problems are you solving with the product? What benefits have you realized?

I was optimizing queries so that I could have the least amount of server impact

Solarwinds Database Performance Analyzer review by Randy P.
Randy P.
Validated Reviewer
Review Source

"Solarwinds DPA"

What do you like best?

I like the monitoring of access and commit times. The amount of I/O tracking is amazing. It helps to quickly drill down to the root cause, which helps in a more expedient determination of our issues. I have also noticed that we get a more heads-up on issues that have yet to be reported to us.

What do you dislike?

I have not found anything so far. I really like this feature all around. The main page is a little overwhelming at first for users, but once they learn where everything is located, the main page is perfect.

What business problems are you solving with the product? What benefits have you realized?

Our biggest problem was tracking down where our issues were with latency and CPU usage. Also, the delay in reporting from end user issues and the database could be delay several minutes.

Solarwinds Database Performance Analyzer review by Jennifer A.
Jennifer A.
Validated Reviewer
Verified Current User
Review Source

"Got a problem with your database performance, and the DBA blames the network, install DPA! "

What do you like best?

The ability to drill down on queries and to download reports with graphs for management.

What do you dislike?

It is still difficult to explain to management that it is NOT the network. The graphs have helped substantially; I wish that there were a "view for dummies" !!

Recommendations to others considering the product

This product really helps you find out what is going on inside the database, it is very granular and has assisted our operation tremendously in cutting down wait times.

What business problems are you solving with the product? What benefits have you realized?

I have proved that it is NOT the network. We now have regular quarterly database maintenance windows!

Solarwinds Database Performance Analyzer review by Mark M.
Mark M.
Validated Reviewer
Review Source

"DPA for non-DBAs"

What do you like best?

Integrates well for a robust application monitoring and troubleshooting experience. When using APM and node groups we are able to utilize AppStack views, reports, and dashboards to provide end-users, admins, and execs the right view and information levels.

What do you dislike?

The interface is not as good as other Solarwinds modules. There is a learning curve even for regular Solarwinds users. The cost and licensing can become a concern.

Recommendations to others considering the product

The power of this product is in its ability to scale and implement with other Solarwinds products. I highly recommend having all of your infrastructure be involved in the planning and implementation phases to get the most out of this product.

What business problems are you solving with the product? What benefits have you realized?

Critical application monitoring and database connection statistics for real time alerting and troubleshooting.

Reporting for historical root cause analysis

Solarwinds Database Performance Analyzer review by Ravi K.
Ravi K.
Validated Reviewer
Review Source

"Analytics at its best"

What do you like best?

Various aspects of the DPA including queries that take up the most Wait Times, Deadlock conditions, compute resources consumed by the DB instance like CPU, Mem, and best part even Virtual infrastructure resources.

With recent additions to the NPM + DPA integration, PerfStack allows cross module correlation helping identify issues with network or server or DB at the same time

What do you dislike?

Reporting feature should allow customization

What business problems are you solving with the product? What benefits have you realized?

Our DB instances run most of the business applications and DB Administrators are required to provide an optimal performance of the DB and hence the Business Apps. Insights into DB performances are thereby helping us resolve Biz App performance issues and ensuring that Biz Apps run at desired performance levels.

Solarwinds Database Performance Analyzer review by Consultant
Consultant
Validated Reviewer
Verified Current User
Review Source

"Database administration and performance troubleshooter"

What do you like best?

Quick visual of performance bottlenecks and the drill down within every screen is a great feature in trying to get to the bottom of fixing an error troubleshooting query performance.

What do you dislike?

If we can get more tips on database related messages as it seems the recommendations are sometimes very general in nature

Recommendations to others considering the product

DPA is easy to install and very lightweight so no worries on the analyzed database or instance taking a performance hit.

What business problems are you solving with the product? What benefits have you realized?

DPA has helped me get to the bottom of a long standing performance issue with a client ERP on SQL server and we have now stabilized the performance. DPA showed me where and which time the major bottlenecks where coming from. Now we can move to tuning the queries with DPA.

Solarwinds Database Performance Analyzer review by Administrator
Administrator
Validated Reviewer
Review Source

"A greater insight into database performance."

What do you like best?

DPA offers a great overall view of your live databases and can immediately draw your attention to potential problems. It saves you a lot of time in the way it can troubleshoot a lot of problems for you or bring to your attention problems that could lead to downtime etc. It’s easy to set up and gives you peace of mind, especially when managing multiple databases. It has helped us solve ongoing problems by relaying historical information and bringing certain trends to our attention. Highly recommended.

What do you dislike?

As good as DPA is, it can get quite costly especially if there is a need for growth. Some reporting and the in built search could be better.

Recommendations to others considering the product

If cost isn’t too much of a worry and you’re looking for insight into your database health then consider DPA. You can download a full trial of the product that can help you see what the product can do for you.

What business problems are you solving with the product? What benefits have you realized?

It is a massive time saver and helps us rectify problems quicker, resulting in less downtime and helps us be more productive. It also helps remove potential problems before they turn into one.

Solarwinds Database Performance Analyzer review by Sagar B.
Sagar B.
Validated Reviewer
Review Source

"DPA a good solution to monitor performance of your Databases."

What do you like best?

SQL query tuning advice.

Identifies database problems in realtime .

DPA can monitor database instances that you manage running on physical or virtual servers. It can also monitor Amazon RDS instances hosted in the Amazon Elastic Compute Cloud (EC2).

What do you dislike?

Overall a very good but as all products have some flaws, it too has one which is sometimes experiences slowness.

Recommendations to others considering the product

My recommendation to others considering DPA is that they should install a 15 days evaluation version of DPA, to checkout if this product meets their requirements.

What business problems are you solving with the product? What benefits have you realized?

Identifies Blocking sessions and deadlock for a query.

Generates an alert for a query taking longer to execute.

Gives an advice for better query execution.

Minimum system requirements.

Solarwinds Database Performance Analyzer review by Administrator in Staffing and Recruiting
Administrator in Staffing and Recruiting
Validated Reviewer
Review Source

"Easy install opens deep doors into your db performance"

What do you like best?

DPA is very easy to install and takes little time. The demo was up and running within an hour after spinning up the host VM. This gave our DBA team a change to try it out before we made a purchase. Other tools are a full project to get running and leave agents and tracks all over the environment. DPA does not, if you uninstall there is nothing left behind excect the account used to monitor the databases. These accounts can be quickly deleted and there is no trace of DPA left behind. This is important for beta testing. We were able to test in our Prod env and got a real look at what we were buying. The ease of use makes everyone in the NOC a value adding DB performance monitoring guru. SW products are mostly very user friendly, DPA also fits this description. The data provided is top shelf from engineer, to dev, to IT executive. Built in reports give you great data from day 1 and a little customizing makes you look like a DB Performance Monitoring Master. Low cost solution that gives you a ton of value.

What do you dislike?

Nothing to note as of yet. Since DPA is a newer product from SW I am not sure how support will be if we ever do need to engage. I have to assume it will be similar to the other products in the suite..

Recommendations to others considering the product

Do the demo and see what you think. Install is very quick and simple so its an hour of your time and then turn the DBA team lose. The cost is much lower than most other tools on the market so ROI is not a factor. Install is easy to remove if you don't like the product after the beta and no agents or other tracks left after removal.

What business problems are you solving with the product? What benefits have you realized?

Viewing db. issues/health is a breeze now. As a lifetime IT Ops person we tend to learn that app slowness is always the network first, then firewall, then IIS/web server, and possibly the app but never the database. DPA rules out the guessing with a few clicks. Prove its the DB or not the DB instantly. Historical trending is spot on. ROI is outstanding as we have been empowered to better allocate IT funds where needed. DBA team has embraced the tool and made our deployment a huge success. In the end DPA has been a significant win for our IT teams as well as business partners. And its cheap (when compared to other similar products). Also great integration to the Solar Winds platform if you are already there. DPA has been the easiest monitoring tool deployment in my 20 plus year career.

Solarwinds Database Performance Analyzer review by Administrator in Banking
Administrator in Banking
Validated Reviewer
Review Source

"DPA is a pretty great tool"

What do you like best?

The best thing I've used it for was looking for root blockers and monitoring deadlocks but just from the features that I looked at while in the trial period it can do so much more. It was easy to use and the setup didn't take much time. I know that a lot of time can be put in on it but that is something else I liked about DPA. If you are willing to spend the time and develop it, it could be a one stop shop

What do you dislike?

There wasn't much that I didn't like, there were times went the program seemed slow however that could have been due to the limitations on the database I was trying it on

Recommendations to others considering the product

It's a great tool for analyzing your database with. I would highly recommend it.

What business problems are you solving with the product? What benefits have you realized?

We were having issues with deadlocks happening during the middle of the day and DPA helped to quickly identify where they were coming from and who was causing it. (It was someone running 52 different reports in Orion for hardware monitors at the same time.) The benefits to me seem to be endless plus if given the opportunity within my current company I would like to see about getting it implemented

Solarwinds Database Performance Analyzer review by Administrator in Airlines/Aviation
Administrator in Airlines/Aviation
Validated Reviewer
Review Source

"Interesting way to monitor your databases using Wait-Time Analytics."

What do you like best?

The wait-time analytics is great. The software easily points our where issues are with poorly written queries. Integration with the rest of the SolarWinds suite is also very helpful as we can place performance statistics from multiple modules onto the same graph. Adding storage metrics from the Storage Arrays with OS metrics, and DPA counters make mapping out potential issues easy.

What do you dislike?

Cost. The price per database is too high. We would like if SolarWinds offered an enterprise license. Also the trial period is too short at 14 days, it doesn't give enough time to fully vet the product. Aligning the trial with their other products at 30 days would be better.

What business problems are you solving with the product? What benefits have you realized?

We use DPA to monitor our Enterprise Monitoring Database. This software easily shows which queries are generating the most amount of wait-time. We monitor the database that is doing the monitoring for the enterprise. When we perform upgrades we can tell right away if there are performance issues.

Solarwinds Database Performance Analyzer review by Administrator in Mechanical or Industrial Engineering
Administrator in Mechanical or Industrial Engineering
Validated Reviewer
Review Source

"An Excellent Diagnostic Tool for Systems and DBA Collaborative Efforts"

What do you like best?

The wait-centric focus of DPA allows monitoring professionals to speak in meaningful terms to DBAs and other DB professionals, quickly leading to common ground and productive output. In addition, the deep integration of the product with Solarwinds' NPM platform allows for correlated views, reports, and data gathering from the front end to the app to DB in a seamless fashion.

What do you dislike?

Not much - the standalone DPA console is a trifle limited for granular reporting and alerting. Much of this limitation goes away when integrated with NPM, however.

Recommendations to others considering the product

If you're a Solarwinds shop - or even if you're not - this product is worth your time. If eliminating the 'invisible' problems of Oracle/SQL/etc. is important to your business, DPA will help you get there.

What business problems are you solving with the product? What benefits have you realized?

Our primary goal was to identify bottleneck causes in weekly, month-end, and year-end processes. Being able to isolate the specific queries causing bottlenecks - and communicating those things effectively to our apps/DB teams - has significantly improved our execution level and reduced firefighting dramatically. The establishment of baselines for these processes also helps us be more efficient in differentiating between normal and abnormal ops.

Solarwinds Database Performance Analyzer review by Ralf S.
Ralf S.
Validated Reviewer
Verified Current User
Review Source

"DPA the discussion killer"

What do you like best?

The view of the whole stack from the Database to the disk. This helps a lot to find bottlenecks. Also the Wait- and Blocking-Views are very helpful in finding problems.

What do you dislike?

The report engine of the DPA should be like the Orion report engine. The AD user and group administration could be better.

What business problems are you solving with the product? What benefits have you realized?

We searching for slow running SQL-Queries and try to find solutions for that. We also use DPA if we face suddenly performance problems.

Solarwinds Database Performance Analyzer review by Chris J.
Chris J.
Validated Reviewer
Review Source

"SolarWinds DPA - View From Limited Use"

What do you like best?

Very in depth product and makes it a lot easier to find problems and root cause. Love the Tuning advisor, comes in very handy when you're not a DBA admin, and enjoy the query analysis.

Not being from a DBA background there is a learning curve to this, but if you take the input from DPA it will point you in the right direction more quickly to resolve the issue or even prevent the problem all together.

What do you dislike?

Cost due to the licensing model, depending on your setup.

What business problems are you solving with the product? What benefits have you realized?

We're still getting our heads around the product, but there was instantly some questions came up around tuning the databases that we hadn't realized before.

Solarwinds Database Performance Analyzer review by Administrator in Financial Services
Administrator in Financial Services
Validated Reviewer
Verified Current User
Review Source

"Production Database Administrator"

What do you like best?

performance dashboard that gives a health summary of all the monitored database instances. Alerts can be customized and be used to alert for critical events that are logged in the SQL Server Error log. The ability to replay SQL Server database activity.

What do you dislike?

Difficult to read the SQL Agent job failure and identify the actual job that failed.

Recommendations to others considering the product

DPA has it all. One tool that can monitor and alert all your SQL Server estate. You can also use it replay events that occur on your servers while you are sleep, it gives you all the events on your servers at at any point in time.

What business problems are you solving with the product? What benefits have you realized?

Being more proactive to SQL Server performance issues.

Solarwinds Database Performance Analyzer review by Administrator in Hospital & Health Care
Administrator in Hospital & Health Care
Validated Reviewer
Review Source

"We use DPA to troubleshoot on a daily basis."

What do you like best?

The addition of the waits and deadlocks has allowed us to work with our vendors in fixing and streamlining various queries. This in turn has led to faster turn around and the end user able to work more efficiently.

What do you dislike?

Until the latest release there has not been a facility for SQL Availability Groups. However we have just updated to the latest version and are evaluating this functionality.

Recommendations to others considering the product

Solarwinds allows free trials of their software. Just give it a try and make an evaluation.

What business problems are you solving with the product? What benefits have you realized?

We have a few large databases and a lot of customization. We have been able to fix queries that were holding up other processes with the wait time analysis. Also we have extensively used the blockers/deadlocks information to further enhance and improve performance. We have been able to show senior leaders through the reporting the improvements that have been made, and increased end user satisfaction.

Solarwinds Database Performance Analyzer review by Consultant in Information Technology and Services
Consultant in Information Technology and Services
Validated Reviewer
Review Source

"DPA changed our life!"

What do you like best?

At many client sites, we were stuck, in a perpetual war between the DB, Network and Server teams, playing "Push the Blame" game since past so many years. After installation of DPA, we started knowing exactly, where our database performance was lagging, where the Applications were hogging the resources, where the VMs felt less provisioned. DPA was the best decision we ever took.

What do you dislike?

We are fairly new on DPA, so we don't yet have explored much yet to find out any faults. However, it would be ever better if they expand the Vendors supported on DPA, a few of our SAP devices are not monitored in DPA.

What business problems are you solving with the product? What benefits have you realized?

As specified above, it helped us solve the eternal war between our IT teams, helps us give the seniors solid proof when we ask for better provisioning of the resources. The reports obtained through DPA are an added bonus.

Solarwinds Database Performance Analyzer review by Administrator in Insurance
Administrator in Insurance
Validated Reviewer
Review Source

"DataBase Performance Analyzer"

What do you like best?

We really like the integration with Database performance analyzer and Perfstack Analysis. Being able to bring the data side by side with some of the other solarwinds functions is what we have been missing.

What do you dislike?

I wish we could just do a complete integration with the Orion portal. Right now it feels like separate products which they kind of are under the SolarWinds name. If it was completely integrated into the SolarWind website and we didn't have to login to two it would help with the flow for our user base.

Recommendations to others considering the product

Its expensive but a great addition to your monitor toolset!!

What business problems are you solving with the product? What benefits have you realized?

It really provides our Database team with a central location for visibility into their application. As well as its very easy for non DBA's. We can provide access to our DevOps team and they can help correlate events with the Databases we have in dpa.

Solarwinds Database Performance Analyzer review by James S.
James S.
Validated Reviewer
Review Source

"Excellent product to give you real information about your database"

What do you like best?

The level of granularity that can be reached with the information captured by this tool. I'm also a huge fan of the explanations that are given with each of the individual items that are displayed.

What do you dislike?

Sometimes it can feel clunky in the relation that the node has to the database. I feel like looking at the node should flow more easily into DPA as opposed to being so separated.

What business problems are you solving with the product? What benefits have you realized?

As a none DBA, I have been empowered to research and determine issues or recommendations to make to our database admins that carry significant weight and understanding of the tool and how it informs us of the database.

Solarwinds Database Performance Analyzer review by Jamison C. J.
Jamison C. J.
Validated Reviewer
Verified Current User
Review Source

"SolarWinds DPA is a must have"

What do you like best?

Granular Details

The ability to mark points in time to track changes so you can see performance from that point in time.

The in app help and explanations.

Integrates into the Orion platform.

What do you dislike?

AD authentication is not as easy to integrate as other SolarWinds products.

Recommendations to others considering the product

Well worth the investment, show this to your DBA's and I guarantee they will want it.

What business problems are you solving with the product? What benefits have you realized?

Helps to resolve problems faster by showing historical information.

Solarwinds Database Performance Analyzer review by User
User
Validated Reviewer
Review Source

"Excellent Product"

What do you like best?

It gives you an overall insight to all databases with alerts and a real understanding what's happening. If you are constantly battling clueless issues or lack of alerts and information then this is a real game changer.

What do you dislike?

Load capacity is sometimes slow even though hardware requirements are met. (not a huge issues though)

Recommendations to others considering the product

It removes a lot of stress from day to day work. Administratively its excellent to be able to find issues or errors before it causes something more serious. Additionally there is no need to be constantly checking things as the alerting and reporting helps show trends to prevent future problems.

What business problems are you solving with the product? What benefits have you realized?

A lot of time is saved every day and even maintenance time has been reduced. Alert options and customisation really helps narrow down what problems you want to me notified of etc. Down time is often minimised or even completely eradicated.

Solarwinds Database Performance Analyzer review by Allistair G.
Allistair G.
Validated Reviewer
Review Source

"Its a fast and efficient tool that reduces troubleshooting time"

What do you like best?

It keeps everything in a single pane of glass. Allow intergration with other solarwinds tools like Network Performance Monitor that we use in our organizations. It quickly shows you a possible root cause analysis where you can further troubleshoot and issue and shows trends on potential issues.

What do you dislike?

Doesnt really allow me to analyse between a database and a web application that uses that database on a single pane of glass. I would have to move between windows to do an analysis.

Recommendations to others considering the product

Its a fast efficient and easy tool that can allow you to troubleshoot database performance and statistics.

What business problems are you solving with the product? What benefits have you realized?

It monitor core databases which affects customer experience.

Solarwinds Database Performance Analyzer review by Julie B.
Julie B.
Validated Reviewer
Review Source

"Another tool in a great suite of tools!"

What do you like best?

I appreciate how SolarWinds integrates all of their tools under one easy-to-use interface.

What do you dislike?

I've only used the tool in trial mode as we're evaluating whether it is a fit for us. So far, it's a no brainer. No major hurdles to this point.

What business problems are you solving with the product? What benefits have you realized?

Mostly we are hoping to use it for digging into problems that we can't easily identify root cause of. As we are small staffed, we don't have a fulltime DBA on site. This tool helps us system admins dig deeper into issues without having quite the in-depth knowledge of SQL as it points us in the right direction.

Solarwinds Database Performance Analyzer review by Executive Sponsor in Information Technology and Services
Executive Sponsor in Information Technology and Services
Validated Reviewer
Verified Current User
Review Source

"Great for those who aren't DBAs "

What do you like best?

Great data output, easy to understand charts that can be emailed. Our DBAs have really liked moving to the new product and we'd like to roll it out further. We host our own web applications. Being able to chart Database performance along application statistics is perfect.

What do you dislike?

Separate server required to our standard Orion install. It would be nice to see the next steps of integration between DPA and the Orion Suite. We need to keep the number of VMs to a minimum.

Recommendations to others considering the product

Get a trial and give it a try.

What business problems are you solving with the product? What benefits have you realized?

Linking application performance to database performance when troubleshooting.

Solarwinds Database Performance Analyzer review by Byron A.
Byron A.
Validated Reviewer
Review Source

"DPA Helps Us Provide Managed Database Services"

What do you like best?

How easy it is to deploy and manage DPA. I also think that SolarWinds provides both fantastic support and has a great community behind their products with Thwack. I also love that it integrates with the Orion suite of products which we also use.

What do you dislike?

It can be a complicated tool to use if you are not a DBA.

Recommendations to others considering the product

Definitely take advantage of the trial to compare this product against others.

What business problems are you solving with the product? What benefits have you realized?

We are a service provider and DPA has helped us provide a better managed database service. We have also received very good client feedback regarding the product.

Solarwinds Database Performance Analyzer review by Internal Consultant in Financial Services
Internal Consultant in Financial Services
Validated Reviewer
Review Source

"Using Solarwinds Database Performance Analyzer we find the root cause of performance issues. "

What do you like best?

It is very easy to see the queries running on the database and how long each takes. With this, we can determine if we need to make the query more efficient or what other action is best such as reindexing.

What do you dislike?

I have been sitting here racking my brain trying to think of a feature I would like to be added or a database it should support but I cannot think of anything I dislike about it.

Recommendations to others considering the product

Do what we did. Download the trial version and see the tool for yourself.

What business problems are you solving with the product? What benefits have you realized?

We have identified issues in indexing and queries in not only our in-house systems but in applications supplied by third parties. When on the phone with vendors they asked how we were able to find the issue and we told them about Solarwinds DPA.

Solarwinds Database Performance Analyzer review by Jeremy M.
Jeremy M.
Validated Reviewer
Verified Current User
Review Source

"DPA for everyone"

What do you like best?

the detail of monitoring and interoperability with Solarwinds Orion platform of products.

What do you dislike?

Currently it does not support SAP HANA which is a big need for us.

Recommendations to others considering the product

Get the demo, try it you will never leave it.

What business problems are you solving with the product? What benefits have you realized?

MS SQL was the main reason for monitoring, and this gives me complete end to end insight in to the servers

Solarwinds Database Performance Analyzer review by Sima G.
Sima G.
Validated Reviewer
Verified Current User
Review Source

"Network Tools Engineer"

What do you like best?

DPA is intuitive. Fresh interface and very easy to. I like that DPA gives me more root causes of database performance issues .

What do you dislike?

Yet, I don't have something to dislike .

Recommendations to others considering the product

DPA is very good if you want a centralized solution.

What business problems are you solving with the product? What benefits have you realized?

I can manage all my databases from one place.

Solarwinds Database Performance Analyzer review by Ukz M.
Ukz M.
Validated Reviewer
Review Source

"The product is very good for Database administrators as it helps to be proactive and monitors DBs."

What do you like best?

The way the product works. It gives the customer a proactive approach to the state and health of their databases.

What do you dislike?

Nothing at the moment. It's a nice product and very competitive.

Recommendations to others considering the product

It is a very highly appreciated product. I recommend you go for it to help you properly analyze your databases. Especially for the proactive monitoring.

What business problems are you solving with the product? What benefits have you realized?

To help the customer analyze the current database server performance on the network. Proactive monitoring is very key and this would help everyone in charge be more attentive to likely happenings on the databases.

Solarwinds Database Performance Analyzer review by Administrator in Utilities
Administrator in Utilities
Validated Reviewer
Review Source

"DPA solarwinds module"

What do you like best?

The depth of the platform exceeds the current platform we are now using. With blocking, wait times, etc. detailed, the tool proves useful.I also like the prospect of integration with other solarwinds modules. PerfStack integration with DPA in demos appeared to be extremely useful.

What do you dislike?

The price point is still proving to be too prohibitive for inclusion in our monitoring stack. I believe it was available at one time on AWS at a per GB use price point that showed promise for usage.

Recommendations to others considering the product

If you can get past the price point, all my DBA were stating that they would have loved to have this product over what we are currently using.

What business problems are you solving with the product? What benefits have you realized?

With a trial demo, we proved that we could find troubling issues in our SQL stack.

Solarwinds Database Performance Analyzer review by Nikki B.
Nikki B.
Validated Reviewer
Review Source

"Database Performance Analyzer"

What do you like best?

Like many educational institutions, our budget does not allow for the purchase of Oracle's Diagnostics and Tuning packages. SolarWinds' DPA gives customers the insight into their environment that Oracle *should* provide, but doesn't.

What do you dislike?

I haven't really found anything I much dislike yet!

What business problems are you solving with the product? What benefits have you realized?

In the past, we didn't really have the ability to be proactive and solve problems before they became huge. With DPA, we can keep an eye on performance and typically know when something is wrong and can fix it before our users even notice anything!

Solarwinds Database Performance Analyzer review by Executive Sponsor
Executive Sponsor
Validated Reviewer
Review Source

"This is going to completely change the way my developers attack problem code."

What do you like best?

I love that you get detail on specific queries. I can now have my developers focus on very detailed issues, and can pinpoint where issues are occurring.

What do you dislike?

There's nothing that I dislike so far.

Recommendations to others considering the product

This is especially helpful for small teams. I have one DBA and 5 developers supporting 15k employees, so finding the time to do DB work is never easy. This narrows down the scope of finding problems tremendously.

What business problems are you solving with the product? What benefits have you realized?

We're going to start attacking poorly performing queries. This tool has shown us incredible amounts of data that we didn't have the bandwidth to dig for in the past. My team can focus on a few things and start knocking additional things off the list as we fix them.

Solarwinds Database Performance Analyzer review by Jacob B.
Jacob B.
Validated Reviewer
Review Source

"Works very well for the situation we have"

What do you like best?

The fact we can monitor multiple things at the same time to make sure that we are running the best we can. I like the integration with other Solarwinds offerings

What do you dislike?

Nothing that Im aware of for now. We seem to like it in the review stage. Seems like it will do exactly what we need it to.

Recommendations to others considering the product

Make sure you know what you are doing :) Love the interface seems to work well

What business problems are you solving with the product? What benefits have you realized?

Making sure everything is running smoothly for managing information

Solarwinds Database Performance Analyzer review by Damon G.
Damon G.
Validated Reviewer
Review Source

"Great Product, Very Worth IT"

What do you like best?

Ease of use. The UI is very easy to use and get to know.

What do you dislike?

There is a learning curve with using the product, but not steep. The community and staff provide great help.

Recommendations to others considering the product

It is definitely a great product. At the very least it needs to be on your list to trial if you are in the market for such a product! Solarwinds products in general are all great!

What business problems are you solving with the product? What benefits have you realized?

Cutting down the customer wait times. Ensuring everything is running optimally.

Solarwinds Database Performance Analyzer review by Rucha V.
Rucha V.
Validated Reviewer
Review Source

"Best product for Database and SQL query performance monitoring"

What do you like best?

It does Database and SQL query tuning.

Can identify database problems in short time.

Has wide range of database engines to choose from and that too in single installation.

What do you dislike?

Nothing much as much.

It solves my issue of supporting wide range of database engines on one platorm.

Recommendations to others considering the product

Best in class for Database and SQL query performance monitoring and tuning.

What business problems are you solving with the product? What benefits have you realized?

Monitors Oracle, SQL Server, MySQL.

Has quick response-time analysis to problems.

Can integrated with server and application monitoring(SAM).

Solarwinds Database Performance Analyzer review by Vijay G.
Vijay G.
Validated Reviewer
Verified Current User
Review Source

"A must have product for database group"

What do you like best?

I love the start screen which immediately shows instances/queries need to be looked at.

What do you dislike?

I could use a feature where it would allow me to email detail deadlock report.

What business problems are you solving with the product? What benefits have you realized?

DPA is helping us to ensure databases run smoothly.

Solarwinds Database Performance Analyzer review by Administrator
Administrator
Validated Reviewer
Review Source

"Great Product to keep a close eye on yout Databases"

What do you like best?

Ease of use and display of performance charts. This was easy to setup and get running from day 1.

Lots of useful information on the solarwinds Thwack users form.

Graphical chats and UI work well and make it easy for us to spot an issue.

What do you dislike?

The price is a little high but the it does have a lot of features for the price !

Recommendations to others considering the product

Ensure it meets all requirements> it is easy to setup and integrate into an existing solar winds environment.

What business problems are you solving with the product? What benefits have you realized?

We looked at this tool to prevent outages caused by poor database performance. We can proactively monitor everything to ensure the sites are up, functional and running efficiently.

Solarwinds Database Performance Analyzer review by User in Marketing and Advertising
User in Marketing and Advertising
Validated Reviewer
Verified Current User
Review Source

"A must have tool for DBAs"

What do you like best?

Clear overview of multiple servers

Real time monitoring

History views

Pinpoint to trouble queries

Cool reports

What do you dislike?

Custom time interval for Trend view is too restricted, would like to see more days of data beyond 30 day window

Recommendations to others considering the product

Alerts are not easy to set and we often get false alarms.

What business problems are you solving with the product? What benefits have you realized?

It provides DBA with clear view of server and database performance and makes it possible to dynamically manage infrastructure resources and pinpoint performance issues quickly.

Solarwinds Database Performance Analyzer review by Vaughan B.
Vaughan B.
Validated Reviewer
Review Source

"Great product, in depth detail, perfect for your database administrators."

What do you like best?

The in depth detail it provides, and the quick ability to find problems.

What do you dislike?

The required separate server, should be apart of primary solarwinds server.

Recommendations to others considering the product

Try an evaluation, and witness the impact in time it can save to troubleshoot problems for a variety of things.

What business problems are you solving with the product? What benefits have you realized?

Application performance issues, top slow queries. The overrall ability to monitor, ddiagnoise and resolve problems within databases, helps teach uninformed database administrators and provides great insight for experienced database admins.

Solarwinds Database Performance Analyzer review by Administrator in Insurance
Administrator in Insurance
Validated Reviewer
Verified Current User
Review Source

"Incredibly helps with troubleshooting deadlocks and performance bottlenecks"

What do you like best?

Performance charts & reports to monitor server activity

Performance trending via main page

Bottlenecks

Blocking and locking

Deadlocks analysis and charts, deadlock details and trending

Error Log alerting

Failover Alerting

What do you dislike?

The query executions plans are not perfectly aligned and not named the same as the source queries under the performance tab which makes it a bit hard to track.

Recommendations to others considering the product

Download trial and try it

What business problems are you solving with the product? What benefits have you realized?

Quicker performance overview of multiple environments.

Automatic performance

Solarwinds Database Performance Analyzer review by Administrator in Accounting
Administrator in Accounting
Validated Reviewer
Review Source

"MSG DB Review"

What do you like best?

The analytics from one-pane of glass. While that is often overstated in our industry, the DB menu and customization interfaces have truly been invaluable.

What do you dislike?

Initial Setup is always the hardest part with any deployment. But with the kind folks at SW Support we managed to get it up and running without issue.

Recommendations to others considering the product

SW Product lines always have something of value and always remember you don't know what you don't know. Having the right tool in place helps prevent any "gotcha" moments.

What business problems are you solving with the product? What benefits have you realized?

SQL resource consumption and process improvement.

We have identified the resource hogs and allocated more to them to lessen the impact on applications and end-user experience.

Solarwinds Database Performance Analyzer review by Consultant in Consumer Electronics
Consultant in Consumer Electronics
Validated Reviewer
Review Source

"Database Performance Analyzer for SQL DB"

What do you like best?

This DPA is real RCA tool which we are evaluating in our SQL DB and some third party DB.The good thing is that we can monitor our heterogeneous system with DPA.It help us to find the app tuning with front of app or DB side and help us fixing the problem. Previously we have to struggle to analyses the performance data and tuning the things, but now it is just simple click to resolve all hurdles in bw.

What do you dislike?

Cost and integration with other performance tool which only can integrate with Solarwinds.

What business problems are you solving with the product? What benefits have you realized?

IIS and DB tuning ,RCA to rectify the problem is very much important.

Solarwinds Database Performance Analyzer review by Administrator in Internet
Administrator in Internet
Validated Reviewer
Verified Current User
Review Source

"SolarWinds DPA"

What do you like best?

Gives direct insight to how your database(s) are performing. Showing you top queries, wait times, etc. This product gives amazing detail on how your database is responding to the data reads and writes.

What do you dislike?

It doesn't give direct suggestions on how to fix problems detected

What business problems are you solving with the product? What benefits have you realized?

Trying to get our SolarWinds instance to run faster and smoother. It has helped me improve the DB performance.

Solarwinds Database Performance Analyzer review by Administrator in Publishing
Administrator in Publishing
Validated Reviewer
Review Source

"DPA to the rescue"

What do you like best?

Capability to overlay DB performance statistics with hardware metrics KPIs

What do you dislike?

It does not yet provide full integration with Orion platform, so switching between main Orion console and DPA console is required for deep troubleshooting

Recommendations to others considering the product

This may not provide as deep insight into Oracle DB as more native tools, but it provides the capability of overlaying DB stats with hardware and OS stats. Same goes for SQL monitoring and our DBAs are very pleased with this tool

What business problems are you solving with the product? What benefits have you realized?

Slow response times for paying customers due to database wait times. Changed application designed to improve end user & customer experience

Solarwinds Database Performance Analyzer review by Lukas S.
Lukas S.
Validated Reviewer
Review Source

"Great Database Monitoring Tool"

What do you like best?

It is easy to use and it works with every type of Databases whe have in commitment.

What do you dislike?

There are no funktionion in the web GUI to have custom reports.

Recommendations to others considering the product

Useful and easy to use tool to administrat and monitor your databases

What business problems are you solving with the product? What benefits have you realized?

The daily work withe databases are much faster and so also the problems are much faster solved

Solarwinds Database Performance Analyzer review by Administrator
Administrator
Validated Reviewer
Review Source

"Best SQL and Azure Analyzer for the price"

What do you like best?

The fact it handled Azure as well as on-premise database analysis.

What do you dislike?

While it handles Azure currently, it is new and is missing some features.

Recommendations to others considering the product

This works great when used with other SolarWinds products. They integrate so well and make it easy to analyze the data for various angles. It is a strong product when used alone as well.

What business problems are you solving with the product? What benefits have you realized?

It has helped show when records are locked and determine the root cause of problems we have encountered. It has show us when it is necessary to adjust the resources in Azure to help lower cost.

Solarwinds Database Performance Analyzer review by Ryhlen S.
Ryhlen S.
Validated Reviewer
Review Source

"Easy to read and Monitor Database"

What do you like best?

The detail that DPA provides, very easy to setup, easy to integrate with our current monitoring system. Easy to use.

What do you dislike?

The Web Page that the DPA uses is visually bland. Should be more colorful.

Recommendations to others considering the product

Very good decision when monitoring our Databases

What business problems are you solving with the product? What benefits have you realized?

able to identify processes that are using memory and have discovered issues with disk speeds

Solarwinds Database Performance Analyzer review by Administrator in Information Technology and Services
Administrator in Information Technology and Services
Validated Reviewer
Review Source

"Would love to use it"

What do you like best?

it's a handy tool that will provide additional details on your performance problems which seem to usually turn out to be poorly written sql queries.

What do you dislike?

we are not fond of the cost which makes it hard for us to justify use.

Recommendations to others considering the product

if your organization uses just a few dbs, this may not be for you. on the other hand if you are heavy in db usage and are looking for a tool, this is a great one.

What business problems are you solving with the product? What benefits have you realized?

we would realize a number of potential problems however the cost is too much for us.

Solarwinds Database Performance Analyzer review by Bert S.
Bert S.
Validated Reviewer
Review Source

"best tool for easily diagnosing oracle database performance issues"

What do you like best?

the tool is simple to use and offers a viable freeware whose only basic limitation is a four window for history - this allows for one to test drive the software and see exactly what it can do. it also is agentless so nothing to install on database servers that might impact performance. zero learning curve - the tool works the way DBA's think about finding the needle in the performance haystack

What do you dislike?

at first the price seems a bit high, but after using the freeware to see the value it becomes a little easier to justify - but still wish they offered a portable consultant type license for reasonable cost

Recommendations to others considering the product

start by trying the freeware. you will get addicted and then having complete history will not only make sense - but be easy to justify the expense

What business problems are you solving with the product? What benefits have you realized?

database performance issues once database changes, application or code placed into production

Solarwinds Database Performance Analyzer review by Robert R.
Robert R.
Validated Reviewer
Review Source

"Improving Database Performance"

What do you like best?

Identify database problems in real-time

Integration with the Orion Platform

Easy to install

What do you dislike?

Did not provide exact procedures or suggestions on how to improve on database performance.

Recommendations to others considering the product

It's ability to integrate with the Orion Platform is its selling point.

What business problems are you solving with the product? What benefits have you realized?

Solarwinds Orion platform has been running slow and does not provide real-time information sometimes.

Solarwinds Database Performance Analyzer review by Joe L.
Joe L.
Validated Reviewer
Review Source

"Managing Database Health with DPA"

What do you like best?

The monitoring features and the ability to set up notifications.

What do you dislike?

The cost seems a bit high and the licensing in general is a bit confusing

Recommendations to others considering the product

If you are trying to improve the performance of your databases, use DPA.

What business problems are you solving with the product? What benefits have you realized?

The ability for monitoring and notification when we need to add resources to database servers.

Solarwinds Database Performance Analyzer review by Administrator in Law Enforcement
Administrator in Law Enforcement
Validated Reviewer
Verified Current User
Review Source

"Database performance ananlyzer has saved me multiple times"

What do you like best?

I like the fact at any time, when someone approaches me about an issue I can bring up solid evidence of an issue.

What do you dislike?

The only thing I dislike is somehow it's hard to find what I need quickly.

What business problems are you solving with the product? What benefits have you realized?

We are solving slowness issues in databases by identifying bottlenecks and other issues.

Solarwinds Database Performance Analyzer review by User in Hospital & Health Care
User in Hospital & Health Care
Validated Reviewer
Review Source

"Looks good, but has a side effect?"

What do you like best?

Installation and configuration was fast and simple, no problems on that stage

Adding SQL instances was fast and simple.

The dashboard is informative and well-designed.

What do you dislike?

After I added an instance that was part of SQL Server Always-On cluster, somesing happened to the Listener, and I lost connection to all DBs in the AAG. Can it be a coincidence, maybe the cluster was already

Recommendations to others considering the product

Good and helpful product, but.... be careful with using it with SQL Server Always-on cluster

What business problems are you solving with the product? What benefits have you realized?

It helps finding bottlenecks in SQL performance and fix them.

Solarwinds Database Performance Analyzer review by Administrator in Utilities
Administrator in Utilities
Validated Reviewer
Review Source

"DPA is an amazing resource"

What do you like best?

The quickness of resolution of our issues as well as the transparency it gives across teams. We can dig into what the root issue is easily with DPA. The monitoring feature is second to none and allows us to find the issues when comparing to a baseline.

What do you dislike?

There is really nothing that I dislike so far about the DPA.

Recommendations to others considering the product

Implement this analyzer as it will greatly benefit your organization.

What business problems are you solving with the product? What benefits have you realized?

We use Solarwinds DPA to track performance issues in our environment. It has been a great tool so far.

Solarwinds Database Performance Analyzer review by Administrator in Real Estate
Administrator in Real Estate
Validated Reviewer
Verified Current User
Review Source

"Solarwinds Database Performace Analyzer"

What do you like best?

I like the interface. The Status Summary provides the information that is most important at a glance.

What do you dislike?

When drilling down into an issue you can sometimes get lost in the navigation.

What business problems are you solving with the product? What benefits have you realized?

We have been able to identify issues with long running queries and implement fixes.

Solarwinds Database Performance Analyzer review by Administrator
Administrator
Validated Reviewer
Review Source

"DPA really made my job of sorting through database to know the speed and health easy."

What do you like best?

I like how DPA leverage all my S3 databases

What do you dislike?

Sincerely there's no good software without a disadvantage. But I have not seen anything you should improove on except the pricing. That might be because of the country I'm in.

Recommendations to others considering the product

it is the best solution for anyone with dificulty in managing database expecially those just learning.

What business problems are you solving with the product? What benefits have you realized?

It's very tasky to statcally connect to every database everytime I want to manage, DPA helps in managing all of my databases simultaneously.

Solarwinds Database Performance Analyzer review by Administrator in Transportation/Trucking/Railroad
Administrator in Transportation/Trucking/Railroad
Validated Reviewer
Review Source

"Life Saver"

What do you like best?

I liked being able to monitor SIDs on database instances.

What do you dislike?

A small dislike but it would be the cost of the product. Oracle instances come with a premium cost vs SQL instances.

What business problems are you solving with the product? What benefits have you realized?

This will be beneficial for those with minimal database experiences. In tough situations, it is good for a non DB person to be able to dive into this product and see potential issues like long running queries that need to be killed that cause service degradation.

Solarwinds Database Performance Analyzer review by Administrator in Computer & Network Security
Administrator in Computer & Network Security
Validated Reviewer
Review Source

"Great insight to real time stats"

What do you like best?

The most beneficial aspect for me was the storage stats. Having a real time chart to read reads, writes and latency allows us to have a more proactive approach to response times.

What do you dislike?

There isn't too much to dislike however adding more administrative control functions would expand on the product's functionality.

Recommendations to others considering the product

The product does everything as advertised and more.

What business problems are you solving with the product? What benefits have you realized?

Visually seeing trends in peak performance utilization has allowed for more scalable maintenance plans.

Solarwinds Database Performance Analyzer review by Consultant
Consultant
Validated Reviewer
Verified Current User
Review Source

"quick, easy and complete inside view"

What do you like best?

easy installation, easy DB connection, direct detailed view out of box

What do you dislike?

short test license range not within 30day Solarwinds standard

What business problems are you solving with the product? What benefits have you realized?

slow DB performance with business impact and no visibility where the bottle neck was

Solarwinds Database Performance Analyzer review by User in Utilities
User in Utilities
Validated Reviewer
Review Source

"Been using Solarwinds DPA module for 3 years"

What do you like best?

I love the detailed information you are able to pull regarding the databases, their servers and the whole virtual environment. When syncing with NPM, it helps complete that "single pane of glass" view of your environment.

What do you dislike?

Currently, there is nothing I would say I "dislike" about this product.

What business problems are you solving with the product? What benefits have you realized?

We are able to see where our problem/latency spots are with our collection of Solarwinds products we have applied to the environment.

Solarwinds Database Performance Analyzer review by Administrator in Restaurants
Administrator in Restaurants
Validated Reviewer
Review Source

"DPA Review"

What do you like best?

DPA allows us to be proactive about monitoring databases in our environment and is easy to setup/configure. Everything integrates into a single console.

What do you dislike?

It can give so much information it can be difficult to drill down and identify what is most important.

What business problems are you solving with the product? What benefits have you realized?

Catching issues before our customers complain. We are able to get insight into how the DBs are performing and can make decisions based on this information.

Solarwinds Database Performance Analyzer review by User
User
Validated Reviewer
Review Source

"Solarwinds DPA Review"

What do you like best?

You are able to select different types of data to be analyzed and you are able to see the results easily.

What do you dislike?

It seemed a bit slow to update the data, but that may be because it was a demo product.

Recommendations to others considering the product

Try the demo to see if it will suit your needs

What business problems are you solving with the product? What benefits have you realized?

We are trying to analyze our VMs that store our database and the efficiency of them.

Solarwinds Database Performance Analyzer review by Rik I.
Rik I.
Validated Reviewer
Review Source

"Great Product to see under the hood of your applications"

What do you like best?

Being able to get alerts on DB slowness.

What do you dislike?

Nothing that I've found so far! Be good if it was cheaper.

What business problems are you solving with the product? What benefits have you realized?

Quickly finding root cause of user slow response issues.

Solarwinds Database Performance Analyzer review by Administrator in Defense & Space
Administrator in Defense & Space
Validated Reviewer
Review Source

"Easy to use Database performance analysis tool"

What do you like best?

Everything is broken down with time based stacked graphs

What do you dislike?

The expense if you have a lot of databases

Recommendations to others considering the product

The price gets bigger if you have many databases but it's one of the best tools to quickly isolate where the problems are in your database with wait times. Easy to find the query where all the time is being wasted.

What business problems are you solving with the product? What benefits have you realized?

Quickly find out where the problem is.

Solarwinds Database Performance Analyzer review by Tyler R.
Tyler R.
Validated Reviewer
Review Source

"Very useful utility"

What do you like best?

The integration with the Orion platform.

What do you dislike?

I wish that is would also work with Microsoft Exchange.

Recommendations to others considering the product

Make sure this is the product you want.

What business problems are you solving with the product? What benefits have you realized?

Mostly performance related issues

Solarwinds Database Performance Analyzer review by Administrator in Law Enforcement
Administrator in Law Enforcement
Validated Reviewer
Review Source

"DPA"

What do you like best?

The email reports are great for seeing what is going on. The console is easy to use and provides real time data. Has helped figure out lots of problem areas.

What do you dislike?

Really don't have any dislikes. Some times the renewing the license requires contact with Solarwinds.

What business problems are you solving with the product? What benefits have you realized?

SQL queries has been the most problems we see. Also found that we needed to add resources to our servers.

Solarwinds Database Performance Analyzer review by Michael G.
Michael G.
Validated Reviewer
Review Source

"DPA "

What do you like best?

I can monitor the performance of all my databases

What do you dislike?

I really don't have a dislike for this product

What business problems are you solving with the product? What benefits have you realized?

Slow database responsiveness. Found what was causing it.

Solarwinds Database Performance Analyzer review by Ken O.
Ken O.
Validated Reviewer
Review Source

"Excellent analytical tool for system performance"

What do you like best?

The graphs and different options to customize.

What do you dislike?

There is nothing I can think of hand that I dislike.

What business problems are you solving with the product? What benefits have you realized?

Able to find bottlenecks in DBs

Solarwinds Database Performance Analyzer review by Internal Consultant
Internal Consultant
Validated Reviewer
Review Source

"I have worked with DBA and they love the DPA"

What do you like best?

Showing the colorful graph and root caus

What do you dislike?

I didn't work with it but the DBA did not complain but liking it

Recommendations to others considering the product

I tried recommending it but the DBA already was using it in smaller lincences

What business problems are you solving with the product? What benefits have you realized?

Normally, they blame everything on DB and by using DPA, will find the rood cause

Solarwinds Database Performance Analyzer review by Administrator in Hospital & Health Care
Administrator in Hospital & Health Care
Validated Reviewer
Review Source

"Tested in a POC environment"

What do you like best?

Adding DB to the stack to find performance issues.

What do you dislike?

Systems team did not find the interface user friendly. They had no experience with SolarWinds.

Recommendations to others considering the product

Good product that requires more diligent training of staff.

What business problems are you solving with the product? What benefits have you realized?

We were able to diagnose and issue with our SolarWinds NPM database and reconfigured the hardware setup.

Solarwinds Database Performance Analyzer review by Consultant in Information Technology and Services
Consultant in Information Technology and Services
Validated Reviewer
Review Source

"User friendly and simple"

What do you like best?

easy information presentation. Very user friendly UI. Doesn't lag. Liked the drag and drop feature. Easy to go through the charts.

What do you dislike?

the best tool used so far. This was my first time using a DPA so hard to say if it was missing something.

What business problems are you solving with the product? What benefits have you realized?

To monitor metrics of entire environment.

Solarwinds Database Performance Analyzer review by Administrator in Insurance
Administrator in Insurance
Validated Reviewer
Review Source

"Hard to correlate single user impact"

What do you like best?

Resource correlation with database queries. time slice

What do you dislike?

VM license portion of DPA is ridiculous . We own VMAN and we need to license connectors to that same data twice so DPA can analyze its own version of the same data?

What business problems are you solving with the product? What benefits have you realized?

ETL query efficency