Chat now with support
Chat with Support

Benchmark Factory for Database 8.2.1 - User Guide

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

SQL Server Settings

Use the SQL Server page of the Settings dialog to specify default settings for testing against SQL Server databases.

Note: If you modify the default settings in the Settings dialog, the changes apply to new jobs only, not to existing jobs.

To specify SQL Server settings

  1. Select Edit | Settings | SQL Server.
  2. Review the following for additional information:

    Database Flush  
    Clean data buffer and procedure caches at start of each test iteration

    Select this option to instruct Benchmark Factory to clear cached data between iterations. Cached data can improve performance, so selecting this option can prevent cached data from affecting subsequent iterations.

    Notes:

    • This option is only applicable to SQL Server 2005 or later.
    • To perform this action, the SQL Server database account must have the sysadmin fixed server role.

Tip: You can specify this option for each individual SQL Server connection. See Create SQL Server Connection for more information.

Related Documents