Benchmark Factory for Databases 9.0.0.288 (x86/x64)

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.
BENEFITS:
Predict performance problems and intervene proactivelyMake changes with confidence using an easy, wizard-driven workflowValidate performance and scalability improvements through reportable metricsCapture workload subsets, as opposed to the entire database workloadExecute automated performance testing as part of your DevOps CI/CD pipeline via REST APIHelp provide an independent assessment of appropriate cloud tier choice based on workload scalability and performance
DATABASE WORKLOAD AND SCALABILITY TESTING
Implementing new applications and troubleshooting production database performance issues when SLAs may be in place, are important responsibilities for today's DBAs. Unfortunately, they take time away from other critical tasks. What if you could reduce the amount of time you spend troubleshooting production database performance problems? What if you could predict, diagnose and resolve production performance scalability in a test environment?
Quest Benchmark Factory for Databases simulates users and transactions on the database, enabling your developers, database administrators and quality assurance teams to:
Replay production or synthetic activity in test or development environmentsEasily perform load tests on SQL scripts, PL/SQL, T-SQL code and stored procedures under different concurrent user configurationsSimulate real database application workloads using out-of-the-box industry-standard benchmarksDetermine system throughput and find database breaking pointsChoose the appropriate cloud tier based on workload scalability and performance
Benchmark Factory is available for Oracle, SQL Server, IBM DB2, SAP, MySQL, PostgreSQL and supports other databases via ODBC connectivity.
Database workload generation- Take production or synthetic activity and replay it in test or development environments to simulate real-world production loads. This empowers you to understand future performance problems and do what-if analyses using actual transaction workloads.
Database code scalability testing- Perform load tests on SQL scripts, PL/SQL, T-SQL code and stored procedures under different concurrent user configurations to evaluate how applications perform when deployed with real activity. Benchmark Factory also integrates with Quest's SQL Optimizer products to fix any code performance issues found prior to production deployment.
Industry-standard benchmark testing- Simulate real database application workloads using out-ofthe-box industry-standard benchmarks (TPC-H, TPC-C, TPC-D, TPC-E, AS3AP and scalable hardware) to evaluate database scalability, test hardware/configurations and determine system throughput.
Virtual user and transaction load simulation- Propagate user and transaction workloads on the system under test to quantify application or server performance, determine system throughput and find database breaking points. Each user and transaction acts as a separate, independent thread with its own connection and statistics, including run times and transactions per second.
Configurable Agents- Enable user and workload propagation via Agents which can be deployed on remote machines (Windows or Linux) to spread the load and reduce desktop console bottlenecks.
PRACTICAL APPLICATIONS
DATABASE CLIENT/SERVER VERSIONS
MariaDB 10.x, 11.xOracle 10g R2, 11G, 12c, 18c, 19c and 21cSQL Server 2012, 2014, 2016, 2017, 2019, and 2022Azure SQL (limited support)SAP ASE 15.5, 15.7, 16IBM DB2 LUW: 9.x through 10.x, 11.xIBM DB2 z/OS 12, 13MySQL 5.5, 8.0.36PostgreSQL 9.5, 9.6, 10EnterpriseDB Postgres 10, 11, 12, 13, 14, 15, and 16
New features in this Release
Database Support
This release of Benchmark Factory includes support for the following database versions:
Oracle 21cSQL Server 2022PostgreSQL 11, 12, 13, 14, 15, 16MariaDB 10.x, 11.xMySQL 8.0.36IBM® DB2® for z/OS 12, 13
Operating System Support
Windows operating system:
Microsoft Windows 11Microsoft Windows Server 2022
Cloud support:
AWS RDS platform for MySQL, MSSQL, and MariaDBAzure SQL database
ABOUT QUEST
Quest creates software solutions that make the benefits of new technology real in an increasingly complex IT landscape. From database and systems management, to Active Directory and Microsoft 365 migration and management, and cybersecurity resilience, Quest helps customers solve their next IT challenge now. Quest Software. Where next meets now.