Products
iReplay™: SQL Workload Capture & Replay
Available now for Sybase, Oracle, IBM DB2 & Informix
iReplay™ is a next-generation testing solution that allows you to capture & replay your actual SQL workload, improving test accuracy by virtually eliminating the difference between simulated lab conditions and real production workloads.
Unlike scripting tools or load simulators, iReplay allows you to capture a full-scale image of your production SQL workload, and then recreate that traffic with all of its native concurrency & complexity for detailed analysis in test environments.
The result is a significantly streamlined & more accurate testing process. Changes to critical systems can be tested with a degree of rigor that was previously thought impossible. Replicated runs can be tailored to meet a variety of test objectives, including regression testing, functional testing, performance testing, capacity planning, and more.
Coupled with precise SQL-level performance measurements, the technology also allows organizations to judge & calibrate proposed changes, without exposing their business operations to unnecessary risk -- or the potential for costly rollbacks.
As a result, the risks associated with database or infrastructure changes can be assessed more quickly & easily, and with unprecedented accuracy. The possibility that disruptive bugs or unexpected interactions might “slip through the cracks” can be virtually eliminated. Test and deployment cycles can be reduced, while confidence improves. Strategic re-architecture or re-platform projects can be streamlined & accelerated. Anticipated benefits of proposed changes can be measured precisely, before significant resources are committed.
| iReplay Highlights | |
|---|---|
| Replays production SQL traffic | Recreates SQL workloads at full production scale, with all of the concurrency & complexity of the original workload. Not a simulation or a script. |
| Flexible Replay Modes | Easy to tailor to a variety of test objectives, from functional testing, regression testing, capacity planning, performance testing and more. |
| All major database platforms supported. | Supports Sybase, Oracle, IBM UDB/DB2, with planned support (2H08) for Microsoft SQL Server. |
| Built-in Analytics | iReplay captures the same rich, SQL-level performance measurements found in iWatch. |
| Comprehensive before/after reporting. | Detail- and trend-level comparison reporting at the run level, session level or transaction level, with robust filtering |
| Transparent, zero-impact operation. | Works by listening passively to network traffic; does not use SQL traces. |
| Flexible capture deployment | Run a low-impact capture process directly on the source host, or isolate the capture process on a dedicated host or capture appliance, via a network tap. |