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.
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.
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).
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.
Before installing Benchmark, ensure your system meets the following minimum hardware and software requirements:
RepositoryBenchmark 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:
512 MB of RAM recommended
Note: The memory required may vary based on the following:
1.0 GHz x86 or x64 compatible CPU
Benchmark Factory requires Internet Explorer® 7 or later.
120 MB of disk space for installation Note: The disk space required may vary based on options selected for installation.
.NET Framework 2.0 is required to use Oracle workloads captured with Benchmark Factory 6.9.3 or earlier.
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.
Oracle® 10g R2, 11G, 12c, 18c, 19c, and 21c
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.
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.
Benchmark Factory supports almost all databases that you can connect to using an ODBC 3.0 or later driver.
Oracle Database as a Service
AWS RDS platform for MSSQL, MySQL and MariaDB
Azure SQL database
Before installing Benchmark Factory, review the following for virtualization support:
Application VirtualizationBenchmark Factory has been tested with the following: