SolarWinds® Database Performance Analyzer (Formerly Confio Ignite) for SQL Server®
SQL Server Performance Monitoring

Starts at $1995
  • Identifies SQL Server performance issues most impacting end-user response time
  • Pinpoint root causes by performing multi-dimensional analysis
  • Analyze and optimize server and application performance based on queries, sessions, servers and storage systems
  • Analyze baselines, alerts, and storage I/O details to help correlate resources with response time
  • Agentless architecture—install and see results in minutes
Still doing research? Get Online Quote

Guided Tour

This three minute video illustrates how SolarWinds’ SQL Server performance monitoring software finds and resolves performance problems in just four clicks.

Download Free Trial Fully Functional For 14 Days

What Users Say about Our SQL Server Performance Monitoring Software

My promotions and pay raises over the last few years are, in part, directly attributable to Database Performance Analyzer for SQL Server. I owe you a few!

Manager, Database Performance, ExactTarget

SQL Server Performance Monitor Software

SolarWinds’ SQL Server performance tuning software is the one database performance monitoring, analysis, and tuning solution designed specifically to prevent & solve the toughest performance problems. It's not a general purpose SQL Server monitor. Database Performance Analyzer for SQL Server goes beyond conventional server health tools. It’s the one tool that all DBAs, Developers, and DBA Managers can collectively use to save time and measurably improve SQL Server performance.

TOP 5 Reasons to Use SolarWinds’ SQL Server Performance Monitor Software

  • Isolate Root Causes by Performing Multi-Dimensional Analysis

    Resolve SQL Server Performance Problems in Four Clicks

    Get to the root cause of SQL Server® performance issues without getting lost in statistics.

    Most database tools present a maze of screens and stats, but no answers. Database Performance Analyzer for SQL Server clearly identifies the exact root cause of SQL Server application performance issues. It gives you the ability to analyze and optimize performance based on queries, sessions, servers and storage systems.

    Database Performance Analyzer for SQL Server eliminates the guesswork in identifying the root cause of SQL Server application performance issues. It uses easy-to-understand bar charts with alarms that lead directly to the detailed data and the evidence surrounding the issues.

    Database Performance Analyzer for SQL Server is the only performance solution that shows three key components of the problem: the query affected, the SQL Server wait type, and the response time impact of each bottleneck. Finding the exact cause of the problem from initial alarm to detailed analysis in only four clicks makes Database Performance Analyzer for SQL Server the fastest way to improve SQL Server performance.

    Learn More about Resolving SQL Performance Issues »
  • Improve End-User Application Performance

    Improve End User Application Performance

    Response Time Analysis helps you make changes that end-users will notice when their apps run faster

    Database Performance Analyzer for SQL Server applies. Response Time analysis, measuring the time for query response, rather than focusing on conventional server health metrics. Database Performance Analyzer for SQL Server measures time associated with each tiny operation - or wait type - and uses it to expose delays in end user service. This is the most important indicator, since it shows applications waiting on SQL Server to respond.

    Database Performance Analyzer for SQL Server doesn’t stop there. It gathers real time session data, server resource levels, and query information of your SQL Server database performance. It also analyzes historical trends of response time over multiple dimensions - such as wait type, program, and execution plan. Then Database Performance Analyzer for SQL Server correlates the data to lead the DBA through the most important problems and solutions.

    Software as a Service (SaaS) companies face a critical decision when it comes to maximizing application performance while scaling rapidly. See how to prepare for when you company goes supernova.

    Learn More about Application Performance »
  • SQL Server VMware

    VM Option for SQL Server

    Get unique visibility into how the VMware infrastructure impacts SQL Server database performance.

    The VM Option, a chargeable feature of Database Performance Analyzer for SQL Server, provides DBAs with visibility into how virtual machine and host performance impacts SQL Server. There are performance issues that can occur when SQL Server runs on VMware. The dynamic nature of the virtual infrastructure can quickly impact the SQL Server. For example, resource contention can occur when additional VMs are placed on the same host where the SQL Server VM is located or the SQL Server’s performance could be impacted if that VM is moved to another physical host with limited resources.

    The problem many DBAs face is that they are not responsible for the virtual infrastructure, and this responsibility is often siloed to the virtual admin. In addition, the virtual infrastructure has no visibility to the applications or databases that run on the VMs which makes it very difficult to map database and virtual machine performance.

    The VM Option for Database Performance Analyzer for SQL Server solves for this problem by providing a contextual view of virtual machine and host performance with SQL Server performance.

  • Eliminate Finger-Pointing Across the IT Team

    Stops Finger Pointing Across the IT Team

    SolarWinds’ SQL Server performance monitoring software builds collaboration among DBAs, Developers, and Q/A & Server Administrators.

    Database Performance Analyzer for SQL Server allows the entire team – DBAs, developers, QA engineers, and architects – to collaborate on the performance of applications, enabling better service and faster time to market. In turn, freeing them from dependence on DBAs for production data. QA engineers can locate performance issues before deployment and easily communicate these issues to the development team. DBAs are then able to collaborate with the extended IT organization while maintaining 100% control over production servers and monitoring load.

    Learn More about SQL Server Monitoring »
  • No Agents and No Load

    No Agents and No Load

    SolarWinds’ SQL Server performance monitoring software is unique with no installed agent and less than 1% load on monitored server.

    Database Performance Analyzer for SQL Server monitors databases without installing any software on the production systems. Database Performance Analyzer for SQL Server is built on a three tier architecture, with software installed only in the middle tier. DBAs, developers, and managers access the solution from their browser. Database Performance Analyzer for SQL Server is installed on any Windows® server, as well as UNIX®/Linux® servers. The repository database is configured in a SQL Server or Oracle® instance, often a test or development system. Database Performance Analyzer for SQL Server’s agentless probes reach across the network to the monitored databases - SQL Server as well as other vendors - and pull performance statistics back to the repository for analysis and reporting.

    Learn More about Agentless SQL Performance Monitoring »
Download Free Trial Fully Functional For 14 Days

System Requirements

Repository Database

Database Performance Analyzer for SQL Server repository can be either

  • SQL Server 2005, 2008, 2012, 2014
  • Oracle 9i,10g, 11g, 12c (Single tenant )

Supported monitored databases in 9.0 include:

  • SQL Server 2005, 2008, 2012, 2014
  • Oracle 9i,10g, 11g, 12c (Single tenant)
  • Sybase ASE 15.0.x, 15.5, 15.7 (also called 16)
  • DB2 LUW 9.x, 10.1, 10.5

Operating System

Windows, Linux or UNIX supporting Java JRE 1.5 or higher.

Hard Drive

2GB per monitored instance

Memory

4GB

CPU

Dual Core

Other

  • “Express” editions of either SQL Server or Oracle can be used for DPA’s repository database, but please note that these free editions do have restrictions that can limit analysis performance and historical repository size for larger deployments.
  • To ensure consistent 24/7 monitoring, Database Performance Analyzer should not be installed on a laptop or any other computer that gets powered down frequently.
  • Database Performance Analyzer for SQL Server needs to be installed on a server that does not contain monitored instances in order to ensure negligible load on the monitored Instances.

NOTE: The minimum server requirements listed assume default configuration. The number of monitored instances, transactional load on the monitored instances, and number of active client sessions can increase the resource requirements of the server that Database Performance Analyzer is installed on.

Download Free Trial Fully Functional For 14 Days

Demos

Datasheets

  • Database Performance Analyzer for SQL Server

    Database Performance Analyzer for SQL Server is a comprehensive database performance monitoring and analysis solution for DBAs, IT management, and application developers. Database Performance Analyzer for SQL Server eliminates performance bottlenecks, improves application service, and reduces overall cost of SQL Server operations.

Videos

  • Database Performance Analyzer for SQL Server overview

    This short video provides an introduction on how to use Database Performance Analyzer for SQL Server to monitor SQL Server database performance 24/7, and pinpoint the root cause when problems strike.

  • Database Performance Analyzer Guided Tour

    Join James Davis for this guided tour of the multi-dimensional performance features in Solarwinds Database Performance Analyzer including SQL Statements advise, Storage I/O, baselines, alerting and wait based response time analysis.

  • Utilize DPA Storage I/O to find Performance Issues

    This video will help you to use the new Storage I/O feature in Database Performance Analyzer to gather clear evidence to show your Storage Admin on exactly when I/O slowdowns are impacting database performance and precisely how the slow application performance can be attributed to the I/O subsystem.

Whitepapers

  • Response Time Analysis - A Pragmatic Approach for Tuning and Optimizing SQL Server Performance

    Response time analysis is an approach that enables DBAs to measure the time spent on query execution and, therefore, measure the performance impact on end users. In this paper, Senior DBA Dean Richard describes response time analysis in detail and provides an overview of the tools available for effective response time analysis within a SQL Server environment.

  • SQL Query Tuning for SQL Server

    Authored by Dean Richards, Senior DBA, the SQL tuning methods presented in this detailed paper follow a simple, repeatable, four-step process. Several tuning case studies help illustrate how the method works in real applications. This methodology is a valuable time saver because it will help you get it right the first time.

Quick Start Guide

Infographic

  • SQL Server Query Performance Tuning: A 12-Step Program

    Unlike trying to speed SQL Server performance by through system-level server tuning, query tuning can have immediate and powerful results, offering as much as 10x increase in performance! Learn the 12 key steps to successful query tuning in this infographic.

Product FAQ

  • Q: How is Database Performance Analyzer for SQL Server licensed?

    A: Database Performance Analyzer for SQL Server is licensed based on the number of SQL Server instances to be monitored. An unlimited number of DBAs, Developers and Managers can access Database Performance Analyzer for SQL Server to view performance of any licensed instance.

  • Q: On what server is Database Performance Analyzer for SQL Server installed?

    A: Database Performance Analyzer Server is installed on any Windows, Linux or UNIX server. No software is installed on the SQL Server to be monitored.

  • Q: Are there agents or other Database Performance Analyzer for SQL Server software installed on the SQL Server to be monitored?

    A: No, Database Performance Analyzer for SQL Server is agentless, and places less than 1% load on the monitored server. Nothing is installed on the SQL Server to be monitored.

  • Q: What is involved in running a Database Performance Analyzer for SQL Server trial?

    A: A free trial is instantly available by downloading Database Performance Analyzer for SQL Server from this site. The install takes just minutes, and as soon as data is captured, you’ll begin seeing results. A free trial key enables unrestricted usage across an unlimited number of servers for a 14 day period.

  • Q: Can Database Performance Analyzer for SQL Server monitor other databases besides SQL Server?

    A: Yes, Database Performance Analyzer for SQL Server also supports Oracle, Sybase, and DB2, all from the same installation. Just point Database Performance Analyzer for SQL Server at the database instances to be monitored, then view them all from the same interface.

Download Free Trial Fully Functional For 14 Days

Version History

v 9.0
  • Storage I/O Analysis
    • Monitoring, correlation and history on I/O performance
    • Latency and throughput of storage systems
    • Clear visibility of storage performance and it’s effect on SQL response time
  • Resource Metrics Baselines
  • SQL Statement Analysis and Advise Database File/drive tab
  • Alert Improvements
    • Resource Metric Alerts
    • Alerting Blackouts
  • Extended Version Support
    • SQL Server 2014
    • Oracle 12c (single tenant)
    • DB2 10.5
+ Read More
v 8.3
Active Directory Integration - Authentication support via Windows Active Directory (AD)
  • Use Active Directory credentials for Database Performance Analyzer login, roles and permissions.
  • Single sign-on streamlines the login process.
  • Ensure compliance with password strength and expiration policies through Active Directory.
+ Read More
Ignite Central - Scales to support large Database Performance Analyzer deployments
  • Single view of critical problems worldwide.
  • Exception based management -only see extraordinary events.
  • Scales to thousands of monitored instances.
+ Read More
Awards & Props

2013 SQL Server Pro Community Choice Awards: Silver, Best Database Monitoring & Performance Product

  • awards
Some of the companies that rely on us

SolarWinds is trusted by Fortune 500 companies, & small businesses alike.

  • awards
  • awards
  • awards
  • awards