The Jobs View displays a list of saved jobs, shows which jobs are currently running, and which jobs are scheduled to run.
From the Jobs View pane, you can run jobs, view job status, and view real-time testing results.
To run a job
To view test results
To edit an existing job
From the Jobs View pane, you can view job status.
The following job states are identified:
The Jobs View toolbar provides user functionality to save or delete jobs.
|
Move the selected test up in the list. |
|
Move the selected test down in the list. |
Delete the selected item from the Jobs View. | |
Toggles tree-view on and off. |
Note: To save a job as a Benchmark Factory script, select the job and click Save in the Benchmark Factory toolbar or select File | Save.
Use the New Job Wizard to create a new job. The New Job Wizard guides you through the process of creating a database load test (workload), as well as selecting a database to test, setting general job options, and specifying agents.
Navigating the New Job Wizard is easy. The three major steps are displayed in the left pane: Database Under Test, Workload, and Agent. The individual tests you add are displayed under the Workload step. Click on a step or test in the left pane to display the available options and properties in the right pane.
To allow the wizard to guide you through each step, after completing a page click the green arrow at the bottom of the page. This will advance you to the next step. For example, after selecting a connection on the first page of the wizard, click .
To create a new job
Click inside the checkbox to the left of the agent name to select it. A checkmark displays for each selected agent. See About Agents for more information.
Note: When you run a job using one or more local agents, if Agent utilization of resources on the local machine is too high, errors could occur.
After specifying the test-level and job-level options, you can save the job, run the job, or schedule the job. Review the following:
Notes:
Use the Edit Job Wizard to modify an existing job.
To edit a job
This test type allows you to create load scenarios from one of the following industry standard benchmark tests: TPC-C, TPC-E, TPC-H, AS3AP, Scalable Hardware, TPC-B, or TPC-D. Each of these tests includes the steps to create/load all the required benchmark objects needed to execute the standard benchmark workloads. These synthetic workloads can be used when no real-world data is available to import for database load testing.
This test type also allows you to create a workload using the Benchmark Factory Replication test.
For more information, including a description of each of the standard benchmark tests included in Benchmark Factory, see Overview of Benchmark Testing.
To create an Industry Standard Benchmark test
Then select the type of benchmark test you want to use. Select each test to display a description in the lower pane.
Summary tab. The Summary tab provides a summary of the job and the workload, as well as links to the commonly edited options for this test. Click each link to navigate to the applicable tab where you can edit that option. Options shown in red are required. Review the following for additional information:
Scale | Click to change the scale factor for this test/step. In the Benchmark Scale field, specify a scale factor. See Benchmark Scale Factor for more information. |
Size |
Displays the total size of all objects in this Create Objects step. Click to open the Scale tab where you can modify the database size or the scale factor. See Benchmark Scale Factor for more information. |
Number of Tables | (Replication test only) Displays the number of tables to create. Click to modify the number of tables, the number of columns in a table, and the data types to create. See Replication Table Options Tab for more information. |
Transactions | Displays the number of transactions. Click to modify the transaction mix for the transaction step. See Transactions Tab for more information. |
User Load | Displays the user load—the number of virtual users per test iteration. Click to review or modify the user load. See Specify User Load for more information. |
Length | Click to modify the timing for this test. See Timing Tab for more information. |
Create Objects - More Options. To specify more options for the Create Objects step, select the Create Object for test step in the left pane. Then select the Test Options tab. Review the following for additional information:
Scale tab | See Benchmark Scale Factor. |
Options tab | Use the Options tab to specify some general options for this step, such as specifying the number of agents to use to load data. See Options Tab (Create Objects Step). |
Custom Creation SQL tab | Use the Custom Creation SQL tab to customize the SQL used to create objects in this step. See Customize SQL for Creating Objects. |
Transaction Mix - More Options. To specify more options for the Transaction Mix step, select the test Transaction Mix step in the left pane. Then select the Test Options tab. Review the following for additional information:
Transactions tab | See Transactions Tab. |
User Load tab | See Specify User Load. |
Timing tab | See Timing Tab. |
Advanced tab | See Advanced Tab. |
After specifying the test-level and job-level options, you can save the job, run the job, or schedule the job. Review the following:
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center