SolarWinds DPA - covers all/most of your SQL monitoring needs
Updated April 04, 2022

SolarWinds DPA - covers all/most of your SQL monitoring needs

Anonymous | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Overall Satisfaction with SolarWinds Database Performance Analyzer

We use it to monitor the company's production SQL server. It's being used by the IT infrastructure and the Development departments. Mostly, it gives us an insight into what is going on behind the scenes and if there are any problems with the SQL server, if it's being slow, which queries are causing problems, etc.
  • Shows SQL utilization over time.
  • Identifies slow queries.
  • Identifies bottlenecks.
  • Navigation can be tricky and it's not very intuitive.
  • It helped us to identify and improve some poorly written queries.
  • It enabled us to identify potential problems.
  • It enables us to troubleshoot and find out the root cause of a problem much quicker.
We actually never tried other products. After some research, SolarWinds Database Performance Analyzer seemed the best match for our needs, and we were happy after the trial period, so we kept it.
It's particularly useful if you want to see what's going on on your SQL server behind the scenes and which queries are causing bottlenecks. If the SQL server is running slow, you can quickly identify the root cause. Also, you can look at various utilizations over time.

Using SolarWinds Database Performance Analyzer

  • Insight for troubleshooting
  • Performance overview
  • Queries advise
  • Ability to see the resources utilization by many diffrent cathegories (e.g. Waits, Programs, Machines, User, DBs, machines, Files, Drives, etc.)
  • We are looking into using Database Performance Analyzer in Azure environment

Configuring SolarWinds Database Performance Analyzer