Chat now with support
Chat with Support

Benchmark Factory for Database 8.4 - User Guide

Welcome to Benchmark Factory What's New in Benchmark Factory Additional Resources Overview of Benchmark Factory Benchmark Factory Components Licensing Getting Started - the Benchmark Factory Workflow Agents Create and Edit Connections Create and Edit Tests and Jobs
Jobs View Pane Job Wizards Quickstart: Create a New Job Edit a Job Industry Standard Benchmark Tests Capture and Replay a Workload Artificial Test for Desired Effect Scalability Tests Custom Tests Create/Delete Benchmark Objects Execute External File Test Options for Create Objects Test Options for Transactions Job Setup Options Use Global Search/Replace Save Job as BMF Script Copy Test to Replay, Mix, Goal, or Scalability Test
Benchmarks How Do I... Settings Test Results and Run Reports BFScripts Repository Troubleshooting The Benchmark Factory REST API Appendix About Us Adding Virtual Users System/Upgrade Requirements/Supported Databases Shortcut Keys

Replace Child Latencies

Latency is delay added to the execution of a transaction to control how fast transactions are submitted to the system-under-test. You can use the Replace child latencies dialog to quickly modify latency for all the direct children of a test.  For example, when an Oracle trace file is imported, the latencies are automatically set to replay the transactions at their original rate, but changing these to a set value can replay the transactions in a shorter period of time.

To replace child latencies at the test level

  1. Use one to the following methods to open the Replace Child Latencies dialog:
    • In the New/Edit Job Wizard, right-click a test and select Replace Child Latencies.

    • In the Jobs View pane, right-click a test and select Replace Child Latencies.

  2. In the Replace Child Latencies dialog, modify latency options. See Specify Latency for more information.

  1. Click OK to save your changes and close the dialog. The changes are applied to all the child transactions of the transaction mix. The changes are not inherited by the grandchild transactions. For example, if the transaction mix contains a user scenario, the latency values for the individual transactions in the user scenario remain unchanged. To change the latency values for transactions in the user scenario, right-click the user scenario and select Replace Child Latencies.

To replace child latencies at the User Scenario level

  1. In the New/Edit Job wizard, select a transaction mix step and open the Transactions tab.
  2. In the Transactions tab, right-click the user scenario and select Replace Child Latencies.

  3. In the Replace Child Latencies dialog, modify latency options. See Specify Latency for more information.

 

 

Use BFScript Wizard

The Benchmark Factory scripting feature known as BFScripts allows you to insert randomized data into the load testing process. You can use BFScripts when you add SQL transactions. See Transactions Tab for more information.

Script-enabled fields have a yellow background. A field has scripting capabilities if the field's right-click menu includes the BFScript Wizard option. The BFScript Wizard is a quick and easy way to use Benchmark Factory scripts. The BFScript Wizard provides you with a list of built-in script functions, grouped by category, from which to select. Each script function has a short description included, and if applicable, the function parameters.  See About Scripts for an overview of BFScripts.

There are two features in Benchmark Factory that assist you when using scripting capabilities.

BFScript Wizard

  1. Use one of the following methods to open the BFScript Wizard:
    • From within a script-enabled field (yellow background), right-click and select BFScript Wizard.

    • In the SQL Statement tab, click .
  2. Select a category in the left pane to display BFScripts (functions) in the right pane.

  3. Select a BFScript name (function).
  4. If the script requires parameters, click Next and enter the required parameters.
  5. Click Finish to enter the script in the field.

Script Assist

  1. When entering a SQL statement, enter $BF. Script Assist automatically displays a list of scripts from which you can select.

  1. Select the desired script.
  2. Press ENTER to enter the script in the field.
  3. Enter 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.

     

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

 

Stagger User Startup

When running a load test, you have the option of staggering user startup. This allows you to adjust startup loads if, for example, you are having issues with overloading of servers when all of the users attempt to start at the same time.

To stagger user startup

  1. In the Edit/New Job Wizard, select a test under Workload.
  2. Select the Timing tab (under Test Options tab).
  3. In the User Startup options, select the desired parameters.

            

  • Start all users as quickly as possible: Starts all users immediately after a test begins.
  • Start all users at even intervals for: Sets the amount of time in which to start all users at even intervals. The interval duration is equal to this value divided by the number of users.
  • Start a new user every: Starts a new user, then waits the entered number of seconds before starting the next user.

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating