Overview
SolarWinds Database Performance Analyzer (DPA) is a cross-platform database monitoring and management solution designed for optimizing SQL query performance. It supports various DBMS platforms like SQL Server, Oracle, MySQL, and MariaDB, whether running on-premises or in the cloud (Azure, AWS, Google Cloud). DPA uses an agentless architecture, ensuring minimal resource overhead (less than 1% CPU utilization). The tool provides detailed charts and reports, highlighting key wait-time metrics for single and multiple SQL statements. Its machine learning capabilities enable anomaly detection and forecasting of storage needs. DPA facilitates root cause analysis by correlating database response times with guest OS and infrastructure metrics in virtualized environments. It provides expert tuning advisors to improve DBMS performance and offers centralized performance views across multiple DBMSs in a single platform.