Benchmark Factory for Database 8.0 - User Guide

Options (Capture/Replay)

Settings on the Options tab allow you to apply scaling to the user scenarios (transactions) for a particular test.

To apply scaling to user scenarios

1. In the Edit Job or New Job Wizard, select a test under Workload in the left pane.
2. From the Test Options tab, select the Options tab.

3. Modify options. Review the following for additional information:

   Enable Userload scaling (simulation)	Select to enable scaling for all user scenarios in the selected test. Move the slider to the right to scale up userload for all scenarios (transactions) during playback. You can also specify the number of users per scenario in the Transactions tab. See Transactions Tab for more information.
   Execute by time	Sets the time and length of the capture replay test.

Add SQL Transactions

The Add SQL Transactions function allows you to add a SQL statement transaction to a test in the Job workload.

To add a SQL statement transaction to a test

1. In the Edit Job or New Job Wizard, select a test under Workload in the left pane.
2. From the Test Options tab, select the Transactions tab.
3. Select Add SQL Transactions from the Add SQL Transactions drop-down list.
   • Or select a user scenario and click to open the list of SQL transactions. Then select Add SQL Transactions.
4. The Add SQL Transaction dialog opens. Do one of the following:
   • Enter a SQL Statement.

   • Or click to launch the BF Script Wizard. See BFScript Wizard for more information.

     

   • Or click to import SQL from a file.

5. Modify the remaining options on the SQL Statement tab. Review the following for additional information:

   Statement Name	Enter a name for the statement, or use the default.
   Execution Method	Select an execution method for the SQL statement. Prepare and Execute SQL—Prepare the SQL and execute immediately after preparation. Prepare SQL Only—Prepare SQL without executing. Execute already prepared SQL—These transactions will run the SQL statement contained with the reference prepared SQL when called. If the statement has not been prepared, an error will generate.
   	Click to execute the SQL statement. See Run SQL Preview for more information.
   	Click to add a bind variable. Select the Bind Parameters tab and then click or double-click within the Bind Parameters window to add a bind variable and value.

6. Select the Latency tab to specify latency values for the SQL transaction. See About Latency for more information.
7. Click OK in the Add SQL Transaction dialog to the save the SQL statement and add it to the test.

Use BFScript Wizard

Note: Controls with yellow background can be scripted.

Benchmark Factory scripting allows you to randomize the load testing process. Scripting can be utilized by selecting the SQL Statement node and inserting the script in the properties view. A field has scripting capabilities if its right-click menu contains the Script Wizard option.

The Script Wizard is a quick and easy way to use Benchmark Factory scripts. The Script Wizard consists of a script category and a script function. Each script function has a short description included and if applicable, its parameters.  

There are two features within Benchmark Factory that assist you when using scripting capabilities:

• Script Wizard
• Script Assist

Click here for an overview of $BFScripts.

Script Wizard

1. Right-click the edit control. A drop-down display.

2. Select BFScript Wizard from the drop-down. The Script Wizard displays.

3. Select the desired script.
4. Some scripts require further parameters settings. For a complete overview of individual script settings, please refer to Scripts Overview.

If scripts require parameters:

1. Click Next.
2. Enter the required parameters.

5. Click Finish. The script and parameters display in the Script Wizard.

Script Assist

1. Type in the desired SQL statement. When $BF is typed the Script Assist is activated allowing you to insert the desired script.

2. Select the desired script.
3. Press Enter. The script displays.
4. Type in parameters as required.

Run SQL Preview

SQL Preview allows you to preview the result set of an individual SQL statement when adding or editing a SQL transaction.

To run SQL Preview

1. In the SQL Statement tab, click .
2. Select a connection from the drop-down list.

4. In the Maximum Returned field, enter the maximum number of rows to preview, or select the All option to preview all rows.
5. Click OK. The SQL Preview window opens.
6. Review the information.
7. Click Close.