Patrick Titzler is a Solution Architect in the Information Management organization, currently supporting customers in their InfoSphere Optim Workload Replay evaluation and deployment efforts. He has been a frequent contributor to articles and tutorials, and developed videos, e-Learning and other training material for several products throughout his technical career at IBM.
Patrick holds a Master degree in Computer Science from the University of Rostock, Germany.
Production data server environments are a critical component in most enterprises. It must meet the availability and performance goals set by the business to avoid any significant impact to internal and external customers. Any change to the data server environment, irrespective of whether it is minor or major, occurs infrequently or frequently, can impact the behavior of critical applications (or to be more specific, SQL workloads).
Consider how you are currently conducting performance and stress tests or how you validate that installation of DB2, maintenance or an upgrade to a new version of DB2 doesn't have any unintended side impact on your critical workloads. InfoSphere Workload Replay can streamline your validation efforts by providing a robust test framework, that, unlike traditional test tools, does not rely on fabricated synthetic workloads to drive your database server. With InfoSphere Workload Replay you can capture actual production database SQL activity and replay it in pre-production environments at any time using the original concurrency, sequence and timing. And the best part is you don't need the application infrastructure to drive the workloads!
You can use the built-in reports to compare two workload executions and quickly identify relevant differences. Accuracy reports provide detailed insights into differences in return codes, number of rows returned or updated.
Performance reports provide summarized and detailed information about elapsed-time based regressions and improvements.
To learn more about additional use-cases, how to deploy and use InfoSphere Workload Replay for DB2 in your environment read
Getting Started with IBM InfoSphere Optim Workload Replay for DB2,SG24-8221
- How to use actual SQL workload data to test planned production database changes in pre-production
- Deployment Guide for InfoSphere Guardium ,SG24-8129
Likes before 03/04/2016 - 0
Views before 03/04/2016 - 1643