Original Research on SolarWinds Database Performance Analyzer

Case Study: Large Enterprise Industrial Manufacturing Company

“[DPA] allows us to search through performance history of our systems to find query’s/applications that need to be tuned or improved.”

“[DPA is] great tool to help identify the processes that are taking too long and are impacting our performance.”

Challenges

Purchased DPA to:
- Improve end-user response time (application performance)
- Improve database performance
- Accelerate root-cause identification for performance problems
- Monitor overall health of our databases and be alerted when issues arise

Use Case

Platforms:
- Windows
- Linux
- Solaris/AIX/UNIX
- VMWare
Database engines:
- SQL Server
- Oracle

Results

Realized the following benefits as a result of using DPA:
- Increased database performance and end user experience
- Achieved faster problem resolution and more proactive management of databases
- Has the ability to find problems that were hard or impossible to find before

Benefits of SolarWinds Database Performance Analyzer

Using DPA helps organizations solve performance issues

Saving money on hardware investments as a result of performance optimization	18%
Increased database performance and end user experience	76%
Better visibility into our environment and improved collaboration (less finger pointing for troubleshooting)	70%
Faster problem resolution and more proactive management of databases	78%
More time to focus on more important or strategic parts of my job	38%
Able to find problems that were hard or impossible to find before	56%
Other	2%

SolarWinds Database Performance Analyzer Customer Testimonial

DPA is intuitive. It’s not a cluttered interface with dozens of tabs and complicated navigation. The information is presented cleanly and it is very easy to drill into graphs to quickly get more details about what’s going on in our databases.

— Sean Scott, Database Administrator (DBA), Bodybuilding.com

Case Study: United Student Aid Funds Inc.

“I had used DPA in a previous job and when I joined my current employer they were looking for ways to improve performance. There just isn’t a better tool the DPA”

“DPA is more intuitive and easier to provide role based access and even share information by emailing direct from the analysis of the queries.”

Challenges

Purchased DPA to:
- Improve end-user response time (application performance)
- Improve database performance
- Accelerate root-cause identification for performance problems
- Improve collaboration between DBAs, developers, operations and other IT teams

Use Case

Platforms:
- Windows
Database engines:
- SQL Server

Results

Realized the following benefits as a result of using DPA:
- Saved money on hardware investments as a result of performance optimization
- 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
- Gained time to focus on more important or strategic parts of my job

3.5/5 Stars

What is the biggest benefit of using SolarWinds DPA?

SolarWinds DPA allows me to quickly identify queries that have been written poorly, have suddenly generated bad plans and are executing sub-optimally, or are heavy in nature. I can therefore focus on improving through TSQL improvement or index maintenance.

How would you describe SolarWinds DPA to a colleague?

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%

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

Case Study: Large Enterprise Industrial Manufacturing Company

Challenges

Use Case

Results

About SolarWinds Database Performance Analyzer

Benefits of SolarWinds Database Performance Analyzer

Case Study: United Student Aid Funds Inc.

Challenges

Use Case

Results

About SolarWinds Database Performance Analyzer

What is the biggest benefit of using SolarWinds DPA?

How would you describe SolarWinds DPA to a colleague?

Database Performance Challenges

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.