Double-click on create Virtual User followed by Run. This will proceed to run a single Virtual User with one Query Set.
When complete the Virtual User will show the query set time as well as the geometric mean of queries that returned rows including a count of those queries that returned rows.
For a single virtual User test you may wish to change the query order. This query order is predetermined in the common modules. However you can redefine this function by copying and pasting the ordered_set function and modifying the order. The following example is sufficient for the single Virtual User
rename ordered_set ordered_set_orig
proc ordered_set { myposition } {
if { $myposition > 40 } { set myposition [ expr $myposition % 40 ] }
set o_s(0) { 14 2 9 20 6 17 18 8 21 13 3 22 16 4 11 15 1 10 19 5 7 12 }
return $o_s($myposition)
}and then you can change the query order as follows:
set o_s(0) { 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 }If your database has issues with particular queries being long running you can also remove queries this way that you do not wish to run.