The best benchmark is not a benchmark at all - it is your actual workload!
iReplay™: Database Workload Capture & Replay
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 10.x to Db2 11.x, Sybase ASE 15.x to SAP ASE 16.x, or Informix 11.x/12.x to 12.x/14.x, underlying platform changes, or Testing effects of Database optimizations on a Production scale workload.
Recreate workloads at enterprise scale
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. SSL / TLS Encrypted sessions can also be replayed if the encryption private key is available.
Db2 z/OS (mainframe) replays also supported for external workloads using the 'Distributed Data Facility (DDF)' mechanism. Db2 mainframe migrations from z/OS to LUW is also supported for a variety of workloads.
Ability to replay workloads at very large scale:
Average network throughput of over 200 MegaBytes/second
Average 200,000+ queries/second
Peak 400,000+ queries/second
Over 25,000 concurrent connections
All this while reproducing the exact concurrency, timing and inter-session dependency with no impact on the production database
No overhead on production environment
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, Oracle Real Application Testing, SAP Workload Analyzer. Unlike these tools, iReplay can capture the entire production workload over multiple days without any application running on your production database. So no additional Disk IO/CPU usage on your production host as well as the target (test) database host.
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.
Database & Platform Support
iReplay is currently available for the following databases:
IBM Informix 9.x, 10.x, 11.x, 12.x, 14.x
IBM Db2 LUW 8.x, 9.x, 10.x, 11.x
IBM Db2 z/OS for DDF 8.x, 9.x, 10.x, 11.x
Sybase ASE 12.0, 12.5, 15.x, SAP ASE 16.x
Supported OS's include the following:
Linux (RHEL 6.x, 7.x, 8.x; SuSE 10, 11, 12; Other Linux flavors also supported)
AIX 6.1, 7.1 (Power PC)
Solaris 10, 11 (SPARC & x86)
Windows Server 2008 R2, 2012, 2016, 2019