I ran a set of replay tests, and monitored the CPU utilization of the database server. I noticed that for all but the single-user tests there are two CPU peaks, the first of which is probably associated with logging-in the users.
I would like to repeat this test, but staggering the start-up of the ten users to remove the initial peak, to see the effect on the subsequent CPU load.
The replay test does not offer the User Startup option (eg start a new user every 8 seconds), which is only available on the Timing tab, itself found only in the Mix and Goal tests. I can copy my original Replay test to a Mix test, but this test will then be limited by time (whatever presampling and sampling times I choose), whereas my replay test was limited by the number of executions - in the example above, ten users each running the query once.
Is there any way that I can run my query for ten users, once each, but with users connecting to the database at, say, eight second intervals?
Right click on your replay test and choose Copy to Mix Test. Click on the newly created mix test and choose the timing tab. Change the User Startup option to the desired setting. Click on another tree item to make sure the changes are saved, then right click on the mix test that was just modified and choose copy to Replay test. The new test that is created will use the user startup values that were saved in the mix test. You can copy this test into a new job and run the test.
Enhancement Request CR0223010 has been submitted to Development for consideration in a future release of Benchmark Factory.