You might want to add an executable file (.bat or .exe) as part of a job. This gives you the flexibility to set up your database before running a workload. For example, you could run a .bat file to set up a prepared SQL statement before running a workload.
To add an Execute File step to a workload
To add a timeout, select the Enforce Timeout option and enter the number of seconds for Benchmark Factory to wait for the execution to complete before continuing the job.
You can specify a default setting for this option in Edit | Settings | Execute File.
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.
From within a script-enabled field (yellow background), right-click and select BFScript Wizard.
Select a category in the left pane to display BFScripts (functions) in the right pane.
When entering a SQL statement, enter $BF. Script Assist automatically displays a list of scripts from which you can select.
A test can be quickly converted from one test type to another by using the "copy" command. A workload test is an assembled test comprised of user scenarios and/or transactions. These tests can be run with multiple virtual users. A workload test can be one of three types: mix test, replay test, goal test, or scalability test.
In Benchmark Factory you can copy the following tests:
Copying a workload test creates a new test containing all compatible settings, user scenarios, and transactions from the original test.
To copy a workload test to a Replay Test, Mix Test, Goal Test, or Scalability test
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
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Conditions d’utilisation Confidentialité Cookie Preference Center