Benchmark Factory for Database 9.0 - User Guide

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.

• About Benchmark Factory
• Understanding Benchmark Factory Testing
• Understanding Benchmark Factory Terminology
• How Benchmark Factory Works
• The Benchmark Factory Environment
• Getting Started - the Benchmark Factory Workflow

What's New in Benchmark Factory

Database Support

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

• Oracle 21c

• SQL Server 2022

• PostgreSQL 11, 12, 13, 14, 15, 16

• MariaDB 10.x, 11.x

• MySQL 8.0.36

• IBM® DB2® for z/OS 12, 13

Operating System Support

Windows operating system:

• Microsoft Windows 11

• Microsoft Windows Server 2022

Linux operating system:

• CentOS 8.x, 9.x (64-bit)

• RHEL 8.x, 9.x (64-bit)

• Oracle Linux 8.x, 9.x (64-bit)

Cloud support:

• AWS RDS platform for MySQL, MSSQL, and MariaDB

• Azure SQL database

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.

Wednesday, April 3, 2024

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.

• Benchmark Factory Community—Ask questions, join the discussion, find useful resources, and join the Beta program (when available).
• Product Documentation (Support Portal) —Find documents for current and past releases, as well as documents for other Toad products, on the Quest Support Portal.
• Benchmark Factory blogs—Find How To's, useful articles, and tips and tricks for using Benchmark Factory.
  • How to use the REST API (part 1)—Learn how to use the Benchmark Factory REST API.
  • How to use the REST API (part 2)—Learn how to modify an existing job or connection using the REST API.
  • REST API—This page lists the Benchmark Factory REST API resources and includes example request and response content.
  • Sample Powershell script usingREST API—This sample PowerShell script demonstrates some basic functionality of the Benchmark Factory REST API.
  • Benchmarking Best Practices—10 best practices to help you get started with database benchmarking.
  • Project Converter—Use this tool to convert an Oracle capture project file created in an earlier version of Benchmark Factory to .xml format.
• Toad World—Visit other Toad Communities, including Toad for Oracle. Find DBMS and SQL knowledge, find software downloads, and find answers to your database questions.
• Benchmark Factory Product Information—Find white papers, product demos, and purchasing information.

Overview of Benchmark Factory