Understand your SQL Server performance picture at a glance and across key dimensions: Queries, Waits, Applications, Client Machines, Users, and more.
Know your SQL Server blocking hierarchy, as well as the overall impact to your database performance caused by blocking; in addition, see detailed deadlock resolution reports.
Identify high-impact, inefficient T-SQL—aggregated by tables—to find indexing opportunities. The SQL performance analyzer in DPA can provide an “X marks the spot” performance analysis of actual workload.
Use an intelligent algorithm that gets better over time to understand your SQL Server wait behavior so you can see and alert when patterns deviate from expected.
T-SQL and plan analysis, as well as correlating query wait time with statistics, resource metrics, blocking data, and more. Tuning advisors can point to MSSQL server problems that need immediate focus.
24/7 monitoring of SQL servers can help answer why performance is or was bad, plus get a handle on where performance is headed or how your system is trending.
Use the management REST API to programmatically manage your environment including the ability to register, license, stop/start monitors, annotate, and more.
Web interface and read-only rights help make DPA database management software safe to use across teams. SQL developers can see the impact of new code in production, and operations can see the impact of any changes.
Get helpful insights into the status and health of your Always On Availability Group environment in MSSQL, as well as get alerted when things change.
SQL Server activity alerting and reporting that is designed to be comprehensive and not overload your inbox. Baselining can highlight outliers. DPA’s SQL performance analyzer tool includes pre-built alerts and reports, or you can create your own.
"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."
Database Performance Analyzer for SQL Server/MySQL/Oracle SE is licensed per monitored SQL Server, MySQL, or Oracle SE instance. Enter the number of instances that you require below.