CA Insight Database Performance Monitor for Distributed Databases

(1)

CA INSIGHT™ DATABASE PERFORMANCE MONITOR FOR DISTRIBUTED DATABASES

(CA INSIGHT DPM) HELPS YOU SIMPLIFY MANAGEMENT OF YOUR GROWING, COMPLEX DATABASE ENVIRONMENT. CA INSIGHT DPM ALSO PLAYS AN IMPORTANT ROLE IN IMPROVING SERVICE AVAILABLIITY ACROSS YOUR COMPLEX IT INFRASTRUCTURE WITH INTEGRATION TO THE OTHER CA DATABASE MANAGEMENT AND CA'S APPLICATION, NETWORK, AND SYSTEMS PERFORMANCE MANAGEMENT SOLUTIONS.

Overview

Slow response time can negatively impact your customer’s satisfaction and company profitability. As applications depend on databases that reside on a variety of operating systems supported by a larger infrastructure, determining the root case of a performance issue can be difficult.

With business-critical data continuing to grow at an alarming rate, CA Insight DPM helps you understand and manage database performance to maximize service availability goals.

Benefits

Reduce management complexity and its associated costs with unification of database monitoring on a single display without reliance upon a specific platform or database vendor.

Reduce the number of service disruptions with proactive identification of database performance issues. Combined with historical trending, you can eliminate guesswork to identify, diagnose and solve the root cause of poor performance before it negatively impacts your business.

The CA Advantage

CA Insight DPM is unique in its ability to provide an “at-a-glance” performance summary of all monitored databases on one screen, including an overall database health index.

Resolving performance issues across the IT stack is simplified with a “single source of truth”. CA Insight DPM delivers key metrics directly into CA's application, network, and systems management to support your integrated performance management initiatives as well as the CA Enterprise IT Manage -ment vision.

CA Insight

™

_{Database Performance}

(2)

2 PRODUCT BRIEF: CA INSIGHT DATABASE PERFORMANCE MONITOR

Reduce Complexities of Performance Management

CA Insight DPM helps you simplify management of your growing, complex database environment with it’s unification of database monitoring on a single display without reliance upon a specific platform or database vendor.

Slow or unresponsive applications can impact your customer’s satisfaction and your profitability. The amount of data being collected and stored by applications into databases continues to grow at a significant rate, while databases themselves have become larger and more complex. With a greater number of objects and interdependencies introduced in each database release, managing the complexity of your database infrastructure with existing staff becomes more challenging. With business-critical data residing in numerous locations on different physical systems and on different databases, CA understands the challenge you face to meet existing service levels and improve management practices.

Improve Service Availability

To reduce poor performance resolution time and cost, CA Insight DPM unifies database performance monitoring with a browser-based multi-database management console, giving you the power to proactively detect and prevent database performance issues before they negatively impact business processes. You can automate the monitoring, data collection and performance analysis of DB2 for Linux, UNIX, Windows (LUW), Oracle, SQL Server, Sybase. Monitored information can be displayed as it is happening or historically — days, months, or longer.

(3)

CENTRALIZE DATABASE PERFORMANCE MANAGEMENT

How CA Insight DPM Works

Upon installation, CA Insight DPM automatically detects and proactively alerts on conditions that affect database availability. It speeds your problem resolution time by providing in-depth details on the database and its associated subsystem interaction. Flexible architecture supports scalability of the business with low overhead collection of critical performance metrics. You can quickly diagnose and resolve complicated database performance issues that were difficult to resolve in the past; pinpointing the root cause in real time or by reviewing historical information so the issues don’t occur again.

You can use the predefined and customizable thresholds and alarms to send notification when an event occurs, giving you the ability to quickly trace and resolve performance-related issues. For in-house developed applications or site specific monitoring requirements, you have the flexibility to implement multi-threshold, custom monitoring scans and alarms.

FIGURE A

(4)

Supports Your Performance Management Integration Initiatives

INTEGRATION WITH OTHER CA DATABASE MANAGEMENT SOLUTIONS The CA Insight DPM browser-based management console, called the CA Database Command Center (CA DCC) is the integration point to the other CA distributed database management solutions to further expand functionality. This includes high-speed database restructuring with CA TSreorg™ for Distributed Databases to improve database efficiency and fast data extraction with CA Fast Unload® for Distributed Databases.

• Restructure objects that have become fragmented

• Reclaim space used by dropped tables, recluster data, rebalance index trees and reduce the

number of index levels

• Maintain availability of data and applications during reorganization process

• Combine data extraction with control of output file format

• Unload into multiple formats

INTEGRATION WITH CA'S APPLICATION, NETWORK, AND SYSTEMS PERFORMANCE MANAGEMENT SOLUTIONS Monitoring performance across many different applications, databases, networks and systems is a formidable task for which centralized management is needed to help maintain and control the environment. Because highly available databases are meaningless to the business if your supporting infrastructure goes down, CA Insight DPM is a critical component when building an overall integrated performance management strategy. The integrated performance management solutions from CA include CA eHealth® Network Performance Manager (CA eHealth NPM), CA SPECTRUM® Network Fault Manager (CA SPECTRUM NFM), CA Network and Systems Management (CA NSM)/CA Advanced Systems Management (CA ASM) and CA Wily Introscope®, which can all be licensed separately.

Integration Benefits:

• In-context integration with CA Wily Introscope includes dashboards for DB2 for LUW, DB2

for z/OS, Oracle, SQL Server and Sybase databases. This helps you troubleshoot and resolve issues quickly to maintain application availability.

• In-context integration with CA eHealth NPM/CA SPECTRUM NFM includes many reports

and views for DB2 for LUW, Oracle, SQL Server and Sybase databases. This provides you with a comprehensive view of both database and network performance information for correlation of alerts and fault determination to resolve issues quickly.

• In-context integration with CA NSM/CA Advanced Systems Management includes

(5)

DATABASE INFORMATION WITHIN CA eHEALTH NPM REPORTS INTEGRATION EXAMPLE

Key Capabilities

CROSS DATABASE MANAGEMENT In-context integration unifies and simplifies your management of different RDBMS and provides a consistent look and feel that helps you expand your skills to manage more databases. If you decide to add the additional database management capabilities for database restructuring and fast data extraction, the new functionality is seamlessly enabled with the same in-context integration.

INCREASE AVAILABILITY WITH 24 X 7 MONITORING No matter the number of databases, size, or system they reside on, you can keep them up and operating at maximum efficiency. The shared memory data collection architecture was designed to handle large and complex multi-database environments so you can scale up and out without overburdening the servers you are monitoring.

FIGURE B

(6)

• Flexible Remote or Agent-Based Monitoring CA Insight DPM gives you the choice of remote, agent-based monitoring or both. Remote monitoring is useful in circumstances where an agent cannot be deployed on the system where the database resides, while agent-based monitoring can continue even when networks become limited or unavailable. If you require scalability and high availability, agents, common services, and shared memory architecture minimizes resource utilization on the server and network services. Configuration to remotely monitor DB2 for LUW, Oracle, SQL Server utilizing native database client software can also be achieved.

• Database Discover and Adaptive Monitoring Automatic database discovery helps you select databases to monitor and instantiates objects when started. This means there is no pre-configuration or reconfiguration needed as database objects are added or removed. The product automatically acknowledges and responds to changes in the database so you don’t have to review what has changed and then reconfigure each time to monitor.

• Database, System and I/O Detail Monitor database performance in real time, with time-based graphical displays and up-to-the minute statistical data. Because performance is interdependent on interactions outside of the RDBMS, database operating system and I/O activity is also monitored and captured. Data is collected and presented cohesively within a single insightful console; you see the information and alarms correlated and in-context to the display so you can diagnose problems quickly and then initiate repair. Database metric collection is typical single-digit CPU utilization.

NOTIFICATION AND EVENT MANAGEMENT Changing business conditions, data influx and operations make database performance a moving target. Prevent unexpected outages, eliminate firefighting and regain control of your databases with notification and event management.

• Unattended Monitoring with Preset Scans Utilize hundreds of predefined scans that monitor critical components for problems and collect workload statistics on an enterprise wide basis. This reduces the need for you to write and maintain custom scripts for each database system separately.

• Proactive Alarm and Bottleneck Notification Alarms provide intelligent advisement and are integrated in-context for faster problem resolution. With multi threshold capabilities, you can customize how far in advance you want to be notified of congestion or an out of bound condition with predefined thresholds. Alarms exist for an array of conditions, including locking, storage, bottlenecks, contention, inadequate memory and many others. Alarm notification can go to the CA DCC as well as email, mobile device, or another master event console.

• Event Response By checking user-defined performance groups and scan parameters, conditions that exceed thresholds for corrective actions are measured and reported. The event management system sends alert notification for an array of conditions, including inadequate space, long running processes, high CPU utilization and inadequate swap or system space. You can take corrective action or setup event management responses or user defined scripts to take action when conditions are met and prevent database degradation or even an outage.

(7)

INTERACTIVE REAL-TIME AND LONG-TERM HISTORICAL PERFORMANCE DIAGNOSTICS Optimize database availability with proactive problem detection and alerting, including analysis and diagnostic capabilities for faster problem resolution. You can select to have performance information collected and stored in a repository or a flat file. This will provide you with summarized and detailed performance trending and diagnostics information, real-time and/or historical, within one graphical interface. As information is recalled from the past, it is

correlated and displayed as if you had been there watching in real time. You can increase your overall responsiveness, decrease time to resolution and improve efficiency by spotting and fixing performance issues before they become problems.

• Database Quality Health Index Within one view, all monitored databases are displayed and prioritized by a database quality of service. This feature eliminates the need for you to write scripts to determine database accessibility. It will automatically prioritize for you the databases that require attention before issues reach critical mass.

• SQL Capture and Store Often performance problems are not apparent because of added complexity. SQL is a good example of something that is complicated by variations by database vendor. You can identify top SQL resource consumers and capture SQL for offline review and SQL statement optimization.

• Trending and Workload Analysis Monitor the present state of the workload generated by your unique system and review historical trend information. Choose what scans and at which detail you wish to monitor, save and display with user defined configuration.

• Historical Replay Performance information is stored in a compressed time-series form with archive compression that you can configure. Monitor the present state of databases and compare them to historical baselines from workload metrics unique to your system. You choose at which depth you wish to collect information as well as how long to retain it for trending as well as capacity planning purposes.

CUSTOMIZABLE BROWSER-BASED CONSOLE The CA Insight DPM browser-based, platform independent interface provides the information you need to effectively and efficiently locate and resolve database performance issues, keeping underlying database complexity transparent. CA Insight DPM provides you with a common look to navigate different databases and quickly identify and pinpoint problems on an individual or enterprise wide database without having to learn different syntax or commands when managing unfamiliar database platforms. The browser-based interface is built using industry standard technology to ensure optimum performance, provide a consistent look and feel and offers user customization for site specific requirements.

(8)

• No Dedicated Console Required Performance data collection operation is not reliant on a console continuously being connected. Autonomously retrieve and save performance data into a shared memory segment locally, independent of any consoles that are running. Agents operate with three different scan intervals: real-time, alarm and archive. These “scan rates” are a feature of the agents themselves and not a function of a console. When a console requests a metric, the agent enters “real-time” mode of operation and populates its shared memory segment with the performance data. Regardless of the number of consoles running, the only overhead incurred is merely the network transmission for the requested data contained in the shared memory segment or buffer. With CA Insight DPM, the console is not a single point of failure as monitoring and performance collection continues even when a console is not up and running. The ability for you to have a console available almost anywhere when you need to check your databases remotely — without client software installation or the added work of maintaining it.

• Centralized Standalone and Integrated Performance Management Standalone, CA Insight DPM provides you with centralized multi-database performance management including database internals, CPU, memory, I/O, subsystem metrics and capture of SQL statements in one common console. Integrated into CA eHealth NPM, CA SPECTRUM NFM, CA NSM/CA ASM, or CA Wily Introscope, CA Insight DPM provides IT with a correlated enterprise view of applications, networks, and databases combined.

• Built-In Online Help CA Insight DPM includes online knowledge with advisor text that details each statistic specific to the RDBMS: DB2 for LUW, Oracle, SQL Server, Sybase and information on how to troubleshoot the problem. This helps you optimize database performance to maximum efficiency. If you are unfamiliar with any of the supported database platforms, you can utilize the online advisor text to shorten your learning curve and quickly resolve issues.

TARGET DATABASES AND ENVIRONMENTS (32/64 BIT)

NOTE: Target representation in general, new certifications continue to be released. Please consult CA Support Online or your CA Sales Representative on your requirements.

DATABASES

• IBM DB2 for Linux, UNIX, Windows • Microsoft SQL Server • Oracle Database • Sybase INTEGRATION • CA NSM/ASM r11.0, 11.1 • CA eHealth NPM 6.0 SP2 • CA Wily Introscope r8 • CA SPECTRUM NFM r9 SP1 • Alert notification to Third-Party HOST/SERVERS • Microsoft Windows • UNIX – Sun Solaris

– HP-UX (PA-RISC, Itanium) – IBM AIX

• Linux

(9)

CA Insight DPM Simplifies Database Performance Management to

Improve Service Availability

Prior to the availability of technology capable of centrally managing databases from multiple vendors, you might have relied on traditional or separate monitoring techniques for database availability and performance monitoring. With dynamically changing technology like SOA extending beyond the conventional group, business unit, or company wall, it necessitates rethinking what was once thought of as managed. Significant accomplishment in technology for central database management across vendors and platforms integrated with systems and network management is now available to you using CA Insight DPM.

IMPROVE DATABASE PERFORMANCE ISSUE RESOLUTION TIME Only one click needed to see database health for all monitored databases across the enterprise.

INDEPENDENCE FROM DATABASE OR SERVER PLATFORM Only one interface needed to manage all databases, providing you with a consistent look and feel across database vendors and operating system platforms.

SPEED COLLABORATIVE PROBLEM RESOLUTION TIME BETWEEN APPLICATION, DATABASE, NETWORK AND SYSTEMS TEAMS All teams see the same truth as database information from CA Insight DPM propagates CA eHealth NPM, CA SPECTRUM NFM, CA NSM/CA ASM, CA Wily Introscope.

In order for you to manage database complexity, you need the capability to get to the core of the problem. Understanding where applications are hitting the various tiers of the infrastructure, such as across the network, to systems and storage, to the database, all the way up through the application server and application tiers. Consolidating operations and enabling best practices across the IT infrastructure with automation enables increased business capabilities as well as controls costs as your business needs change.

The CA Advantage

(10)

Next Steps

CA Database Management Solutions can integrate and automate management of distributed and mainframe databases across the enterprise to reduce your administrative costs as well as increase performance and strengthen your compliance capabilities.

To learn more about how CA Database Management can help your organization, visit us at

ca.com/databasemanagement