Original Research on SolarWinds Database Performance Analyzer

SolarWinds DPA Testimonial: Computer Software Company (Small)

SolarWinds DPA’s focus on wait types is unique. The UI is clean, less cluttered and confusing than other tools I’ve evaluated. There is less of a footprint on the monitored servers.

— Database Administrator (DBA), Small Business Computer Software Company

Case Study: Educational Institution

“We needed to get metrics that both VMWare admins and DBAs could view in order to resolve performance problems and get to the root cause of issues instead of speculation and finger-pointing.”

“Solarwinds DPA was the only tool of its kind available that monitored both the hypervisor and the guest OS and allowed visibility into what other factors are impacting the virtual database servers. Before this, we had no method of proving that issues were query related as opposed to virtual hardware related.”

“DBAs and VM admins can now collaborate to resolve issues in a smoother manner. Reduced the amount of finger pointing and instead let us focus on resolving the issues.”

Challenges

Purchased DPA to:
- Improve visibility into the database and the systems that support it
- Accelerate root-cause identification for performance problems
- Improve collaboration between DBAs, developers, operations and other IT teams
- Monitor overall health of their databases and be alerted when issues arise

Use Case

Platforms:
- Windows
- VMWare
Database engines:
- SQL Server
- MySQL / MariaDB / Percona

Results

Realized the following benefits as a result of using DPA:
- Improved visibility into their environment and improved collaboration (less finger pointing for troubleshooting)
- Has the ability to find problems that were hard or impossible to find before

Database Performance Challenges

Primary challenges in optimizing database performance:

Improve end-user response time (application performance)	71%
Improve database performance	85%
Improve visibility into the database and the systems that support it	65%
Accelerate root-cause identification for performance problems	79%
Improve collaboration between DBAs, developers, operations and other IT teams	35%
Monitor overall health of our databases and be alerted when issues arise	66%
Help me or other database professionals spend less time looking for problems inside the database	62%
Other	2%

SolarWinds Database Performance Analyzer Customer Testimonial

I’m not a DBA but even I can use DPA and understand where the problems are.

— System analyst, Medium Enterprise Financial Services Company

Case Study: State & Local Government

“The biggest benefit has been that we have been able to pinpoint extremely poor performance on a couple of vendor applications to be due to poor application programming practices.”

“SolarWinds DPA is a great product and I would recommend purchasing it if your budget allows it.”

Challenges

Purchased DPA to:
- Improve end-user response time (application performance)
- Improve database performance
- Improve visibility into the database and the systems that support it
- Accelerate root-cause identification for performance problems
- Improve collaboration between DBAs, developers, operations and other IT teams
- Monitor overall health of our databases and be alerted when issues arise
- Help database professionals spend less time looking for problems inside the database

Use Case

Platforms:
- Windows
- Linux
- Solaris/AIX/UNIX
- Mainframe
- VMWare
- Public Cloud
Database engines:
- SQL Server
- Oracle
- DB2
- Sybase
- MySQL / MariaDB / Percona

Results

Realized the following benefits as a result of using DPA:
- Increased database performance and end user experience
- Improved visibility into their environment and improved collaboration (less finger pointing for troubleshooting)
- Achieved faster problem resolution and more proactive management of databases
- Has the ability to find problems that were hard or impossible to find before

Challenges in Moving Databases to Cloud

What are the primary challenges in moving databases to the cloud?

Not enough time to experiment, test and migrate	27%
Lack of expertise. Need more time to understand how the cloud works and how to solve for our needs	20%
Security concerns, including storing mission critical data outside our own datacenters	74%
Unknown or hard to quantify TCO or ROI	24%
Unsure about performance of databases in the cloud and the consistency of performance	41%
Stability and consistency. Ability of cloud vendors to meet our SLAs	27%
Other	12%

TechValidate Research on SolarWinds Database Performance Analyzer

These pages present data that TechValidate has sourced via direct research with verified customers and users of SolarWinds Database Performance Analyzer. TechValidate stands behind the authenticity of all published data. Learn more »

About TechValidate Research

Selected Research Highlights

SolarWinds DPA Testimonial: Computer Software Company (Small)

Case Study: Educational Institution

Challenges

Use Case

Results

About SolarWinds Database Performance Analyzer

Database Performance Challenges

Case Study: State & Local Government

Challenges

Use Case

Results

About SolarWinds Database Performance Analyzer

Challenges in Moving Databases to Cloud

More to Explore

About SolarWinds Database Performance Analyzer

Quickly identify and resolve complex database performance problems—right from code-level issues and query wait time analytics to resource capacity bottlenecks across physical, virtual and cloud environments.