Chat now with support
Chat with Support

Benchmark Factory for Database 8.4 - 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

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

  1. 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.
  2. 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. See Data Repository Migration Wizard for more information.

 

 

Data Repository Migration Wizard

The Data Repository Migration Wizard allows you to migrate the Benchmark Factory testing repository from one database type to another. For example, from the default SQLite database to a Microsoft SQL Server database.

For information about using the Command Line to run the Data Migration Wizard, see Migrating Repository Data Using the DOS Command Line.

To use the Data Repository Migration Wizard

  1. To open the wizard from the Benchmark Factory application, select Tools | Repository Data Migration.
  2. When the Data Migration Wizard opens, click Next.

  3. In the Choose a Data Source page, select the data source name for the database from which you want to migrate Benchmark Factory data.
    • To migrate data from the default SQLite database installed and used with any new installation of Benchmark Factory 7.2 or later, select Default SQLite.

      Note: The option to use a default SQLite database was also available in Benchmark Factory 7.1.1 or earlier.

  4. Enter the user name and password, if necessary (for example, if migrating from a non-default database). Click Next.
  5. In the Choose a Destination page, select the data source name of the database to which you want to migrate the data.
  6. Click Next. The Data Migration Wizard completion dialog displays.
  7. Click Finish.

 

 

Troubleshooting

Support Bundle

You can create a Support Bundle and send it to Quest Support for review. To help troubleshoot problems, the support bundle contains information such as:

  • BMF version number
  • Settings
  • License information (just send the key files)
  • Error Logs and Result Logs from the associated directories
  • Files located in the data directory. This will be not only the xml files for imported users scenarios, but also dump files.
  • Script files XML configuration files
  • A file that contains hardware information about the system running on it as well as the output of the agents configurations from the repository
  • Information about versions of all loaded .dlls

To create a Benchmark Factory support bundle

  1. Select Help | Support Bundle to open the Support Bundle dialog.
    • To create a support bundle for a single job, select the job in the Jobs View pane before opening the Support Bundle dialog.
  2. In the Support Bundle dialog, select the modules you want to send.
  3. If creating a support bundle for a single job, select Just for selected job.
  4. Then do one of the following:
    • To save the bundle, click the Save icon . Then select a location in which to save the zipped file.
    • To email the bundle to Support, click Email Quest Software Support.
    • To contact Support via the Support Portal, click Quest Support.

    By default, the support bundle is created and saved in the following location:

    C:\Users\<user name>\My Documents\My Benchmark Factory\<version number>\BMFSupportBundle.zip.

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating