Benchmark Factory® is a database performance testing tool that allows you to conduct database workload replay, industry-standard benchmark testing, and scalability testing.
Review the following topics for a quick overview of Benchmark Factory.
Use the following links to videos, blogs, and community resources to learn more about Benchmark Factory, to find answers to questions, and to advance your knowledge through Benchmark Factory tips and tricks.
This release of Benchmark Factory® includes the following new features and enhancements.
Microsoft SQL Server Native Provider - New
You can now use a SQL Server native connection in Benchmark Factory to connect to a SQL Server database. The SQL Server native provider is included in the Benchmark Factory installation.
Note: 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. If your client operating system is not supported, use ODBC connectivity.
This release of Benchmark Factory includes a REST API which will allow users to automate certain tasks and functionality in Benchmark Factory. Use a script, command-line tool, or custom application to interface with Benchmark Factory and to automate your load testing tasks. The API uses HTTP protocol and returns information in XML format.
In this release, the REST API supports the following functionality:
HTTP Request Methods—Benchmark Factory REST API uses the four main HTTP methods: GET, POST, PUT, and DELETE.
Response Format—Information is returned in XML format.
Adding Bind Parameter Values for Prepared Statements
It is now much easier to add bind variable or parameter values for prepared statements.
In the Transaction tab, when adding a new statement or editing an existing statement, the Add bind parameter button is now enabled for prepared statements. Click this button to add bind parameter values for the selected SQL.
Specify Benchmark Factory Console Port Number
You can now specify a TCP/IP port for the Benchmark Factory console.
Teradata Database Benchmark Testing
PostgreSQL Database Benchmark Testing
Replication Benchmark Test
Easily Open Capture Scenario Wizard from Tools Menu
You can now open the Capture Scenario Wizard directly from the Tools menu.
Select Tools | Capture Workload. Then select either Oracle or SQL Server as the capture type.
Discontinued - Import from Foglight PA
The option to import a workload from a Foglight Performance Analysis Repository when creating a new Capture and Replay test is no longer available beginning with this release of Benchmark Factory.
Specify a Threshold for Memory Usage
You can now specify a memory usage threshold. If memory usage exceeds the percentage you specify, Benchmark Factory stops the job.
Error Handling Page in Settings Dialog
The error handling options have been moved to Edit | Settings | Error Handling in the Settings dialog.
Improved Performance When Importing Large Test Results
Note: The features described in the New in This Release section apply to the commercial version of Benchmark Factory and may not be available in the freeware version.