Benchmark Factory allows you to design a workload based on a mixture of one of the following:
To create an artificial test for desired effect
The tests are added to the workload and the workload Summary page opens.
You can also select the Test Options tab. Each test/step in the workload may have a different set of options available in its Test Options tab. See the following for more information.
After specifying options for this test, you can add another test to the job, configure job setup options, save and close the job, run the job, or schedule the job. For more information about each of these steps, see Quickstart: Create a New Job.
Stored procedures enables developers who write stored procedures in Oracle and SQL Server to test performance and scalability of the logic under varying user load levels. Benchmark Factory allows you to import SQL from database stored procedures into a Mix Load Scenario (workload). This gives you the ability to import SQL transactions, from stored procedures, for further testing under load.
To test Stored Procedures for Scalability
Or you can select the Test Options tab to modify all test options. Review the following for additional information:
Tab | Description |
---|---|
Transactions tab |
Modify the transactions and the transaction mix for the test. |
User Load tab | Modify the number of users per test iteration. See Specify User Load for more information. |
Timing tab | Specify sampling, pre-sampling, and user start-up times for the test. See Timing Tab for more information. |
Advanced tab |
Specify Repository options, error handling, and database checkpoints for the test. You can also specify a file to execute at the beginning or end of each iteration. See Advanced Tab for more information. |
After specifying options for this test, you can add another test to the job, configure job setup options, save and close the job, run the job, or schedule the job. For more information about each of these steps, see Quickstart: Create a New Job.
The SQL Scalability test allows you to execute SQL statements, allowing users to spot potential issues not seen with a single execution. Users can run variations of a SQL statement in order to find the SQL that will perform the best under a load test.
Use this procedure to create a new SQL Scalability test or a Custom Scalability test.
To create a SQL Scalability Test
Or you can select the Test Options tab to modify all test options. Review the following for additional information:
Tab | Description |
---|---|
Transactions tab |
Add transactions for the test. |
User Load tab | Modify the number of users per test iteration. See Specify User Load for more information. |
Timing tab |
Select one of the following options:
|
Advanced tab |
Specify Repository options, error handling, and database checkpoints for the test. You can also specify a file to execute at the beginning or end of each iteration. See Advanced Tab for more information. |
After specifying options for this test, you can add another test to the job, configure job setup options, save and close the job, run the job, or schedule the job. For more information about each of these steps, see Quickstart: Create a New Job.
Custom tests allow you to create workloads from user provided SQL. These tests provide flexibility for your load testing requirements. The following customs load scenarios are provided:
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback 이용 약관 개인정보 보호정책 Cookie Preference Center