Solarwinds Database Performance Analyzer

Solarwinds Database Performance Analyzer

(105)
4.5 out of 5 stars

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
  • User Industry
Ratings
Company Size
User Role
User Industry
Showing 105 Solarwinds Database Performance Analyzer reviews
LinkedIn Connections
Solarwinds Database Performance Analyzer review by <span>anup s.</span>
anup s.
Validated Reviewer
Verified Current User
Organic
Reviewed On

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.

Sign in to G2 Crowd to see what your connections have to say about Solarwinds Database Performance Analyzer
Headshots
Solarwinds Database Performance Analyzer review by <span>Parag K.</span>
Parag K.
Validated Reviewer
Verified Current User
Invitation from the software vendor
Reviewed On

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.

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

Thanks for letting us know!
Solarwinds Database Performance Analyzer review by <span>Greg A.</span>
Greg A.
Validated Reviewer
Verified Current User
Invitation from the software vendor
Reviewed On

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 <span>Richard C.</span>
Richard C.
Validated Reviewer
Verified Current User
Invitation from the software vendor
Reviewed On

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 <span>Franklin W.</span>
Franklin W.
Validated Reviewer
Verified Current User
Invitation from the software vendor
Reviewed On

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 <span>M R.</span>
M R.
Validated Reviewer
Invitation from the software vendor
Reviewed On

Keep on top of your databases.

What do you like best?

DPA is a great tool for any databases 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.

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

Learn more about Solarwinds Database Performance Analyzer

Solarwinds Database Performance Analyzer Videos

Kate avatar
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.