Benchmark Factory for Database 7.6 - User Guide

Import SQL Files

Benchmark Factory allows you to import SQL files exported from other Quest Software products. When the Load Scenario Wizard completes, transactions containing the exported SQL will be created.  This gives you the ability to import SQL transactions, identified by Quest Software products, for further testing a under a load.

To import from SQL files

1. Select Wizards |Load Scenario.

                 or

         Click New. The Load Scenario Wizard displays.

2. Click Next. The Define load scenario dialog displays.
3. Click Import from SQL files.
4. Click Next. The SQL Tuning File Input dialog displays.
5. Click Browse.
6. Navigate to the desired tuning file.
7. Click Open.
8. Click Next. The Measurement Intervals dialog displays.
9. Select the desired user load.
10. Click Next. The Enter Script dialog displays and provides the following options:

• Create a new Benchmark Factory Script file-Selecting this option allows you to create and save a completely new script.
• Add to existing Benchmark Factory Script file-Selecting this option allows you to add the load scenario you are building to the current script file you are working with.

11. Select the desired option.
12. Click Next. The wizard completion dialog displays.
13. If the Do you want the job to be automatically submitted to the jobs queue? checkbox displays, then checking this will cause the Submit Job dialog to display when this wizard completes.
14. Click Finish. The workload creates and displays in the Script View.