Scalability Test
3. Press Enter. The script displays
4. Type in parameters as required.
SQL Scalability Wizard
SQL Scalability Wizard
Note: To run the SQL Scalability Wizard from Toad you must have Benchmark Factory loaded.
The Benchmark Factory console does not have to be open to run the SQL Scalability Wizard.
Overview
The SQL Scalability test allows you to execute SQL statements, letting users spot potential issues not seen with a single execution. Users can run variations of a SQL statement generated by SQL Tuning in order to find the SQL that will perform the best under a load test.
Creating a SQL Scalability load scenario requires the following steps.
1. Creating the SQL tuning connection 2. Entering the desired SQL statement
3. Running the statement using the in Benchmark Factory SQL Scalability Wizard
Creating the SQL tuning connection To create the SQL Turning connection
1. In Quest Central or Toad, connect to an Oracle or SQL Server database.
2. From the Quest Central main toolbar select Tools|SQL Tuning to launch.
Entering the desired SQL statement To enter the desired SQL statement
1. Enter the desired SQL statement in SQL Text.
2. Click the Optimize Statement icon. Clicking this icon executes multiple syntax transformation rules to produce a list of semantically equivalent SQL statements.
Running the SQL statement using the in Benchmark Factory SQL Scalability Wizard
1. Click the Benchmark Factory drop-down icon and select the desired option. Three options are provided:
2. Test for Scalability-Tests the currently displayed SQL.
2. The Benchmark Factory SQL Scalability Wizard displays. Click Next. TheMeasurement Intervaldialog displays.
3. Enter the desired user load.
4. Click Next. The Iteration Length dialog displays.
5. Enter the desired number of executions per iterations or executions per iteration.
6. Click Next. TheReal World Latenciesdialog displays.
7. Select the desired latency.
8. Click Next. The connection information dialog displays.
9. Enter the connection parameters.
10. Click Next. The Connection Agent dialog displays. Benchmark Factory Agent(s) reside on each physical client machine and spawn multiple virtual-user sessions. Each Agent generates an information screen with tabs that contain a variety of Agent information.
Benchmark Factory can control hundreds of Agent machines.
11. If there are more than 20 users in your test, you will need to run an agent. Click Start Local Agent.
12. Click Next. The Benchmark Factory SQL Wizard completion dialog displays.
13. Click Finish. The SQL Scalability dialog displays. From this dialog, you can control, monitoring, and view SQL testing results. This dialog provides the following tabs and buttons:
OverviewTab
The Overview tabs provides transactions per second testing results for individual user loads and iterations.
Transactions
The Transactions view provides the following statistics on the SQL statements being run:
l Executions
l Rows
l Bytes
l Errors
l Average Transaction Time
l Minimum Transaction Time
l Maximum Transaction Time
2. Real-Time
The Real Time Statistics provides real-time graphs and raw data. This data allows you to spot system-under test issues that may be affecting server performance.
Right-clicking inside the graph displays a drop-down that allows you to change graph settings and view.
Summary
The Summary graph provides real-time and raw data summary graphs. The Summary graph displays real-time counter data. Right-clicking inside the graph displays adrop-downthat allows you to change graph settings and view.
Messages
The Output window displays messages about the job being run.
4. Benchmark Factory-Launches the Benchmark Factory for Databases console.
5. Run Reports-Launches Benchmark Factory Reports.
Submit Job Dialog
Submit Job Dialog
A job contains load scenario, execute file, creation/deletion of benchmark objects, or a
combination of each. The Submit Job Wizard walks you through the process of adding a job to the jobs queue. See "Jobs Queue View" (page 39) for more information.
To submit a job to the Jobs Queue
1. Select the Job node.
2. Right-click.
3. Select Submit Job. The Submit Job dialog displays.
The Submit Job dialog allows you to tailor your job needs and provides the following options:
Section Description
Profile Allows you to select profiles already created.
Displays the Profile Creation Wizard. See
"Profile Creation Wizard" (page 175) for more information.
Displays the Profile setting dialog. See
"General Tab" (page 144) for more information.
Actions Allows you to:
Run Job: Submits the job to the queue and runs the job.
Run Job when queue becomes idle: Submits the job to the jobs queue and puts it in a ready state so that it will run when the currently ready or running job completes.
Run Job per schedule: Submits the next job scheduled.
Start Agent and Run Job: Starts the agent and runs the job.
Start Agent and Run Job when queue becomes idle: Starts the agent and runs the job when all previous jobs have finished.
Start Agent and Run Job per schedule: Starts the agent and runs the next job scheduled.
No action: Closes the dialog after you select Submit.
Comments Allows you to add a comment to the job.
Alerts Allows you to send an email, pager, or net-send operator alerts when the job completes.
Job Counters Allows you to addJob Countersto the job.
Stop job after first error
When checked, the job will stop if an error is encountered.
4. After filling in the desired parameters, click Submit.