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 |
Execute By—Select one of the following options:
User Startup—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.
The Test Stored Procedures for Scalability test 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.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center