Benchmark Factory for Database 9.0 - User Guide

Replay Load from SQL Server Trace Table

Benchmark Factory allows you to import SQL from a SQL Server trace table. This allows you to replay your database activity with the same timing as was originally captured on an existing in-house SQL Server database application.

The resulting workload contains a user scenario consisting of the sequence of captured SQL transactions.

Before importing SQL from a SQL Server trace table, use SQL Profiler to save the SQL trace as a trace table. See the following topics for more information:

• Create a SQL 2005 Trace Table Using the SQL Server Profiler
• Creating a SQL 2008/2008 R2 Trace Table Using the SQL Server Profiler

To import a workload from a SQL Server trace table

1. In the New Job or Edit Job Wizard, click Workload in the left pane.
2. On the workload page, select Capture / Replay Test from the drop-down list.
3. Select Replay load from SQL Server trace table.
4. Click the Select Test button.
5. In the SQL Server Authentication dialog, enter the host name and connection information for the database containing the trace table to import.
   • To instruct Benchmark Factory to search for available hosts, click Refresh. Then select a host from the list.
6. Click Next.
7. Select a database from the Select a Database drop-down list.
8. Select a table from the Select a Table drop-down list.
9. Click Next. The SQL Server Trace Processing dialog displays.
10. Click Finish. The test is added to the workload and the test Summary page displays.
11. On the Summary page, click each link to go directly to that option to modify it.

12. To jump to the Test Options tab, click Test Options at the bottom of the Summary page. Review the following for more information:

    Tab	Description
    Transactions tab	Modify the transactions and the transaction mix for the test. For a custom test, add transactions. See Transactions Tab for more information.
    Options tab	Enable scaling for the user scenario. See Options Tab (Capture/Replay) for more information.
    Timing tab	User Startup—Select one of the following options: Start all users as quickly as possible—Starts all users immediately after a test begins. Start all users at even intervals for—Sets the amount of time in which to start all users at even intervals. The interval duration is equal to this value divided by the number of users. Start a new user every [n] seconds—Starts a new user, then waits the [n] number of seconds before starting the next user.
    Advanced tab	Specify Repository options, error handling, and connect/disconnect options for the test. See Advanced Tab for more information.

13. 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.

Replay Load from ODBC Trace File

Benchmark Factory allows you to import SQL from an ODBC trace file generated by the ODBC Data Source Administrator. This allows you to load test your database using workloads from an existing in-house ODBC database application.

The resulting workload contains a user scenario consisting of the ordered sequence of captured SQL Transactions from the ODBC trace.

See Creating an ODBC Trace File for instructions on how to create an ODBC trace file.

To import an ODBC trace file

1. In the New Job or Edit Job Wizard, click Workload in the left pane.
2. On the workload page, select Capture / Replay Test from the drop-down list.
3. Select Replay load from an ODBC trace file.
4. Click the Import Test button.
5. Browse to and select the ODBC trace (log) file to import.
6. Click Next. The ODBC Trace Processing dialog opens. When the processing is finished, the number and types of SQL extracted from the file displays.
7. Click Finish. The test is added to the workload and the test Summary page displays.
8. On the Summary page, click each link to go directly to that option to modify it.

9. To jump to the Test Options tab, click Test Options at the bottom of the Summary page. Review the following for more information:

   Tab	Description
   Transactions tab	Modify the transactions and the transaction mix for the test. For a custom test, add transactions. See Transactions Tab for more information.
   Options tab	Enable scaling for the user scenario. See Options Tab (Capture/Replay) for more information.
   Timing tab	User Startup—Select one of the following options: Start all users as quickly as possible—Starts all users immediately after a test begins. Start all users at even intervals for—Sets the amount of time in which to start all users at even intervals. The interval duration is equal to this value divided by the number of users. Start a new user every [n] seconds—Starts a new user, then waits the [n] number of seconds before starting the next user.
   Advanced tab	Specify Repository options, error handling, and connect/disconnect options for the test. See Advanced Tab for more information.

10. 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.

Import from Delimited Text File

Benchmark Factory allows you to create a workload (or add to a workload) by importing SQL from a delimited text file. This allows you to load test your database using workloads from existing in-house generic database applications.

To Import from a Delimited Text File

1. In the New Job or Edit Job Wizard, click Workload in the left pane.
2. On the workload page, select Capture / Replay Test from the drop-down list.
3. Select Import from a Delimited Text File.
4. Click the Import Test button.
5. In the Text File Input dialog, browse to and select a file. Click Next.
6. In the Select File Format page, select the desired format (Delimited or Fixed field).
   • If you selected Delimited, select  the desired row delimiter, text qualifier, and rows to skip.
   • If you selected Fixed Field, select the desired row delimiter and rows to skip.
7. Click Next.

8. If you selected Delimited, the Specify Column Delimiter page opens. Select delimiter options.

   Note: Only the first 20 rows of the file display.

9. If you selected Fixed field, the Fixed Field Column Positions page opens. Configure the column or columns.

   Note: Only the first 20 rows of the file display.

10. Click Finish.The test is added to the workload and the test Summary page displays.
11. On the Summary page, click each link to go directly to that option to modify it.

12. To jump to the Test Options tab, click Test Options at the bottom of the Summary page. Review the following for more information:

    Tab	Description
    Transactions tab	Modify the transactions and the transaction mix for the test. For a custom test, add transactions. See Transactions Tab for more information.
    Options tab	Enable scaling for the user scenario. See Options Tab (Capture/Replay) for more information.
    Timing tab	User Startup—Select one of the following options: Start all users as quickly as possible—Starts all users immediately after a test begins. Start all users at even intervals for—Sets the amount of time in which to start all users at even intervals. The interval duration is equal to this value divided by the number of users. Start a new user every [n] seconds—Starts a new user, then waits the [n] number of seconds before starting the next user.
    Advanced tab	Specify Repository options, error handling, and connect/disconnect options for the test. See Advanced Tab for more information.

13. 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.

Import from Oracle Dynamic Performance View

Benchmark Factory allows you to import SQL from Oracle Dynamic Performance Views. This allows you to import SQL transactions identified by the Oracle for further testing under a load.

The resulting workload is a mixed workload containing either the most-often executed, the most time-consuming, or the most-recently executed SQL transactions.  

To import from the Oracle Dynamic Performance Views

1. In the New Job or Edit Job Wizard, click Workload in the left pane.
2. On the workload page, select Capture / Replay Test from the drop-down list.
3. Select Import from Oracle Dynamic Performance View.
4. Click the Import Test button. The Oracle DPV Connection dialog opens.
5. Enter the connection information and click Next. The Oracle DPV Import dialog opens.
6. Select the type of SQL statements to import.
7. Select the maximum number of SQL statements to return.

8. Deselect the Include system activity (SYS USER) option to exclude system activity.

   Note: It is not recommended to include system activity. Including it imports Oracle SQL statements routinely run by Oracle for maintenance reasons, and is not required for the load testing process.

9. Click Finish. The test is added to the workload and the test Summary page displays.
10. On the Summary page, click each link to go directly to that option to modify it.

11. 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. See Transactions Tab for more information.
    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.

12. 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.