Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

Benchmark Factory for Database 7.6 - User Guide

Table of Contents

Getting Started

Getting Started With Benchmark Factory What's New in Benchmark Factory

Overview of Benchmark Factory

About Benchmark Factory Benchmark Factory Components Understanding Benchmark Testing Understanding Benchmark Factory Terminology How Benchmark Factory Works

Benchmark Factory Components

Benchmark Factory Console Agents Run Reports Repository Manager Jobs View

About Agents Agent Settings Install Remote Agents Run Benchmark Factory with Multiple Agents Test Status Tab Virtual Users Tab Transactions Tab Output Tab Configure Firewall - Remote Agent Install

About Connections Create Oracle Connection Create Microsoft SQL Server Connection Create SAP Connection Create MySQL Connection Create ODBC Connection Create IBM DB2 CLI Connection Edit/Manage Connections Timeout and Reconnect Options Environment Information Performance Counters Oracle Statistics Collection Oracle Clustering Options Configure RAC Load Testing

Create and Edit Tests and Jobs

Jobs View Pane Quickstart: Create a New Job Edit a Job Industry Standard Benchmark Tests Replication Benchmark Test Capture and Replay a Workload

Capture and Replay Oracle Workload Capture and Replay SQL Server Workload Run Capture Scenario Wizard Run Capture Wizard from Cmd Line Replay Load from an Oracle Trace File Replay Load from SQL Server Trace Table Replay Load from ODBC Trace File Import from Delimited Text File Import from Oracle Dynamic Performance View Import from Dell Tools Export File

Create Artificial Test for Desired Effects Test Stored Procedures for Scalability Test SQL for Scalability Custom Tests

Create Mix Test Create Replay Test Create Goal Test Create Scalability Test

Create/Delete Benchmark Objects Execute External File Test Options - Create Objects

Benchmark Scale Factor Options (Create Objects) Create Objects Using Custom SQL Table Options (Create Objects for Replication)

Test Options - Transactions

Transactions User Load Timing Advanced Options (Capture/Replay) Add SQL Transactions Use BFScript Wizard Run SQL Preview Latency Stagger User Startup

Job Setup Options

Schedule Alerts Performance Counters Global Variables

Replace Child Latencies Use Global Search/Replace Save Job as BMF Script Copy Test to Replay, Mix, Goal, or Scalability Test

Test Results and Run Reports

Overview View Real-Time Test Results

View Test Results - Running Job Realtime Statistics Tab Run vs Userload Tab Transaction vs Load Tab Changing Graph View

View Test Results - Completed Job Benchmark Factory Run Reports

Overview Changing Graph View Run Reports Viewer Using Benchmark Factory Run Reports Viewing Multiple Run Results

Exporting Test Results to Excel Exporting Test Results to Excel Using the Command Line Benchmark Factory Test Results Terminology

Troubleshooting

Support Bundle Agent Connection

Licensing and Keys Adding Virtual Users

Jobs Job Tests Test

Repository Settings

Note: If you create a new repository in Benchmark Factory 5.5 or later, 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 all test results 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. 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: 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.

If you plan to store a large amount of test data in the repository, you might want to consider using a more robust database than SQLite.

The Repository Settings page allows you to edit the DSN, perform ODBC administration, and test the connection. Benchmark Factory also provides a Repository Manager and Data Repository Migration wizard to assist you with other repository management functions.

Note: If the database structure does not exist on the selected database, Benchmark Factory prompts you to create the structure.

The supported database types are:

MySQL
SQL Server®
SQLite
SAP SQL Anywhere® (Adaptive Server® Anywhere)
Oracle®

To specify Repository settings

Select Edit | Settings. The Settings dialog opens.

Select Repository. Review the following for additional information:

Data Source Name	Data Source name of the ODBC connection used to connect to the repository database.
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	Click to edit the selected Data Source Name.
ODBC Administrator	Click to open the ODBC Data Source Administrator dialog. Use this to add a DSN or ODBC connection.
Test Connection	Tests the defined connection.
Data Migration	Click to open the Data Migration Wizard. See Data Repository Migration Wizard for more information.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating

© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center