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

How Benchmark Factory Works

The following steps provide an overview of how Benchmark Factory components interact during the load testing process.

  1. The Benchmark Factory Console implements the workload testing process and controls one or more distributed agent machines. Each agent machine can simulate thousands of users. Each simulated user executes transactions and records statistics.
  2. Benchmark Factory About Agents machines simulate virtual users. The Agents send transactions to the system-under-test. The Agents record statistics that includes how much data the resulting transaction contained and how long it took to get the results. At the end of an iteration, each agent machine reports its findings back to Benchmark Factory.
  3. A server (system-under-test) is the database Benchmark Factory connects to. Benchmark Factory is server neutral and network protocol independent. Benchmark Factory uses vendor client libraries of the system-under-test. Any system that the client software can support, Benchmark Factory can support. Its only requirement is that Agent machines must be able to connect to a server through an appropriate manner and it supports the test system.
  4. The Repository Manager stores all testing data.
  5. Results are viewed from Run Reports.

                                 

         

Feature/Edition Comparison

Review the following table for a comparison of features available in the commercial and freeware editions of Benchmark Factory.

Feature Freeware Edition Commercial Edition
Default maximum virtual user load (without additional virtual users packs) 20 100
Additional virtual user packs (unlimited)
SQL Optimizer Integration
Oracle Capture and Replay
SQL Server Capture and Replay
Maximum number of transactions that can be run during a load test/user scenario 20 Unlimited
Scaling factors for standard benchmarks (AS3AP, TPC-B, TPC-C, TPC-D, and Scalable Hardware) Lowest two scaling factors for each benchmark All are available
Repository database types Only the default SQLite repository is enabled The following repository database types are supported: Oracle, Microsoft SQL Server, SAP SQL Anywhere (Adaptive Server Anywhere), MySQL, and SQLite
BMFServer.exe
Support

Technical support from Quest is not available for the Freeware edition.

For the Commercial edition, support from Quest is available at: https://support.quest.com

= Available

= Not available

Get the latest product information and find helpful resources at the Benchmark Factory community at: https://www.toadworld.com/products/benchmark-factory-for-databases

  

Benchmark Factory Components

Benchmark Factory Console

The Benchmark Factory console implements the database workload testing process. This interface is where:

The Benchmark Factory Console contains the following views:

 

 
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating