Creating New Benchmark Runner Scenario

To create a new Benchmark Runner load test scenario:

  1. Choose File -> New -> Benchmark Scenario menu to open a new load test scenario panel.
  2. Select a database instance for load test scenario from the Connection dropdown listbox or create a new connection by pressing '...' button.
  3. Press the New Task button in the load test scenario panel to create a new task.
  4. Use the Task Name field to modify default name for the task. You can give it a logical name, such as Sales Order Entry or Accounting Report.
  5. Use the SQL Script editor to create a script for the task. Multiple SQL statements should be separated using ';' character. Optionally, you can import an existing SQL script from a text file by pressing Import button.
  6. If your script requires parametric values for any of the SQL statements, press the Edit Variables button to define load test scenario variables against an existing text data files as explained in the next section.
  7. Use the Number of Sessions filed to enter the required number of the virtual user sessions for this load test scenario's task. When the load test scenario is executed, Benchmark Runner will create the number of physical independent database connections you specified and each of these connections will execute the SQL script defined in the load test scenario's task.
  8. Use the Interval Between executions field to specify a delay between sequential script executions within one virtual user session. You can specify either random or fixed intervals. For example, if you specify 600 sec random interval, it means that a next script execution at the same virtual user connection might happen anytime between 0 sec and 600 seconds. Enter zero if you do not want to have any delay between script executions.

Repeat above steps to define additional load test tasks for the Benchmark Runner scenario you are creating. After you've completed defining your entire load test scenario, save it in a file by pressing the Save button. To start the load test scenario execution, press the Start button.