SolarWinds Database Performance Analyzer (DPA) for SQL Server uses response time analysis to get to SQL Server performance problems in just four clicks—on-premises or in the cloud. DPA helps identify the core performance issues impacting SQL Server running in Microsoft Azure.
To deploy DPA in the cloud, simply provision an Azure virtual machine and install the software. DPA utlizes a SQL Server repository that you can configure on any virtual machine. It is recommended that you install DPA on a VM separate from the SQL Server instances monitored. DPA for SQL Server’s agentless architecure only requires standard Windows or SQL Server credentials to connect to an instance on a physical or cloud-based server. DPA for SQL Server enables DBAs, developers, and system administrators to monitor, analyze, and tune the performance of the SQL Server instance or SQL Database in the Azure cloud. Its query response time, wait types, trends, alerts, and reports will all be available.
Traditional server health metrics can be misleading due to the layers of abstraction with cloud-based servers. DPA for SQL Server’s response time analysis provides an improved alternative by focusing on response time, wait types, and SQL query analysis for applications dependent on SQL Server.
DPA’s intuitive charts and non-intrusive architecture gives the entire IT team a unified view into application performance in Azure—without sacrificing performance or security.
Database Performance Analyzer
Query and Table tuning advisors.
Monitors active sessions every second.
Multi-dimensional analysis isolates root cause of complex issues.