The goal of an OPM implementation in a warehouse environment is to identify
which database operations and application workloads are consuming
resources on individual database partitions and across the entire
database. Identifying the appropriate indicators and workloads to monitor
in your environment is a key step in measuring the performance of your
database workloads against your service level objectives.
When implementing OPM in a production environment it is important that you
configure OPM to collect only the data that you need to monitor the
service level objectives set. When more detailed metrics are needed, such
as when introducing a new application or troubleshooting a query, they can
be collected for defined periods.
The IBM Smart Analytics System product incorporates best practices
guidelines for a stable and high-performance data warehouse environment.
This paper builds on that approach by recommending how you can use OPM to
monitor database performance and identify deviations in behavior across