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

Exporting Test Results to Excel Using the Command Line

Benchmark Factory allows you to export testing results to Excel using the Command line.

To export testing results from Benchmark Factory to Excel using the command line:

  1. Select Start | All Programs | Accessories | Command Prompt.
  2. Navigate to the Benchmark Factory bin directory. For example:

    CD C:\Program Files\Quest Software\Benchmark Factory\bin

    CD C:\Program Files\Quest Software\Benchmark Factory <version number>\bin

  3. Enter BMFRunHistory.exe –x 34 88 108. Benchmark Factory testing results with Run ids of 34, 88, and 108 export to Excel.

Benchmark Factory Test Results Terminology

The following provides a list of commonly used Benchmark Factory testing terms.

The following terms can be expressed as:

Average – The average of all recorded values for the statistic over the sampling period.

Minimum – The minimum value the statistic obtained over the sampling period.

Maximum – The maximum value the statistic obtained over the sampling period.

90th Percentile – This is usual associated with a timing statistic.  This is the time value where 90 percent of all values recorded for a statistic fell below.

Term Definition

Bytes

 

The number of bytes from data received from a SQL statement.

Bytes Per Second

The number of bytes processed per second over the sampling period.  This is just the Total Bytes divided by the Sampling period in seconds.

 

Response Time

The time it takes from when the SQL is sent to the server responds.

 

Retrieval Time

The time it takes from the server responds to a SQL statement till the last byte of data/results is obtained.

 

Rows

The number of rows received from a SQL statement.

 

Rows Per Second (RPS)

The number of rows received per second over the sampling period.  Similar to above.

 

Transactions Per Second (TPS )

The transactions, or SQL statements, processed by the server per second.  A transaction in Benchmark Factory can be more than a single SQL statement, such as the TPC-C transaction New Order, this transaction inserts a new order by inserting one record into the new order table and 5 – 7 items in the orderline table.

 

Transaction Time (sometimes listed as just Time)

The sum of the Response and Retrieval time.

Troubleshooting

Support Bundle

The Benchmark Factory Support Bundle allows you to zip up a .bfp file and send it to support for review. The bundle contains the following information:

  • BMF version number
  • Settings
  • License information (just send the key files)
  • Error Logs and Result Logs from the associated directories
  • Files located in the data directory. This will be not only the xml files for imported users scenarios, but also dump files.
  • Script files XML configuration files
  • A file that contains hardware information about the system running on it as well as the output of the agents configurations from the repository
  • Information about versions of all loaded .dlls

To create a Benchmark Factory support bundle

  1. Select Help | Support Bundle to open the Support Bundle dialog.
    • To create a support bundle for a single job, select the job in the Jobs View pane before opening the Support Bundle dialog.
  2. In the Support Bundle dialog, select the modules you want to send.
  3. If creating a support bundle for a single job, select Just for selected job.
  4. Then do one of the following:
    • To save the bundle, click the Save icon.
    • To email the bundle to Support, click Email Quest Software Support.
    • To contact Support via the Support Portal, click Quest Support.

    The bundle is created and saved in the following location:

    C:\Documents and Settings\<user name>\My Documents\Benchmark Factory\<version number>\BMFSupportBundle.zip.

Related Documents