Benchmark Factory
Visit shop.quest.com to buy this product online.
Buy online »
Toad World adds value to your Toad experience by providing free education and revealing new functionalities — along with
time-saving tricks and tips.
Visit the community »

White Paper

In this white paper, Bert Scalzo reveals easy tricks for ensuring the best possible user experience — even in the face of database changes.

Read now »

Case Study
Benchmark Factory for Databases helps Microsoft Technology Center solve application testing challenges and exceed customer support goals.
Read now »

Benchmark Factory for Databases

Minimize the Risks of Database Change

Benchmark Factory® for Databases is a database performance testing tool that allows you to conduct database workload replay, industry-standard benchmark testing, and scalability testing. It enables you to deploy changes to your database environment with confidence by reducing the risks associated with patches, upgrades, migrations, and adjustments to virtual machine configurations through the incorporated load testing tools. Benchmark Factory is a more flexible, simpler, and less expensive alternative to Oracle Real Application Testing. Plus, its proprietary workload capture and replay supports Oracle and SQL Server databases. With this workload replay and scheduling software, you can eliminate slow SQL database performance and dramatically simplify high performance database management, as well as do scalability testing.

Features

Whether you’re a database architect, developer or DBA, Benchmark Factory can help you:

  • Replay production workload in a test or development environment to simulate production scenarios and determine system throughput or find database breaking points (Oracle & SQL Server only)
  • Understand future performance problems and conduct "what-if" analyses
  • Make changes with confidence with a wizard-driven workflow
  • Validate performance and scalability improvements through reportable metrics
  • Capture workload subsets, as opposed to the entire database workload (unique to Quest)
  • Perform load tests on SQL scripts, PL/SQL, T-SQL code, and stored procedures under different concurrent user configurations
  • Simulate real database application workloads using industry-standard benchmarks (AS3AP, Scalable Hardware, TPC-B, TPC-C, TPC-D, TPC-H, and TPC-E)

Benchmark Factory can also help your organization:

  • Reduce the risk of costly downtime and inefficient performance
  • Eliminate the costs of outsourcing workload testing by automating the database-testing process
  • Have greater confidence in the deployment of database changes
  • Integrate with other Quest tools, like Toad® for Oracle, to support development and best practices

Sys Reqs

System Requirements

Before installing Benchmark, ensure your system meets the following minimum hardware and software requirements:

Repository

Benchmark Factory cannot run without a repository, and during installation you must select either the default service based or file based repository. After installation, you can select a repository of your choice. Benchmark Factory supports the following databases:

  • Oracle®
  • SQL Server®
  • MySQL
  • SQLite
  • SAP SQL Anywhere® (Adaptive Server® Anywhere)
Memory

512 MB of RAM recommended

Note: The memory required may vary based on the following:

  • Applications that are running on your system.
  • Size and complexity of the database.
  • Amount of database activity.
  • Number of concurrent users accessing the database.
Platform1.0 GHz x86 or x64 compatible CPU
Browser RequirementsBenchmark Factory requires Internet Explorer® 7 or later.
Hard Disk Space120 MB of disk space for installation Note: The disk space required may vary based on options selected for installation.
Operating System

Microsoft Windows Server® 2003

Microsoft Windows Server 2008

Microsoft XP Professional

Microsoft Vista®

Microsoft Windows® 7

Microsoft Windows 8

Microsoft Windows 8.1(Update)

Microsoft Windows Server 2012

.NET Framework.Net Framework 2.0 is required if performing an Oracle or SQL Server workload Capture.
Database Server

Oracle®: 9i, 9.2, 10g, 11g, and 12c (requires Oracle 9 client libraries or higher.)

Note: Benchmark Factory has been tested on Oracle Exadata 2.0 running Oracle database 11g R2.

Note: Oracle Capture/Replay of workloads must use Oracle 9i or higher.

SQL Server®: 2000, 2005, 2008, 2008 R2, 2012, and 2014

SQL Azure™: Benchmark Factory provides limited support of SQL Azure.

SAP®: 12.5, 15, 15.5, 15.7, 16

DB2 LUW®: 8.1.5 through 10.x

DB2 for z/OS®: 8.x through 10.x

MySQL: 4.5 and 5.x

Note: The 32-bit version of Benchmark Factory requires the 32-bit versions of the client libraries (including ODBC drivers). The 64-bit version requires 64-bit client libraries.

ODBC Database ServerBenchmark Factory supports almost all databases that you can connect to using an ODBC 3.0 or later driver.

Virtualization Support

Before installing Benchmark Factory, review the following for virtualization support:

Application Virtualization

Benchmark Factory has been tested with the following:

  • Citrix XenApp 6.5

Videos

Screenshots

Application Changes

Application Changes

Prevent bottlenecks by validating code scalability.

Increased User Activity

Increased User Activity

Determine database breaking points by simulating user activity.

Platform Changes

Platform Changes

Perform workload replay to determine your optimal platform or database configuration.

Reporting

Reporting

View test results with the 'Run Reports' feature.