Chat now with support
Chat with Support

Benchmark Factory for Database 9.0 - User Guide

Welcome to Benchmark Factory What's New in Benchmark Factory Additional Resources Overview of Benchmark Factory Benchmark Factory Components Licensing Getting Started - the Benchmark Factory Workflow Agents Create and Edit Connections Create and Edit Tests and Jobs
Jobs View Pane Job Wizards Quickstart: Create a New Job Edit a Job Industry Standard Benchmark Tests Capture and Replay a Workload Artificial Test for Desired Effect Scalability Tests Custom Tests Create/Delete Benchmark Objects Execute External File Test Options for Create Objects Test Options for Transactions Job Setup Options Use Global Search/Replace Save Job as BMF Script Copy Test to Replay, Mix, Goal, or Scalability Test
Benchmarks How Do I... Settings Test Results and Run Reports BFScripts Repository Troubleshooting The Benchmark Factory REST API Appendix About Us Adding Virtual Users System/Upgrade Requirements/Supported Databases Shortcut Keys

$BFNextUserload

Description:

Returns the next user load for the load scenario running.

Parameters:

N/A

Syntax:

$BFNextUserload()

Example:

$BFNextUserload()

When running with userloads 1, 4, 6, 10 this will return "6" when running at userload 4.

 

$BFPrevUserload

Description:

Returns the previous user load for the load scenario running.

Parameters:

N/A

Syntax:

$BFPrevUserload()

Example:

$BFPrevUserload()

When running with userloads 1, 4, 6, 10 this will return "4" when running at userload 6.

 

Repository

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

  1. Select Edit | Settings. The Settings dialog opens.

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