Chat now with support
Chat with Support

Benchmark Factory for Database 7.6 - User Guide

Getting Started Overview of Benchmark Factory Benchmark Factory Components Agents Connections Create and Edit Tests and Jobs Test Results and Run Reports Troubleshooting Licensing REST API

Getting Started

Getting Started With Benchmark Factory

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.

Learn More and Connect with the Community

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.

 

What's New in Benchmark Factory

New Features in 7.6

This release of Benchmark Factory® includes the following new features and enhancements.

Connections

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.

  • This new native provider delivers improved connection performance for SQL Server database connections.
  • To use the SQL Server native provider, install the version of Benchmark Factory (either 32-bit or 64-bit) that matches your operating system. This ensures that the version (bitness) of the SQL Server provider also matches your operating system.

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.

REST API

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:

  • Create, run, and edit Benchmark Factory jobs
  • Create and edit connections
  • Import and replay Oracle and SQL Server captures

Using the Benchmark Factory REST API

HTTP Request MethodsBenchmark Factory REST API uses the four main HTTP methods: GET, POST, PUT, and DELETE.

Response Format—Information is returned in XML format.

Continuous Integration

  • Use the REST API to implement performance testing by Benchmark Factory and incorporate it into your Continuous Integration (CI) process.

General

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.

  1. Select Edit | Settings | General to open the Settings dialog.
  2. Then enter a port number in the TCP/IP Settings. The default value is port 4568.

Standard Benchmark Testing

Teradata Database Benchmark Testing

  • This release includes enhancements to the support for standard benchmark testing on Teradata databases.

PostgreSQL Database Benchmark Testing

  • This release includes enhancements to the support for standard benchmark testing on PostgreSQL databases.

Replication Benchmark Test

  • You can now edit the precision of the FLOAT data type when customizing table options in a Replication Benchmark test.

Capture and Replay

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.

Settings

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.

  • To specify a threshold, go to Edit | Settings | Error Handling and enter a percentage.
  • You can disable/enable this memory usage check.

Error Handling Page in Settings Dialog

The error handling options have been moved to Edit | Settings | Error Handling in the Settings dialog.

Run Reports

Improved Performance When Importing Large Test Results

  • This release includes markedly improved performance when importing a very large Test Result file.

 

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.

Overview of Benchmark Factory

Self Service Tools
Knowledge Base
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
RSS Feed
Contact Us
Licensing Assistance
Technical Support
View All
Related Documents