Benchmark Factory for Databases
Increase your database development process speed by up to 40% and become truly agile
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.
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
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.
- 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
Resources
Change Without Degradation
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.
Top 10 Benchmarking Misconceptions
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
Benchmark Factory for Databases
Save time troubleshooting production issues, and quickly implement new applications.
Mitigate your Oracle Migration to Azure Challenges with Quest® Solutions
Learn how Quest's comprehensive set of database solutions meet Oracle to Azure migration challenges every step of the way.
IDC InfoBrief: Making Open Source RDBMS Work for the Enterprise
IDC's research discovered that open source RDBMS spending has nearly tripled since 2014. This info brief shows why DBAs are embracing open source for enterprise databases.
Quest Partner Webcast FY21 Q2 EMEA
Quest has the technology solutions your customers need to connect, manage and secure a remote workforce.
Quest Partner Update FY21
Rapidly developing and unprecedented world events have challenged organizations to quickly adapt to a new reality. Recent events have forced governments to enact social distancing measures and business closures that have disrupted daily life and work.Quest & One Identity understand the complex chall
One Identity UNITE Madrid 2023
One Identity UNITE User and Partner Conference is where customers, partners, prospects and product experts drive identity security strategy and product development into the future. Join us this fall i
- More Resources
- Communities
- Events & Demos
- Research Docs
- Videos
Take the next step
Related Products
Toad for SQL Server
Reduce time spent on SQL Server application development and database administration.
Toad for SAP Solutions
Streamline SAP development and administration.
Toad for Oracle
Develop and manage Oracle databases with less time and effort.
SharePlex
SharePlex - Database replication software for high availability, scalability, and interoperability
Toad for IBM DB2
Improve and accelerate daily development and administrative tasks on Linux, Unix and Windows
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.