Chapter 6. Managing complex query workloads in an operational warehouse environment 239
6.1 Get started with Optim Performance Manager in
your environment
Optim Performance Manager is a highly configurable application for monitoring
the performance and health of a database. Performance metrics are collected
from the monitored database and stored in an Optim Performance Manager
repository database. Using the Optim Performance Manager web interface you
can switch views between real-time and historical analysis of collected data to
determine current and historical performance for an individual query or for an
entire query workload.
Using Optim Performance Manager in a warehouse environment helps you
identify which queries are consuming resources on individual database partitions
and across the entire database.
Individual query workloads can be identified through a common attribute such as
the client application ID, and IP address, or user ID. From within Optim
Performance Manager, you create and configure a DB2 WLM workload object to
align with a specific query workload. This enables you to filter data on
dashboards and reports by workload object so that you can monitor and compare
the performance of individual query workloads.
Service level objectives for the number of concurrent user sessions, the number
of concurrent queries, and for elapsed query time can be easily aligned with
performance metrics by workload.
To begin using Optim Performance Manager, you perform the following tasks:
Create a database connection
Configure database monitoring settings
Get Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
