Database Performance Analyzer for DB2
Drill down into DB2 databases to pinpoint the root cause of poor performance.
Download Free Trial
Email Link To Trial
Fully functional for 14 days
Database performance doesn’t have to be a guessing game. Do you find yourself asking…
How can I optimize performance?
Quickly identify bottlenecks, pinpoint their root causes, and prioritize actions.
Discover response time analysis
Can I identify performance issues based on resource usage?
DPA can help determine true root cause of issues through wait-time analysis.
Get to the heart of performance issues
Where do I begin optimizing my database?
DPA identifies the most impactful queries and inefficient workloads.
Focus your tuning efforts
We’re here to help make database performance easier.
How can I get detailed information on various factors contributing to bottlenecks?
What are the primary drivers of my SQL server performance issues?
How can I get the query tuning advice I need?
How do I know my query tuning is working effectively?
Key Features
-
Wait-time analytics
A performance analysis tool that focuses on response time to identify bottlenecks and understand where the database spends time.
DPA’s unique Multi-Dimensional Performance Analysis correlates wait time with resources, events, and other dimensions to quickly pinpoint the largest contributors to slow performance.
-
Performance intelligence
Provides a single version of the truth across databases and the infrastructure that supports database performance.
See into database OS, virtualization resources and events, the physical host, storage systems, and the network to eliminate finger-pointing. Visibility across the stack stops guesswork.
-
Anomaly Detection
Use machine learning-powered anomaly detection to know when behavior is different than expected.
Use an intelligent algorithm that gets better over time to understand your DB2 wait behavior so you can see and alert when patterns deviate from expected.
-
Collaboration across teams
Developers, DBAs, and operations teams can finally get on the same page. DPA helps everyone understand performance.
DPA web interface and read-only rights make it safe to use across teams. Developers can see the impact of new code in production, and operations can see the impact of any changes.
-
Performance history
Years of history with one-second resolution at your fingertips.
Discover the cause of past issues, drill down to specific points in time, compare and analyze historic performance and metric baselines to find anomalies and problems.
-
Scalable, agentless architecture
Stay on top of real-world performance from dozens, hundreds, or thousands of instances across environments.
No agents to deploy or maintain. Monitor test, dev, and production environments across data centers and cloud with DPA Central Server.
-
Management API
Automate and scale the management of your database environment with our API.
Use the management REST API to programmatically manage your environment including the ability to register, license, stop/start monitors, annotate, and more.
-
Query analysis and expert advice
Tuning advisors provide clear and actionable advice.
DPA provides deep query and execution plan analysis. Tuning advisors point to problems that need immediate focus.
-
Locking and blocking analysis
Nail down the root blockers and get locking analysis including cumulative impact on response times.
DPA displays root blockers and total waits to keep tuning focused on critical queries. Identify why objects are waiting and see the last query of an idle blocker.
-
Alerts and reports
Proactive monitoring and automated alerts help warn you whenever performance degradation occurs.
Comprehensive alerting and reporting that won’t overload your inbox. Baselines highlight outliers. DPA comes with pre-built alerts and reports, or you can create your own.
-
Application-centric view of database performance
View DPA wait times, analysis, and metrics within SolarWinds Orion® Platform interface.
Get database performance in the context of specific applications within SolarWinds SAM. See everything from web transactions to LUN performance.
-
VMware vSphere performance monitoring
Correlate database to VM performance
Map performance issues to key virtual machine (VM) metrics and determine the impact of VM performance on the database.
Features Overview
Discover why DBAs and developers love SolarWinds® Database Performance Analyzer.
Response-time analytics
Correlates activity, wait times,
SQL statements
, and other dimensions to help you pinpoint the exact cause of database slowdowns.
Every session, every second
Know exactly what's happening in your database, including wait times, queries, resources, changes, and historical analysis.
Aligns developers, DBAs, and operations
DPA’s easy, web-based interface allows teams to collaborate and be on the same page about how new code impacts performance.
Accelerate application performance
For over a decade, database professionals have relied on DPA to solve even the toughest performance problems.
Features Overview
Discover why DBAs and developers love SolarWinds® Database Performance Analyzer.
Features Overview
Discover why DBAs and developers love SolarWinds® Database Performance Analyzer.
Response-time analytics
Correlates activity, wait times,
SQL statements
, and other dimensions to help you pinpoint the exact cause of database slowdowns.
Every session, every second
Know exactly what's happening in your database, including wait times, queries, resources, changes, and historical analysis.
Aligns developers, DBAs, and operations
DPA’s easy, web-based interface allows teams to collaborate and be on the same page about how new code impacts performance.
Accelerate application performance
For over a decade, database professionals have relied on DPA to solve even the toughest performance problems.
Features Overview
Discover why DBAs and developers love SolarWinds® Database Performance Analyzer.
Wait-time analytics
A performance analysis tool that focuses on response time to identify bottlenecks and understand where the database spends time.
DPA’s unique Multi-Dimensional Performance Analysis correlates wait time with resources, events, and other dimensions to quickly pinpoint the largest contributors to slow performance.
Performance intelligence
Provides a single version of the truth across databases and the infrastructure that supports database performance.
See into database OS, virtualization resources and events, the physical host, storage systems, and the network to eliminate finger-pointing. Visibility across the stack stops guesswork.
Anomaly Detection
Use machine learning-powered anomaly detection to know when behavior is different than expected.
Use an intelligent algorithm that gets better over time to understand your DB2 wait behavior so you can see and alert when patterns deviate from expected.
Collaboration across teams
Developers, DBAs, and operations teams can finally get on the same page. DPA helps everyone understand performance.
DPA web interface and read-only rights make it safe to use across teams. Developers can see the impact of new code in production, and operations can see the impact of any changes.
Performance history
Years of history with one-second resolution at your fingertips.
Discover the cause of past issues, drill down to specific points in time, compare and analyze historic performance and metric baselines to find anomalies and problems.
Scalable, agentless architecture
Stay on top of real-world performance from dozens, hundreds, or thousands of instances across environments.
No agents to deploy or maintain. Monitor test, dev, and production environments across data centers and cloud with DPA Central Server.
Management API
Automate and scale the management of your database environment with our API.
Use the management REST API to programmatically manage your environment including the ability to register, license, stop/start monitors, annotate, and more.
Query analysis and expert advice
Tuning advisors provide clear and actionable advice.
DPA provides deep query and execution plan analysis. Tuning advisors point to problems that need immediate focus.
Multi-vendor platform with cloud support
One platform to monitor and optimize all your databases.
Optimize MySQL, Oracle , SQL Server , DB2 , SAP ASE on-premises, and VMware. Reduce operational costs when deploying on Azure or AWS , and use MySQL repository.
Locking and blocking analysis
Nail down the root blockers and get locking analysis including cumulative impact on response times.
DPA displays root blockers and total waits to keep tuning focused on critical queries. Identify why objects are waiting and see the last query of an idle blocker.
Alerts and reports
Proactive monitoring and automated alerts help warn you whenever performance degradation occurs.
Comprehensive alerting and reporting that won’t overload your inbox. Baselines highlight outliers. DPA comes with pre-built alerts and reports, or you can create your own.
Application-centric view of database performance
View DPA wait times, analysis, and metrics within SolarWinds Orion® Platform interface.
Get database performance in the context of specific applications within SolarWinds SAM. See everything from web transactions to LUN performance.
VMware vSphere performance monitoring
Correlate database to VM performance
Map performance issues to key virtual machine (VM) metrics and determine the impact of VM performance on the database.
Next Feature
Your success starts with the right resources. We've got plenty.
Get to Know DPA
Dive into the Technical Details
Get Started with Your Free Trial
See How DPA Fits into Your IT Budget
View Upcoming Training and Events
Visit THWACK, our SolarWinds IT Community
Database Performance Analyzer for DB2 is an industry favorite. Hands down.
“SolarWinds DPA provides insight without excessive monitoring overhead. SolarWinds DPA makes you look like a genius.”
Kevin McCool
Database Administrator (DBA)
MBI Solutions
“The biggest benefit of using SolarWinds DPA is fast root cause analysis on application performance issues. SolarWinds DPA is an intuitive and easy-to-use tool that allows anyone to see inside an enterprise DB system while it is running.”
Carlos Jofre
IT Director
MCL Corporation Ltd.
“SolarWinds DPA changes the job from ‘figuring out what to fix’ to ‘fixing it.’ The fastest way to get from ‘I don’t know what’s wrong’ to fixing what’s wrong.”
Chris Miller
Data Services Manager
VinSolutions
Breaking rules. Nabbing accolades.
This is a slider with rotating awards. Use the previous and next buttons to navigate.
FAQ: Questions, meet answers.
-
The impact to your production instance is minimal.
Less than 1%. We are agentless and only monitor active sessions allowing us to keep our overhead on monitored instances extremely low.
-
Viewing our interface is as simple as launching a browser.
Download and install your free trial using our Getting Started Guide, which is located in the Success Center.
View Getting Started Guide -
Database Performance Analyzer monitors all your database engines with a single installation.
Because we're agentless, we can monitor Oracle, SQL Server, MySQL, DB2, and SAP ASE running on premise (physical or on VMware) or in the cloud (both virtual machine offerings and Database-as-a-Service).
SolarWinds is trusted by 300,000+ loyal customers worldwide
This is a slider with rotating awards. Use the previous and next buttons to navigate.
Take the Next Step
Download Free Trial
Email Link To Trial
Fully functional for 14 days
Let’s talk it over.
Contact our team. Anytime.