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

Welcome to Benchmark Factory

Benchmark Factory® is a database performance testing tool that allows you to conduct database workload replay, industry-standard benchmark testing, and scalability testing.

For additional instructional information on Benchmark Factory, please visit the Benchmark Factory Toad World Community at https://www.toadworld.com/products/benchmark-factory-for-databases.

Review the following topics for a quick overview of Benchmark Factory.

 

 

What's New in Benchmark Factory

New Features in 8.4

Benchmark Factory 8.4 is a minor release and includes the following new features and enhancements. For a list of resolved issues in this release, see the Benchmark Factory 8.4 Release Notes at the Quest Support Portal.

Database Support

This release of Benchmark Factory includes support for the following database versions:

  • SQL Server 2019

Secure the REST API

  • Only support HTTPS
  • Add Authentication for External host to Access REST API

Benchmark Factory server supports TLS1.2 and later version, it will generate self signed certificate. The default setting for REST API is just for Local access. Start with Local Access to REST API.

If the external host wants to access Benchmark Factory server through REST API, the request header need to add Authentication. How to Allow external host access REST API

 

New Features in 8.3

Benchmark Factory 8.3 is a minor release and includes the following new features and enhancements. For a list of resolved issues in this release, see the Benchmark Factory 8.3 Release Notes at the Quest Support Portal.

Microsoft SQL Server Support

The Benchmark Factory Agent for Linux can now be used when testing against the following database types (in addition to PostgreSQL, Oracle and MySQL):

  • Microsoft SQL Server
  • Microsoft SQL Server. If using the Benchmark Factory Agent for Linux to test against a Microsoft SQL Server database, ensure the unixODBC and msodbcsql Client are installed on the same Linux machine as the Agent. Installing the Microsoft SQL Server ODBC Driver, see Installing the Microsoft ODBC Driver for SQL Server on Linux and macOS.

Database Support

This release of Benchmark Factory includes support for the following database versions:

  • Oracle 19c

Enhancements to the Benchmark Factory

  • Benchmark Factory Agent for Linux. You can now gather CPU and Memory from the Benchmark Factory Agent for Linux. This display in Benchmark Factory Main window Bottom Agent panel.
  • REST API. You can now use URL(api/jobs/tests/testindex/currentresult) to get current results of the test results are same as they display in UI.

 

New in Benchmark Factory 8.2.1

Benchmark Factory 8.2.1 is a minor release and includes resolved issues. For a complete list, see the Benchmark Factory 8.2.1 Release Notes at the Quest Support Portal.

New Features in 8.2

Connections

MySQL Native Connection. Beginning with this release, Benchmark Factory now provides the ability to create a MySQL connection using Native database connectivity.

  1. To create a MySQL Native connection, click the New Connection button in the main toolbar. Then select MySQL from the Database Type drop-down list.
  2. Select the Native tab in the New Connection dialog and enter the connection information.

Note: The following Benchmark tests are supported: TPC-C, TPC-E, and TPC-H.

Database Support

This release of Benchmark Factory includes support for the following database versions:

  • Oracle 18c
  • MySQL 8.0

Enhancements to the Benchmark Factory Agent for Linux

In release 8.1, Benchmark Factory introduced an agent which you can deploy in your Linux environment. Benchmark Factory 8.2 includes several significant enhancements to the Agent for Linux.

Automatically Install Remote Agent on Linux

You can now install an agent on a remote Linux machine through the Benchmark Factory Console. This provides an easy, UI-based method for installing a remote agent on a Linux platform.

  1. To install an agent on Linux through the console, select Edit | Settings | Agent. Then click Setup New User Agent.
  2. Select Linux and click OK. Enter the name or IP address and the connection information for the remote Linux machine on which you want to install the agent. If no agent is found, you are prompted to install one. Click Yes to automatically install an agent for Linux.
  3. After the agent is successfully installed, you can select it from the list of available agents.

Installation Package

The Benchmark Factory Agent for Linux is now distributed as an RPM package. This provides a number of advantages over the previous archive file (.tar) format. This format allows BMF to provide automatic installation through the Benchmark Factory Console. You can also use YUM to install the Benchmark Factory Agent RPM package on Linux manually.

To download the RPM package for manual installation, go to https://bintray.com/quest/bmfrepo. For additional information, see "Install Remote Agent on Linux" in the Benchmark Factory Help. For best results, install the Agent for Linux automatically through the Benchmark Factory Console.

Oracle and MySQL Support

The Benchmark Factory Agent for Linux can now be used when testing against the following database types (in addition to PostgreSQL):

  • Oracle
  • MySQL

Oracle. If using the Benchmark Factory Agent for Linux to test against an Oracle database, ensure an Oracle Client is installed on the same Linux machine as the Agent. Review the following details:

  • The Oracle Client and Oracle Instant Client, versions 10g R2 and later, are supported.
  • If you use a version of the Oracle Instant Client later than 10g R2, you must create a symbolic link to the shared library for the Oracle Instant Client you intend to use.
  • Additional Information—For additional prerequisites and more-detailed information, see "Install Remote Agent on Linux" in the Benchmark Factory Help.

Note: The features described in the New in This Release section apply to the commercial version of Benchmark Factory and may not be available in the freeware edition.

Thursday, August 6, 2020

 

 

Additional Resources

Learn More and Connect with the Community

Use the following links to videos, blogs, and community resources to learn more about Benchmark Factory, to find answers to questions, and to advance your knowledge through Benchmark Factory tips and tricks.

 

 

Overview of Benchmark Factory

Self Service Tools
Knowledge Base
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
RSS Feed
Contact Us
Licensing Assistance
Technical Support
View All
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating