Workload Testing

Trace Replay

Capture Extended Events traces from production and replay them against target instances with multi-threaded simulation, speed control, dry-run mode, and comprehensive performance comparison reports.

Replay Results
StatusQueryOriginalReplay
SELECT * FROM Orders...245ms198ms
EXEC usp_GetReport...1.2s1.4s
INSERT INTO Audit...45msError
UPDATE Products SET...320ms290ms
Threads: 10 | Events: 1,247 | Success: 98.2% | Avg Speedup: 1.15x

Capture & Replay Features

Complete workload capture, replay, and analysis in a single tool.

Flexible Capture Modes

On-premises (file target or ring_buffer), Azure Managed Instance (ring_buffer or Azure Blob Storage), or read from existing XE sessions.

Advanced Event Filtering

Filter by database, minimum duration, event types (batches, procedures, statements), and object/function names.

Multi-Threaded Replay

Simulate concurrent users with configurable thread count (default: 10). Control replay speed from max throughput to real-time pacing.

Dry-Run Mode

Wrap all replay queries in transactions that roll back automatically. Test workload safely without modifying data.

Performance Comparison

Green/red/amber comparison of original vs replay duration for every event. Identify queries that got faster or slower.

Comprehensive Summary

Total events, replayed count, error count, success rate, average durations, overall speedup, and wall clock timing.

Query Benchmarking

Side-by-side performance comparison and query benchmarking to validate migrations, upgrades, or configuration changes.

PDF & Excel Reports

Generate professional reports with charts, summary tables, and detailed event-by-event results for stakeholder communication.

System Requirements

OS:Windows 10/11 or Windows Server 2016+
SQL Server:SQL Server 2016+ (Extended Events support)
Azure:Azure Managed Instance
Permissions:ALTER ANY EVENT SESSION, VIEW SERVER STATE

Test Your Workloads Before Going Live

Capture production traces and replay them in test environments. Validate migrations and upgrades with confidence.