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

Settings_Benchmarks

Use the Benchmarks page of the Settings dialog to specify some general benchmark testing options.

To specify general Benchmarks settings

  1. Select Edit | Settings. The Settings dialog opens.
  2. Select Benchmarks. Review the following for additional information:

    Refresh statistics after benchmark load

    Select to instruct Benchmark Factory to refresh statistics after loading benchmark data.

    Default = selected

    Check scale factor before running benchmark test

    Instruct Benchmark Factory to check the Benchmark Scale factor of the existing tables against the new Benchmark Scale requirement before executing a test.

    To skip the scale checking process, do not select this checkbox.

    Default = selected

  3. Select a default setting for the Object/Data Retention method. The default setting applies to new Create Objects steps. Review the following for additional information:

    Create/Load objects if objects don't exist (no backup sets created)

    If objects do not exist, Benchmark Factory creates the objects and loads data.

    If you select this option, Benchmark Factory does not create backup tables.

    Delete benchmark objects after completion of job Benchmark Factory deletes objects after a job is finished.
    Refresh data using backup sets

    When backup sets exist, Benchmark Factory reloads data and recreates indexes.

    If backup sets do not exist, Benchmark Factory creates objects and loads data. Then Benchmark Factory creates the backup tables.

    Recreate objects and reload data every execution

    Benchmark Factory always deletes the existing objects and then recreates/reloads for each job execution.

    This allows you to ensure that the dataset is always in initialized status.

    Refresh data using inserts

    If data does not exist, Benchmark Factory uses bulk insert to load data.

    If the following Benchmark Settings are selected,

    and the Benchmark Scale factor of the existing tables does not match the new requirement, the process of inserting additional data or deleting data my run long, depending on the size of the existing data and number of indexes.

    Note: If database does not support bulk insert, insert is used.

  4. Click Apply to apply your changes.
Related Documents