Database Performance Analyzer for Oracle
-
Features Overview
-
Wait-time analytics
-
Performance intelligence
-
Collaboration across teams
-
Performance history
-
Scalable, agentless architecture
-
Query analysis and expert advice
-
Multi-vendor platform with cloud support
-
Locking and blocking analysis
-
Alerts and reports
-
Application-centric view of database performance
-
Features Overview
Discover why DBAs and developers love SolarWinds® Database Performance Analyzer.Response-time analyticsCorrelates activity, wait events, SQL statements, and other dimensions to help pinpoint the exact cause of database slowdownsEvery session, every secondKnow exactly what's happening in your database, including wait times, plans, queries, resources, changes, and historical analysisOptimize all your production databasesAgentless architecture is safe to use in dev, test, and production, virtualized or in the cloud, Amazon AWS, EC2 , RDS, and AzureAligns developers, DBAs, and operationsDPA’s easy, web-based interface allows teams to collaborate and be on the same page about how new code impacts performanceBroad Oracle performance tuning supportHelp ensure top performance for Oracle SE, EE, RAC, Exadata, E-Business and PDBs
-
Wait-time analytics
A true 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 Oracle database performance.
Triangulate performance issues using best practice wait-based analytics. Perform root cause analysis easily with Oracle performance tuning and all the data you need at your fingertips.
-
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
Down to the second Oracle historical history for the granularity you need to troubleshoot issues efficiently and effectively.
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.
-
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 SE & EE, SQL Server, DB2, SAP ASE on-premises, on VMware, or in the cloud including Azure and AWS RDS.
-
Locking and blocking analysis
Nail down the root blockers and get locking analysis, including cumulative impact on response times.
DPA displays wait caused by root blockers and total victim impact to keep tuning focused on critical queries. Identify why objects are waiting and see the last activity 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 Server & Application Monitor. See everything from web transactions to LUN performance.
-
Supports broad Oracle technologies
Help ensure top performance for Oracle E-Business, Exadata, and RAC.
DPA helps overcome specific challenges of running on Oracle Exadata.
-
Support for Oracle PDB databases
Enhanced support for Oracle 12c.
Register and monitor pluggable database (PDB) performance.
“SolarWinds DPA provides insight without excessive monitoring overhead. SolarWinds DPA makes you look like a genius.”
“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.”
“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.”
-
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.
-
Database Performance Analyzer monitors all your database engines with a single installation.
Because we're agentless, we can monitor Oracle databases, 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).
Take the Next Step
We're Geekbuilt™.
Developed by network and systems engineers who know what it takes to manage today's dynamic IT environments, SolarWinds has a deep connection to the IT community.
The result? IT management products that are effective, accessible, and easy to use.
