For the best web experience, please use IE11+, Chrome, Firefox, or Safari

Benchmark Factory for Databases

Simplified database benchmark testing solution that ensures optimal performance. Easily conduct database workload capture and replay, industry-standard benchmark testing and scalability testing. With Benchmark Factory for Databases, you can make changes to your database environment, and mitigate the risks of planned database changes (such as patches and upgrades, operating system migrations and adjustments to virtual machine configurations). In addition, its proprietary workload capture and replay supports Oracle and Microsoft SQL Server databases. Experience how you can eliminate SQL scalability issues, and dramatically simplify high-availability database management.
Increase your database development process speed by up to 40% and become truly agile 01:12

Features

Database workload generation

Understand future performance problems and do what-if analyses using actual transaction workloads. Simulate real-world production loads by taking production or synthetic activity, and replaying it in test or development environments.

Database code scalability testing

Evaluate how applications perform when deployed with real activity. Perform load tests on SQL scripts, PL/SQL, T-SQL code and stored procedures under different concurrent user configurations. Fix any code performance issues found before production deployment by integrating with SQL Optimizer.

Industry-standard benchmark testing

Evaluate database scalability, test hardware/configurations and determine system throughput. Simulate real database application workloads using out-of-the-box, industry-standard benchmarks (TPC-H, TPC-C, TPC-D, TPC-E, ASP3AP and scalable hardware).

Virtual user and transaction load simulation

Quantify application or server performance, determine system throughput and find database breaking points by propagating user and transaction workloads on the system under test. Each user and transaction acts as a separate, independent thread with its own connection and statistics, including run times and transactions per second.

Tour

Visual comparison
Workload replay
Scalability testing
Easy-to-use console
Visual comparison

Visual comparison

View transactions per second and compare test runs to verify performance.

Specifications

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.
Platform

1.0 GHz x86 or x64 compatible CPU

Browser Requirements

Benchmark Factory requires Internet Explorer® 7 or later.

Hard Disk Space

120 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
  • Microsoft Windows 10
.NET Framework

.NET Framework 2.0 is required to use Oracle workloads captured with Benchmark Factory 6.9.3 or earlier.

SQL Server Native Provider

For a list of operating systems that support the SQL Server native provider distributed with Benchmark Factory (native client 11.0), see https://msdn.microsoft.com/en-us/library/cc280356(v=sql.120).aspx.

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,(ODBC only), 2005, 2008, 2008 R2, 2012, 2014 and 2016
  • SQL Azure™: Benchmark Factory provides limited support of SQL Azure.
  • SAP® ASE: 12.5, 15, 15.5, 15.7, 16
  • DB2® LUW: 9.x through 10.x
  • DB2® for z/OS: 9.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.

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
  • Microsoft Windows 10
ODBC Database Server

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

Cloud Database Service

Oracle Database as a Service

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

Application Virtualization

Benchmark Factory has been tested with the following:

  • Citrix XenApp 6.5

Support & Services

Product Support

Self-service tools will help you to install, configure and troubleshoot your product.

Support Offerings

Find the right level of support to accommodate the unique needs of your organization.