TrustRadius
Solarwinds DPA: Quickly Identify Production Performance Problems
https://www.trustradius.com/database-performance-monitoringSolarWinds Database Performance AnalyzerUnspecified8.3146101
No photo available
Updated February 01, 2019

Solarwinds DPA: Quickly Identify Production Performance Problems

Score 10 out of 101
Vetted Review
Verified User
Review Source

Overall Satisfaction with SolarWinds Database Performance Analyzer

Solarwinds Database Performance Analyzer (DPA) is a powerful database performance analyzer tool that is vital to our business. It is utilized by the organization to monitor hundreds of SQL Server instances that support customer businesses. The graphs and dashboards provided by the tool grant us the quick visibility into potential performance culprits that could be impacting our customers.
  • Solarwinds DPA provides easy to ready graphs to identify database performance problems.
  • Solarwinds DPA displays vital Availability Group health information. This is used to quickly identify the status of SQL Server Availability Groups.
  • Solarwinds DPA provides a drill down capability to see current and recent activity that may be impacting performance. This easy to use interfaces is vital to quickly identifying performance problems for improved up time.
  • Solarwinds DPA does a great job of analyzing commonly executed queries on SQL instances. The one thing it does not do well is gathering metrics and bubbling up ad hoc queries that may only run once and a while, or perhaps queries that supply a variety of parameters. This typically causes DPA to interpret commonly run queries with varying parameters as different queries.
  • This tool drastically cuts down the time it takes to identify production impacting performance issues. This result improves the system up time to our customers, which in turn enables them to better serve their customers.
This tool is used on a daily basis to identify queries with the highest wait times. This information is then taken back to our development teams to improve upon the said stored procedures. With this tool, we are easily able to identify whether the wait time of the stored procedure improved, by comparing the before and after performance metrics within DPA.
Yes, we have been able to use this information to identify tuning opportunities. This includes potential indexes that may improve the performance of queries that hit that table. The tuning recommendations are reviewed and tested prior to production implementation.
It is well suited for monitoring performance of mission critical business database systems. The tools website provides many easy to navigate pages with a plethora of details about SQL wait times, system resource utilization, such as CPU, memory, and disk, as well as supplying potential missing index information.

Using SolarWinds Database Performance Analyzer

20 - The DPA product covers more than a few hundred databases across 20+ application platforms. Monitoring this many different SQL Server instance is no easy task. Across the organization at least 20 users access this monitoring platform on a weekly basis. The business functions of these users are Support, DBAs, Developers, and Management.
2 - The DBA's support the Solarwinds platform. There is very little effort and knowledge required to support the Solarwinds Database performance Analyzer platform. Installing the product, registering database instances, and upgrading the product are simple straightforward tasks.
  • Monitoring database wait times across the previous month to find regressed queries or schema changes that may effect performance.
  • Reviewing index recommendations.
  • Getting a quick glance look at resource utilization for things such as CPU utilization, page life expectancy, read and write latency, and blocking sessions.
The Solarwinds DPA product is an ideal tool for any DBA or support member. It gives easy to read charts and drill downs to identify performance problems or schema change benefits.

Using SolarWinds Database Performance Analyzer

I have used the product for 3 years now and realize that at first it took me a month or two to identify all of the information that DPA has to offer. Since then I use the tool on a daily basis for troubleshooting, schema change performance validation, index tuning and recommendations, and reviewing the overall health and wait times of the SQL instances.
ProsCons
Like to use
Relatively simple
Easy to use
Technical support not required
Well integrated
Consistent
Quick to learn
Convenient
Feel confident using
None
  • Navigating to the trends and resources tabs for a particular instance is easy to use and provides a great deal of information.
  • Solarwinds allows for support to quickly identify performance impacting queries/procs.
  • The GUI does take some time to learn as there is so much information and detail provided. But the learning curve is short and the tutorial videos provided do help speed up the learning time.