Increase your database development process speed by up to 40% and become truly agile
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 SQL Server databases. Experience how you can eliminate SQL scalability issues, and dramatically simplify high-availability database management.
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:
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:
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®: 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.
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
Before installing Benchmark Factory, review the following for virtualization support:
Benchmark Factory has been tested with the following:
There is one universal database constant: no matter what, your database will change over time. Unfortunately, most tools are insufficient to enable DBAs to manage change and maintain database performance.
According to Quest expert Bert Scalzo, many problems associated with benchmarking can simply be solved through education. In this white paper, he addresses the ten most common fallacies about database benchmarking. After reading it, you will have a better
Reduce time spent on SQL Server application development and database administration.
Simplify SAP SQL development and administration
Develop and manage Oracle databases with less time and effort.
Achieve ZeroIMPACT database replication with the affordable golden alternative.
Improve and accelerate daily development and administrative tasks on Linux, Unix and Windows