G2 Crowd Acquires Siftery to Create a New Way to Buy and Manage Software Spend 🚀

Solarwinds Database Performance Analyzer

4.5
(105)

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.

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
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

"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 Administrator
Administrator
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.

Recommendations to others considering the product

This product is great for a team that wants to add it to their Solarwinds Portfolio, especially if Database monitoring is a need. There are other Database monitoring tools, but this will allow a small IT team to have one pane of glass for troubleshooting.

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.

Kate from G2 Crowd

Learning about Solarwinds Database Performance Analyzer?

I can help.
* We monitor all Solarwinds Database Performance Analyzer reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. Validated reviews require the user to submit a screenshot of the product containing their user ID, in order to verify a user is an actual user of the product.