
Explore the DPA architecture by examining the two components—the DPA server and the repository—where metrics from SQL Server and Oracle are stored, displayed, and used to generate reports and alerts.
Learn the hardware and database requirements for the DPA server and repository, including SQL Server, Oracle, MySQL, Aurora, VMware impact, and Windows or Linux deployment guidance.
Discover the DPA console and learn to monitor databases, access the demo site to test options, identify instances with high waste time, and review performance metrics.
Explore how to create and customize performance reports in SolarWinds DPA: select databases, choose report types, set granularity, add custom weights, and schedule or email grouped reports.
SolarWinds Database Performance Analyzer (DPA) pinpoints performance issues while providing expert advice with tuning advisors. Anomaly detection powered by machine learning allows DBAs to proactively optimize databases before small issues become big problems.
FEATURES
• Find your worst-performing applications, SQL, and tables in seconds
• Hybrid monitoring for virtualized, physical, and cloud-based database instances
• Uncover root causes from CPU and I/O down to the SQL statement
• Visualize all wait times from resources to blocking, to host and VM resources, and more
• Anomaly detection powered by machine learning gets better over time
• Detailed blocking and deadlock analysis expose your SQL blocking hierarchy
• Integrated VMware ESXi visualization with the optional VM Option
• Ability to search for and filter individual SQL query statements
KEY BENEFITS
• Agentless and easy to install with quick time-to-value and low overhead of 1% or less
• Runs on either Windows or Linux servers, in Azure , or as an AWS subscription
• Goes beyond problem analysis with expert advice with table tuning and query advisors
• Get the complete picture of all database instance resources spanning CPU to storage I/O
• Granularity to drill down to the SQL Text level
• Create custom reports and automated email alerts
• Integrate into your DevOps automation routine with RESTful API
• Correlate resource metrics of hardware constraint impacts on end users
• Scalability to support large, dynamic environments
• End-to-end visibility with SolarWinds Orion Platform, PerfStack, and AppStack integration