Solarwinds Database Performance Analyzer for SQL Server
The Fastest Way to Identify and Resolve SQL Server Performance Problems

Features:

Focus On Response Time
Database Performance Analyzer is different because it focuses on instance response time, finding the root causes of delays inside of SQL Server‰. Database Performance Analyzer tracks every query in every active session, and captures the SQL Server wait types that impose delays on the query.

Supports SQL Server Deployment Options
Monitor and optimize SQL Server from a single view, whether that’s on-premise, virtualized, or in the Cloud.

Historical Trend Analysis
Database Performance Analyzer captures multiple dimensions of response time and server statistics in the data warehouse repository. While many tools focus only on the current situation, Database Performance Analyzer is unique because it analyzes repetitive clues that explain why SQL Server response is slow. The graphical display makes it easy for anyone – DBAs, managers, and developers – to see the trends and patterns that tell the complete performance story.

Agentless Architecture
Database Performance Analyzer installs no software or agent on the monitored server, placing less than 1% load on the monitored database instance. Database Performance Analyzer server software is installed on a separate system, which can be any Windows, UNIX, or Linux server, typically a test system under control of the DBA. Database Performance Analyzer data warehouse repository is configured on any Oracle or SQL Server instance, either on the same or different server as Database Performance Analyzer software. In multi-vendor environments, Oracle, DB2, SAP ASE, and MySQL databases can also be monitored from the same Database Performance Analyzer server.

Database Performance Analyzer Agentless Architecture

Identify performance issues that impact application response time the most
Response Time Analysis helps you make changes that end-users will notice when their apps run faster.

Eliminate Finger-Pointing Across the IT Team
SolarWinds' SQL Server performance monitoring software builds collaboration among DBAs, Developers, Q/A and Server Administrators.

Improve Performance Without Additional Server Resources
Investing in hardware to resolve application performance problems is a big gamble unless you are certain the performance bottleneck is, in fact, caused by server resources. DPA helps pinpoint the root cause of problems and allows you to validate your hardware purchases.

Scale from one to thousands of Monitored Instances
DPA Central provides a consolidation of performance metrics from thousands of monitored instances.

Eliminate database bottlenecks on AWS and Azure
Get unparalleled visibility to performance on the Amazon Cloud. Database Performance Analyzer's Multi-Dimensional Performance Analysis identifies historical performance trends and gives you actionable advice on the inner workings of database instances deployed on an Amazon AWS RDS and EC2 virtual machine.

Monitors ALL your databases - on-premise, in the Cloud, or a service
Don't be forced into different tools to monitor you databases - get DPA instead. Its the only tool that provides full coverage of your databases, no matter how it is deployed - physical, virtual, cloud or DBaaS, we've got you covered.

SQL Server Performance Tuning
Often, database performance issues result from poorly written queries, bad design, or index strategies. Unlike hardware upgrades, SQL query tuning can offer immediate and powerful results. However, effective SQL tuning requires not only knowing the top SQL statements, but also the top wait types, SQL plans, the effect of missing indexes, blocked queries, and resource contention. DPA isolates the root cause, provides the much needed SQL tuning advice and is a must for performance tuning in SQL.

System Requirements:

Screenshots:

Documentation:

Download the Solarwinds Database Performance Analyzer for SQL Server Datasheet (.PDF)