Call a Specialist Today! 800-886-5369

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


Solarwinds Database Performance Analyzer

SolarWinds Products
Solarwinds Database Performance Analyzer for DB2
SolarWinds Database Performance Analyzer per Oracle EE, DB2, or ASE instance (1 to 4 licenses)
License with 1st-year Maintenance
#29200
Our Price: $3,495.00
SolarWinds Database Performance Analyzer per Oracle EE, DB2, or ASE instance (5 to 9 licenses)
License with 1st-year Maintenance
#29201
Our Price: $3,345.00
SolarWinds Database Performance Analyzer per Oracle EE, DB2, or ASE instance (10 to 19 licenses)
License with 1st-year Maintenance
#29202
Our Price: $3,195.00

Click here to jump to more pricing!

Overview:

SolarWinds Database Performance Analyzer (formerly Confio Ignite) for DB2 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 DB2 database operations.

Database Performance Analyzer for DB2 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.
  • Agentless. Less than 1% load on monitored servers, even during heavy monitoring periods.
  • Multi-Dimensional Performance Analysis. Simplifies root cause analysis by correlating SQL statements, context, system and storage health, wait events, and response time.
  • Resource baselines, alerts, and reports. Proactively monitor system health, identifying trends before they become problems.
  • Show the complete picture. DPA 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.

multidimensional
Multi-dimensional analysis isolates root cause of complex issues

Correlate wait times, queries, users, files, plans, objects, and time to pinpoint problems.

engine
View DPA analysis and metrics within SolarWinds' Orion interface

Get database performance in the context of specific applications inside SolarWinds Server & Application Monitor.

agentless
Scalable, Agentless Architecture

DPA Central consolidates performance metrics from thousands of monitored instances.

Features:

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

Supports DB2 Deployment Options
Monitor and optimize DB2 performance 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 repository. While many tools focus only on the current situation, Database Performance Analyzer is unique because it analyzes repetitive clues that explain why DB2 database and E-Business application 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 UNIX/Linux or Windows server, typically a test system under control of the DBA. Database Performance Analyzer data warehouse repository is configured on any SQL Server or Oracle instance, either on the same or different server as the 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

Find DB2 performance bottlenecks within four clicks.
Stop guessing and drill into your database to pinpoint the root cause of poor application performance.

Single tool for monitoring database operations of hybrid IT environments.
Supports a mix of database engines and deployment options. Monitors DB2, Oracle, SQL Server, SAP ASE, and MySQL on-premises, on VMware, and in the Cloud, including Amazon AWS and Azure virtual machines.

Eliminate finger pointing among IT teams
Establish better collaboration among DBAs, developers, Q/A, and server administrators

Identify performance issues that impact application response time
Use response time analysis to make changes that end users will notice when their apps run faster

SQL query tuning
Access easy-to-understand bar charts and tuning advice for all skill levels

DB2 on VMware
Get a detailed view of both the physical and virtual resources impacting DB2 performance

Eliminate database bottlenecks on AWS
Get detailed visibility of DB2 performance on the Amazon Cloud.

System Requirements:


Hardware Minimum Requirements
CPU Dual Core
Memory 4GB
Hard Drive 3GB / monitored instance
Software Minimum Requirements
Operating System Windows, Linux or UNIX
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
MySQL 5.6+
VMware ESX/ESXi 5.1, 5.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

NOTE: System Requirements specified are for less than 20 monitored instances, additional resources may be required for larger deployments.

Screenshots:


Database Performance Analyzer historical trends

Database Performance Analyzer historical trends

Custom alerts

Custom alerts

DB2 SQL Statement Advice

DB2 SQL Statement Advice

DB2 Wait Events SQL Statements Response Time

DB2 Wait Events SQL Statements Response Time

DPA Centra

DPA Centra

Vmware Server Health Trends Sql Corellation

Vmware Server Health Trends Sql Corellation

 

SolarWinds Products
Solarwinds Database Performance Analyzer for DB2
SolarWinds Database Performance Analyzer per Oracle EE, DB2, or ASE instance (1 to 4 licenses)
License with 1st-year Maintenance
#29200
Our Price: $3,495.00
SolarWinds Database Performance Analyzer per Oracle EE, DB2, or ASE instance (5 to 9 licenses)
License with 1st-year Maintenance
#29201
Our Price: $3,345.00
SolarWinds Database Performance Analyzer per Oracle EE, DB2, or ASE instance (10 to 19 licenses)
License with 1st-year Maintenance
#29202
Our Price: $3,195.00
SolarWinds Database Performance Analyzer per Oracle EE, DB2, or ASE instance (20 to 29 licenses)
License with 1st-year Maintenance
#29203
Our Price: $3,095.00
Solarwinds Database Performance Analyzer for Virtualized Environments for DB2
SolarWinds Database Performance Analyzer for Virtualized Environments for Oracle EE, DB2, or ASE instance (1 to 4 licenses)
License with 1st-year Maintenance
#43060
Our Price: $4,345.00
SolarWinds Database Performance Analyzer for Virtualized Environments for SOracle EE, DB2, or ASE instance (5 to 9 licenses)
License with 1st-year Maintenance
#43061
Our Price: $4,170.00
SolarWinds Database Performance Analyzer for Virtualized Environments for Oracle EE, DB2, or ASE instance (10 to 19 licenses)
License with 1st-year Maintenance
#43062
Our Price: $3,995.00
SolarWinds Database Performance Analyzer for Virtualized Environments for Oracle EE, DB2, or ASE instance (20 to 29 licenses)
License with 1st-year Maintenance
#43063
Our Price: $3,845.00