Database workload capture and replay

A computing system configured to generate replay data from workload capture data, the computing system comprising:

• one or more processing units coupled to the memory;
• and
• one or more non-transitory computer readable storage media storing instructions that, when loaded into the memory, cause the one or more processing units to perform operations for:
• receiving a workload capture file, the workload capture file including files for each of a plurality of execution contexts and at least one performance measure file;
• extracting the plurality of execution context files and the at least one performance measure file to provide execution context data and performance measure data;
• for each of a plurality of workload capture units, collecting execution context data and performance measure data associated with the respective workload capture unit;
• for each of the workload capture units, storing the collected execution context data and performance measure data in a format replayable by a second database system.

In a computing system that implements a database environment, the computing system comprising one or more processors and a memory, a method comprising executing by the one or more processors instructions loaded into memory for replaying a captured database workload, the method comprising:

• receiving workload replay data associated with a workload captured at a first database system, the workload replay data comprising execution context information and performance measures for one or more requests for database operations;
• executing the one or more requests for database operations at the second database system;
• generating second performance data associated with the execution of the one or more requests for database operations at the second database system;
• and
• comparing first performance data associated with the execution of the captured workload at the first database system and the second performance data.