Run Reports
Benchmark Factory Run Reports is a separate executable that provides a comprehensive and detailed collection of database load testing results. With Benchmark Factory you can drill down into a database to view a wide array of information and statistics that gives you accurate insight into database performance. Run Reports Viewer allows you to access Benchmark Factory load testing results.
Note: Three instances of Run Reports can be viewed at one time.
Cutting and Pasting of Run Reports
From Benchmark Factory run reports you can cut and paste test results into the Clipboard.
Testing Server Throughput
Server throughput is the measurement of database capacity. Benchmark Factory allows you to view a variety of server throughput statistics that include:
- Transaction/Second (TPS)
- Transaction Time
- Bytes/Second (BPS)
- Rows/Second (RPS)
- Total Bytes
- Total Errors
- Total Rows
- Response Time
Testing SQL Scalability
The Benchmark Factory transaction comparison graph provides users with a comparison of the individual transaction performance as they compare to each other. This is most useful when analyzing a SQL Scalability test.
Testing Real Application Clusters
Benchmark Factory allows you to load test Oracle Real Application Clusters (RAC) to determine system capacity. The cluster performance graph allows users to view the performance of individual nodes.
Repository Manager
Note: If you create a new Benchmark Factory 5.5 (or later) repository, earlier versions of Benchmark Factory will not work against this repository.
The Repository is a database where all of the test results are stored. Benchmark Factory inserts test results into the repository and provides an easy way to access the data. By default, the Repository is a SQLite database that resides on the same machine as Benchmark Factory. The Repository can reside on another database server if required.
Note: By default in Benchmark Factory 7.1.1 or earlier, a MySQL database is created and used as the Repository, unless you selected the SQLite option during installation. In Benchmark Factory 7.2 or later, by default a SQLite database is created and used as the Repository.
To change the database, select the Data Source Name of the ODBC connection for the new database. To migrate data from one database to another, click Data Migration to open the Data Migration Wizard.
Note: If the database structure does not exist on the selected database, a prompt to create the structure will appear when OK is clicked.
The supported database types are:
- MySQL
- SQL Server®
- SQLite
- SAP SQL Anywhere® (Adaptive Server® Anywhere)
- Oracle®
To open the Repository Manager
- To open the Repository Manager from the application, select Tools | Repository Manager. Benchmark Factory prompts you to close the application. This is necessary before opening the Repository Manager.
-
The Repository Manager opens. Modify connection parameters or perform maintenance functions.
Review the following for additional information:
Connection Parameters Data Source Name
Data Source name of the ODBC connection used to connect to the repository database.
ODBC Driver
Current ODBC driver
User Name
The User Name used to log into the selected database.
Password
The Password associated with the user name used to log into the database.
Edit DSN
Displays the ODBC connection information dialog for the selected data source.
ODBC Administrator
Displays the ODBC Data Source Administrator dialog. Use this to add and edit ODBC connections.
Test Connection
Tests the connection of the currently selected ODBC Data Source.
Maintenance Create
Creates the repository objects on the selected database.
Delete
Deletes the repository objects on the selected database.
Warning: This will delete all test results stored in the Repository.
Data Migration
Launches the Data Migration Wizard.
Jobs View
The Jobs View displays a list of saved jobs, shows which jobs are currently running, and which jobs are scheduled to run.
From the Jobs View pane, you can run jobs, view job status, and view real-time testing results.
To run a job
- Select the job in the Jobs View pane and click
.
To view test results
- To view a job's test results, select a job in the Jobs View pane. Test results display in the right pane. See Benchmark Factory Console for an overview of the Benchmark Factory console.
- To compare two or more run results for a test, select the Compare Results tab. Use Ctrl+click to select multiple test runs. A comparison of the results for the various runs displays.
To edit an existing job
- To edit an existing job (to modify the workload or job setup options), select the job in the Jobs View pane and click
.
View Job Status
From the Jobs View pane, you can view job status.
The following job states are identified:
- Scheduled: All jobs currently waiting to run or scheduled to run at a future time.
- Running: Job currently running.
- Completed: All completed jobs.
Jobs View Toolbar
The Jobs View toolbar provides user functionality to save or delete jobs.
|
|
Move the selected test up in the list. |
|
|
Move the selected test down in the list. |
 |
Delete the selected item from the Jobs View. |
 |
Toggles tree-view on and off. |
Note: To save a job as a Benchmark Factory script, select the job and click Save in the Benchmark Factory toolbar or select File | Save.