Integrating Workload Replays Into Database Change Management
There is one universal database constant: no matter what, the database will change over time. Often, however, Service Level Agreements (SLAs) and user expectations remain mostly the same - in particular, that application performance will not degrade significantly. Unfortunately, most tools are insufficient to enable DBAs to manage change and maintain database performance. Quest's Toad DBA Suite for Oracle, however, includes a tool that can help - Benchmark Factory for Databases, which enables DBAs to capture and replay live database workloads before and after database changes, and scientifically determine whether the change is positive or negative. This paper explains how DBAs can use Benchmark Factory to ensure that changes to their databases do not degrade the user experience.