iReplay™: Database Workload Capture & Replay

For Sybase ASE, IBM DB2 LUW & Informix

iReplay™ is a next-generation testing solution that allows you to capture & replay your full scale Production Database SQL workload, improving test accuracy by virtually eliminating the difference between simulated lab conditions and real production workloads, transparently with zero-impact to your Production Database. Unlike scripting tools or load simulators, iReplay allows you to capture a full-scale image of your production SQL workload using Network traffic capture, and then recreate that traffic with all of its native concurrency, interleaving & complexity for detailed analysis in test environments. This approach is ideal for situations where simple scripting based efforts are not sufficient, such as Database Upgrade from DB2 9.1 to 9.7 or 10, or Sybase 12.5 to 15, Informix 10.x to 11.7 or 12.1, underlying platform changes, or Testing effects of Database optimizations on a Production scale workload. iReplay will reproduce the captured workload exactly as was observed during the original capture. There is no exception to the workloads replayed and different types of SQLs, be it Dynamic SQLs, Bulk Inserts, Scrollable Cursors, SQLs involving Binary data (BLOBs, CLOBs, etc.)  can be replayed using this tool. All this, without imposing any load on your Production Database systems, because iReplay™ workload capture works on the basis of passive network capturing requiring no changes/connections/applications installed on your production database system. This crucial point eliminates the overhead imposed by traditional methods such as use of SQL Trace or Profilers, or Oracle Real Application Testing.


 

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. Changes can be effectively gauged by comparing the SQL response times giving an accurate Change Feedback. 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.
Transparent, Zero-Impact operation. Works by listening passively to network traffic; does not use SQL traces; requires no changes/connections to your Production Database.
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, DB2, Informix with planned support for Microsoft SQL Server and Oracle.
Built-in Analytics iReplay captures the same rich, SQL-level performance measurements found in iWatch.
Comprehensive before/after reporting. Detail- and summary-level comparison reporting at the run level, session level or transaction level, with robust filtering
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.
Capable of Replaying Large Enterprise Level Workloads Ability to replay very large workloads running into a 200 MBytes/sec or more network throughput or hundreds of thousands of transactions/sec; as well as thousands of concurrent TCP connections. All this, while reproducing the exact concurrency and timing.

Next Section : iReplay Applications & Workflow