Does anyone know of a way to apply different timings to iterations inside a standard benchmark workload? Or how to have iterations decrease in load rather than increase? For example I would like to run the TPC-C or -E mix simulating a daily workload with nightly maintenance and day time peaks.
In my mind the scenario looks something like this:
8:00am - workload scales gradually up to some peak value, hitting the peak around noon.
12:00pm - workload scales down from peak to some low level
8:00pm - workload stays constant at a low level for 12 hours.
I could do this by creating a script that runs each time period in series - but is there a better way?
PS - obviously this is not for an actual benchmark run, I’m interested in looking at how the workload interacts with other applications on the same storage during peak, and non-peak times.