Benchmark Factory for Database 9.0 - User Guide

SQL Scalability Testing from Toad

Note: To run SQL Scalability testing from Toad you must have Benchmark Factory installed. The Benchmark Factory console does not have to be open to run SQL Scalability testing.

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 Benchmark Factory SQL Scalability testing

Creating the SQL tuning connection

To create the SQL Turning connection

1. In Quest Central or Toad for Oracle, 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 Testing

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.
3. Test All for Scalability-Tests all SQL statements.
4. Test Selected for Scalability-Tests the selected SQL statements.

2. The Benchmark Factory SQL Scalability dialog displays. Click Next. The Measurement Interval dialog 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. The Real World Latencies dialog 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 test 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:

Overview Tab

Transactions

Summary

Messages

Test Database Scalability

To test SQL Scalability, select one of the following:

• Create SQL Scalability Test
• Test Stored Procedures for Scalability

To test a system using standard benchmark tests, see the following:

• Create Industry Standard Benchmark Test

Settings

About

Use the Settings dialog to specify or view the default settings Benchmark Factory uses when you create a new job. Changes to these settings affect only new jobs, not existing jobs.

To specify Benchmark Factory settings

1. Select Edit | Settings. The Settings dialog opens.
2. Select a category from the list in the left pane. You can specify settings for the following:
   • General Settings
   • Benchmarks Settings - General
   • Benchmark Settings - Specific Test Types
   • Timing Settings
   • User Load Settings
   • Latency Settings 
   • Error Handling Settings
   • Repository Settings
   • Statistics Settings
   • Agent Settings
   • Oracle Settings
   • SQL Server Settings
   • Execute File Settings
   • REST API Settings