Solarwinds Database Performance Analyzer for DB2
The Fastest Way to Identify and Resolve DB2 Performance Problems
License with 1st-year Maintenance
Our Price: $3,495.00
License with 1st-year Maintenance
Our Price: $3,345.00
License with 1st-year Maintenance
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.
Historical Trends and Resource Correlation
DPA’s historical repository highlights the trends and anomalies that are easy candidates for SQL tuning.
Alerts, Reports, and Baselines
Comprehensive alerting and reporting without overloading your inbox. Baselines highlight outliers.
Expert Advice
DBAs see SQL performance tuning advice for the instance. Advice for developers can focus on a specific SQL query.
Multi-dimensional analysis isolates root cause of complex issues
Correlate wait times, queries, users, files, plans, objects, and time to pinpoint problems.
View DPA analysis and metrics within SolarWinds' Orion interface
Get database performance in the context of specific applications inside SolarWinds Server & Application Monitor.
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
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
Custom alerts
DB2 SQL Statement Advice
DB2 Wait Events SQL Statements Response Time
DPA Centra
Vmware Server Health Trends Sql Corellation
Documentation:
Download the Solarwinds Database Performance Analyzer for DB2 Datasheet (.PDF)
License with 1st-year Maintenance
Our Price: $3,495.00
License with 1st-year Maintenance
Our Price: $3,345.00
License with 1st-year Maintenance
Our Price: $3,195.00
License with 1st-year Maintenance
Our Price: $3,095.00
License with 1st-year Maintenance
Our Price: $4,345.00
License with 1st-year Maintenance
Our Price: $4,170.00
License with 1st-year Maintenance
Our Price: $3,995.00
License with 1st-year Maintenance
Our Price: $3,845.00