You can run the Capture Scenario Wizard as a standalone application to capture an Oracle or SQL Server workload. Then replay the workload in Benchmark Factory. This utility provides an easy way for you to capture your database workloads without requiring the installation of Benchmark Factory.
After a workload is captured, the capture files can be distributed to others to replay and test in Benchmark Factory.
This utility is the same Capture Scenario Wizard that opens from the New Job Wizard in Benchmark Factory and it produces the same type of capture and export files.
Oracle or SQL Server Capture. The following is required to run the Capture Scenario Wizard to capture any workload:
Oracle Capture. The following is required to run the Capture Scenario Wizard to capture an Oracle workload:
To run the Capture Scenario Wizard standalone application
Navigate to the Benchmark Factory application directory where Benchmark Factory is installed and open the bin directory.
For example, C:\Program Files (x86)\Quest Software\Benchmark Factory 7.5.0\bin
To start the Capture Scenario Wizard from the command line, see Run the Capture Wizard from the Command Line.
You can use the command line to start and run the Capture Scenario Wizard.
When running the Capture Scenario Wizard from the command line, you can specify the following parameters:
Parameter | Description |
---|---|
-? | Displays Help |
-O | -S |
Specifies the database type for the capture. -O performs an Oracle capture.
-S performs a Microsoft SQL Server capture.
These parameters are ignored when used with another parameter. If you do not specify a capture database type (Oracle or SQL Server), the Capture Scenario Wizard prompts you to select one. |
-V |
View the status of the capture for the capture project file specified (*.mse or *.cpj).
|
-D |
Deletes a capture. Specify the capture project file to delete (*.mse or *.cpj). Deletes the project file and the capture files. You cannot delete a running capture.
|
-C |
Starts a new capture using the values in the specified capture project file (*.mse or *.cpj). Does not overwrite the specified capture.
|
Note: The parameters -V, -D, and -C cannot be used at the same time and must have a capture project file location specified.
Benchmark Factory allows you to import the SQL contained within an Oracle trace file. The resulting workload contains a user scenario consisting of the timed event sequence of captured SQL transactions.
Importing an Oracle Trace file allows you to replay your database activity with the same timing as was originally captured on an existing in-house Oracle database application.
Note: To create an Oracle trace file which includes bind parameters, a level number of 4 must be used. For example, to start an Oracle trace for a user session, use the following command:
ALTER SESSION SET EVENTS '10046 trace name context forever, level 4'
To import an Oracle trace file
When you finish inputting files, click Next. The Oracle Trace Activity dialog opens.
Include system activity—Select to include system activity (SYS USER).
Note: It is not recommended to include system activity (SYS USER). This imports Oracle SQL statements routinely run by Oracle for maintenance reasons and is not required for the load testing process.
If the trace import file exceeds the Benchmark Factory limit for displaying individual transaction, the following dialog displays:
If you click Yes, the trace file import continues. Individual SQL is converted to .xml files. You can then edited the .xml files in the Benchmark Factory Session Editor.
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. |
Options tab | Enable scaling for the user scenario. See Options Tab (Capture/Replay) for more information. |
Advanced tab |
Specify Repository options, error handling, and connect/disconnect options for the test. 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.
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:
To import a workload from a SQL Server trace table
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. |
Options tab | Enable scaling for the user scenario. See Options Tab (Capture/Replay) for more information. |
Advanced tab |
Specify Repository options, error handling, and connect/disconnect options for the test. See Advanced Tab for more information. |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Términos de uso Privacidad Cookie Preference Center