Chat now with support
Chat with Support

Benchmark Factory for Database 8.4 - User Guide

Welcome to Benchmark Factory What's New in Benchmark Factory Additional Resources Overview of Benchmark Factory Benchmark Factory Components Licensing Getting Started - the Benchmark Factory Workflow Agents Create and Edit Connections Create and Edit Tests and Jobs
Jobs View Pane Job Wizards Quickstart: Create a New Job Edit a Job Industry Standard Benchmark Tests Capture and Replay a Workload Artificial Test for Desired Effect Scalability Tests Custom Tests Create/Delete Benchmark Objects Execute External File Test Options for Create Objects Test Options for Transactions Job Setup Options Use Global Search/Replace Save Job as BMF Script Copy Test to Replay, Mix, Goal, or Scalability Test
Benchmarks How Do I... Settings Test Results and Run Reports BFScripts Repository Troubleshooting The Benchmark Factory REST API Appendix About Us Adding Virtual Users System/Upgrade Requirements/Supported Databases Shortcut Keys

Oracle Instant Client Installation

To run Benchmark Factory, you must have the client dll files installed.

To install the Oracle Instant Client dlls

  1. Install the Oracle Instant Client on your system following the directions provided by Oracle.  
  2. Copy tnsnames.ora from a configured system to your system.
  3. Edit your systems Environment Variables using one of the following methods:
    • Add to the path variable the directory to which you copied the Instant Client files.
    • Add a new System variable Named TNS_Admin, and place the directory location of the tnsnames.ora file in the value field.

Note: Environment Variables can be reached by right-clicking the My Computer Icon, selecting properties, then select the Advanced tab, and then select the Environmental Variables button.

 

Creating a SQL 2005 Trace Table Using the SQL Server Profiler

To create a SQL 2005 trace table

  1. Initiate the SQL Profiler.
  2. Click the New Trace icon. The Connect to SQL Server window displays.
  3. Select the appropriate server name from the drop-down list.
  4. Select the appropriate authentication from the drop-down.  Enter the login name and password if required.
  5. Click Connect. The Trace Properties window displays.
  6. Enter a name for the trace in the Trace name field.
  7. Check the Save to table check box. The Connect to Server dialog displays.
  8. Select the appropriate server name from the drop-down list.
  9. Select the appropriate authentication from the drop-down.  Enter the login name and password if required.
  10. Click Connect. The Destination Table window displays.
  11. Select the appropriate database from the Database drop-down list.
  12. Select the appropriate owner from Owner drop-down.
  13. Select the appropriate table from the Table drop-down list.
  14. Click OK. The Trace Properties window displays.
  15. Click the Events Selection tab.
  16. Verify that all check boxes are checked in the TSQL-SQL:BatchStarting Events, and TSQL-SQL:BatchComplete Events.
  17. Click Run.
  18. Run SQL statements.
  19. When finished running SQL statements, click the Stop selected trace icon. The table is created. 

 

Creating a SQL 2008_2008 R2 Trace Table Using the SQL Server Profiler

To create a SQL 2008/2008 R2 trace table

  1. Initiate the SQL Profiler.
  2. Click the New Trace icon. The Connect to SQL Server window displays.
  3. Select the appropriate server name from the drop-down list.
  4. Select the appropriate authentication from the drop-down.  Enter the login name and password if required.
  5. Click Connect. The Trace Properties window displays.
  6. Enter a name for the trace in the Trace name field.
  7. Check the Save to table check box. The Connect to Server dialog displays.
  8. Select the appropriate server name from the drop-down list.
  9. Select the appropriate authentication from the drop-down.  Enter the login name and password if required.
  10. Click Connect. The Destination Table window displays.
  11. Select the appropriate database from the Database drop-down list.
  12. Select the appropriate owner from Owner drop-down.
  13. Select the appropriate table from the Table drop-down list.
  14. Click OK. The Trace Properties window displays.
  15. Click the Events Selection tab.
  16. Verify that all check boxes are checked in the TSQL-SQL:BatchStarting Events, and TSQL-SQL:BatchComplete Events.
  17. Click Run.
  18. Run SQL statements.
  19. When finished running SQL statements, click the Stop selected trace icon. The table is created. 

 

Migrating Data Using the Command Line Wizard

The Repository is a database where all test results are stored. Benchmark Factory inserts test results into the repository and provides an easy way to access the data. By default, the Repository is a MySQL or SQLite database that resides on the same machine as Benchmark Factory. The Repository can reside on another database server if required. To change the database, open the Repository Manager  or use the Repository Settings page of the Setting dialog.

Benchmark Factory allows you to migrate data from the DOS command line.

To migrate data using the DOS command line

  1. Click Start | All Programs | Accessories | Command Prompt.

  2. Navigate to the Benchmark Factory bin directory. For example:

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

  3. To display the syntax help, type:

    bmfdatamigrationWizard.exe -?

  4. Press Enter. The usage parameters display.

  5.  To perform the migration, use the following syntax:

        BMFDataMigrationWizard -s [DSN,USER,PWD] -d [DSN,USER,PWD]

    Example:

     BMFDataMigrationWizard -s [MyDatabase,root,yourpassword] -d[LocalServer,sa,sa]

 

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating