End To End Performance Management On Ibm I

End to End Performance Management on IBM i

Monitoring and managing your system's performance is critical to ensure that you are keeping pace with the changing demands of your business. To respond to business changes effectively, your system must change too. Managing your system, at first glance, might seem like just another time-consuming job. But the investment soon pays off because the system runs more efficiently, and this is reflected in your business. It is efficient because changes are planned and managed. Managing performance of any system can be a complex task that requires a thorough understanding of that system's hardware and software. IBM® i is an industry leader in the area of performance management and has many qualities that are not found in other systems, such as: - Unparalleled performance metrics - Always-on collection of metrics - Graphical investigation of performance data While understanding all the different processes that affect system performance can be challenging and resolving performance problems requires the effective use of a large suite of tools, the functions offered by IBM i are intended to make this job easier for users. This IBM Redbooks® publication explains the tasks and rich tools associated with performance management on IBM i.

End to End Performance Management on IBM i

Performance Management: Using IBM InfoSphere Optim Performance Manager and Query Workload Tuner

This IBM® Redbooks® publication describes the architecture and components of IBM InfoSphere® OptimTM Performance Manager Extended Edition. Intended for DBAs and those involved in systems performance, it provides information for installation, configuration, and deployment. InfoSphere Optim Performance Manager delivers a new paradigm used to monitor and manage database and database application performance issues. It describes product dashboards and reports and provides scenarios for how they can be used to identify, diagnose, prevent, and resolve database performance problems. IBM InfoSphere Optim Query Workload Tuner facilitates query and query workload analysis and provides expert recommendations for improving query and query workload performance. Use InfoSphere Optim Performance Manager to identify slow running queries, top CPU consumers, or query workloads needing performance improvements and seamlessly transfer them to InfoSphere Optim Query Workload Tuner for analysis and recommendations. This is done using query formatting annotated with relevant statistics, access plan graphical or hierarchical views, and access plan analysis. It further provides recommendations for improving query structure, statistics collection, and indexes including generated command syntax and rationale for the recommendations.