Call a Specialist Today! 800-886-5369

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


Solarwinds Database Performance Analyzer

Solarwinds Products
Solarwinds Database Performance Analyzer for SQL Server
SolarWinds Database Performance Analyzer per SQL Server, MySQL, or Oracle SE instance (1 to 4 licenses)
License with 1st-year Maintenance
#29080
Our Price: $1,995.00
SolarWinds Database Performance Analyzer per SQL Server, MySQL, or Oracle SE instance (5 to 9 licenses)
License with 1st-year Maintenance
#29081
Our Price: $1,945.00
SolarWinds Database Performance Analyzer per SQL Server, MySQL, or Oracle SE instance (10 to 19 licenses)
License with 1st-year Maintenance
#29082
Our Price: $1,895.00

Click here to jump to more pricing!

Overview:

SolarWinds Database Performance Analyzer (formerly Confio Ignite) for SQL Server is a comprehensive database performance monitoring and analysis solution for DBAs, IT managers, and application developers. Database Performance Analyzer eliminates performance bottlenecks, improves application service, and reduces overall cost of SQL Server operations.

Database Performance Analyzer for SQL Server at a Glance

  • Identify SQL blocks and corresponding locks.
  • View response time delays in real time, or history up to weeks and months.
  • Automatically schedule graphical performance reports for delivery to any email address.
  • Set proactive alerts to be notified of problems via email or SNMP trap.

Key Advantages

  • Four Clicks to Resolution. Alarm trail leads DBAs directly to the root cause of the problem in 3 - 4 clicks.
  • No Agents. No Tracing. Less than 1% load on monitored servers makes Database Performance Analyzer the lightest high performance monitoring tool available.
  • Multi-Dimensional Performance Analysis. Simplifies root cause analysis by correlating SQL statements, context, system and storage health, wait types, and response time
  • Resource baselines, alerts, and reports. Proactively monitor system health, identifying trends before they become problems
  • Show the complete picture. DPA for SQL Server correlates essential statistics to give an understanding of query bottlenecks, server health, and how session statistics interact— providing a complete performance picture.

chart
Historical Trends and Resource Correlation

DPA’s historical repository highlights the trends and anomalies that are easy candidates for SQL tuning.

alert
Alerts, Reports, and Baselines

Comprehensive alerting and reporting without overloading your inbox. Baselines highlight outliers.

expert
Expert Advice

DBAs see SQL performance tuning advice for the instance. Advice for developers can focus on a specific SQL query.

engine
Drill down and time slice to the second

Dashboards are easily understood. Drilling down provides detailed analytics for top DBAs.

scale
View DPA analysis and metrics in the SolarWinds Orion interface

Get Database Performance in the context of specific applications inside SolarWinds SAM.

agentless
Agentless Architecture

DPA's proprietary, agentless architecture provides consistent 24/7 monitoring with less than 1% load.

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
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:


Hardware Minimum Requirements
Memory 4GB
Hard Drive 3GB / monitored instance
Software Minimum Requirements
Operating System Linux/Unix or Windows Server
Supported Instances Oracle 11g, 12c
SQL Server 2008, 2012, 2014
SAP ASE 15.0x, 15.6, 15.7, 16
DB2 9.x, 10.1, 10.5
VMware ESX/ESXi 5.1, 5.5
MySQL 5.6+
Java Virtual Machine 1.6 or 1.7
Database Repository Oracle 11g, 12c
SQL Server 2008, 2012, 2014
Web Browser IE - 8, 9, 10, and 11,
Firefox 3.6 and higher,
Chrome latest version

Screenshots:


Database Performance Analyzer historical trends

Database Performance Analyzer historical trends
Database Performance Analyzer uses historical data to identify opportunities for improvements

SQL Server SQL statement advice

SQL Server SQL statement advice
Get expert advice for improving SQL performance

Database Performance Analyzer current view

Database Performance Analyzer current view
Eliminates finger pointing. Builds collaboration among DBAs, developers, QA, and server administrators

Database Performance Analyzer central enterprise monitoring

Database Performance Analyzer central enterprise monitoring
Using the DPA Central interface, there is no limit on the number of instances you can monitor

Database Performance Analyzer agentless architecture

Database Performance Analyzer agentless architecture
No agents and no loads. Agentless, Web-based architecture and less than 1% load makes DPA unique

Database Performance Analyzer dashboard

Database Performance Analyzer dashboard
Intuitive dashboard and Web-based browser is easy to understanding without getting lost in statistics

VMware resource correlation

VMware resource correlation
See how VMware configuration, host server, and storage impacts SQL Server response time

Database Performance and Server Health in a single pane of glass

Database Performance and Server Health in a single pane of glass
From a single pane of glass, you can identify the database issues and easily collaborate with system, application, network and database professionals to resolve those.

See database performance data from the perspective of poorly performing applications

See database performance data from the perspective of poorly performing applications
DPA 9.2 allows integration with SAM. Customers can now get database information in context to nodes and applications

 

Solarwinds Products
Solarwinds Database Performance Analyzer for SQL Server
SolarWinds Database Performance Analyzer per SQL Server, MySQL, or Oracle SE instance (1 to 4 licenses)
License with 1st-year Maintenance
#29080
Our Price: $1,995.00
SolarWinds Database Performance Analyzer per SQL Server, MySQL, or Oracle SE instance (5 to 9 licenses)
License with 1st-year Maintenance
#29081
Our Price: $1,945.00
SolarWinds Database Performance Analyzer per SQL Server, MySQL, or Oracle SE instance (10 to 19 licenses)
License with 1st-year Maintenance
#29082
Our Price: $1,895.00
SolarWinds Database Performance Analyzer per SQL Server, MySQL, or Oracle SE instance (20 to 29 licenses)
License with 1st-year Maintenance
#29003
Our Price: $1,795.00

For more than 30 licenses, please Request a Quote

Solarwinds Database Performance Analyzer for Virtualized Environments for SQL Server
SolarWinds Database Performance Analyzer for Virtualized Environments for SQL Server, MySQL, or Oracle SE instance (1 to 4 licenses)
License with 1st-year Maintenance
#43000
Our Price: $2,845.00
SolarWinds Database Performance Analyzer for Virtualized Environments for SQL Server, MySQL, or Oracle SE instance (5 to 9 licenses)
License with 1st-year Maintenance
#43001
Our Price: $2,770.00
SolarWinds Database Performance Analyzer for Virtualized Environments for SQL Server, MySQL, or Oracle SE instance (10 to 19 licenses)
License with 1st-year Maintenance
#43002
Our Price: $2,695.00
SolarWinds Database Performance Analyzer for Virtualized Environments for SQL Server, MySQL, or Oracle SE instance (20 to 29 licenses)
License with 1st-year Maintenance
#43003
Our Price: $2,545.00

For more than 30 licenses, please Request a Quote