Benchmark Factory for Database 7.6.1

Select Start | All Programs | Accessories | Command Prompt.
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
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

Agent Connection

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

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.
In the Support Bundle dialog, select the modules you want to send.
If creating a support bundle for a single job, select Just for selected job.
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.

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

Benchmark Factory for Database 7.6.1 - User Guide

Exporting Test Results to Excel Using the Command Line

Benchmark Factory Test Results Terminology

Troubleshooting

Support Bundle