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

Edit and Manage Connections

To edit a connection, use the My Connections pane or click the Edit Connections button in the main toolbar. Both the My Connections pane and the Edit Connections dialog provide a list of your currently-defined connections. Use either of these interfaces to view or modify information for each connection.

To edit a connection

  1. Use one of the following methods to edit a connection:

    • Click in the main toolbar. Select a connection and click in the Edit Connections dialog.
    • Select View | My Connections. In the My Connections pane, select a connection and click .
  2. The Connection dialog for the selected connection opens. Use the DB Connection tab to update the connection password or other connection information.
  3. Select from among the other tabs to add or modify other properties associated with the connection. The following tabs are available (depending on the connection type).

Manage Connections

  • Click Edit Connections. In the Edit Connections dialog, use the following toolbar buttons to manage connections.

    Open the New Connection dialog to create a new connection.
    Remove the selected connection.
    Open the Connection dialog for the selected connection. Use this dialog to view or edit connection properties.
  • Select View | My Connections. In the My Connections pane, use the following toolbar buttons to manage connections.

    Create a new connection.
    Edit the selected connection.
    Duplicate the selected connection.
    Delete the selected connection.

Timeout and Reconnect Options

You can specify timeout and reconnect options when you are creating a new connection. You can also specify these options at any time for an existing connection.

To specify timeout and reconnect options

  1. In the New Connection dialog, after entering connection information, click Options.
  2. Specify the following options.

    Timeout  

    Time

    The maximum amount of time Benchmark Factory will try to log on to the system-under-test. If this amount of time is reached, Benchmark Factory will return an error.

    Infinite timeout

    Prevents the logon to the system-under-test from timing out and returning an error.
    Reconnect  

    Enable Reconnect

    Enables Benchmark Factory to attempt to reconnect to the system-under-test if the connection is lost.

    Number of reconnect attempts

    The number of times to attempt to reconnect before aborting.

    Time to wait between reconnect attempts (seconds)

    How long to wait before attempting to reconnect.
  3. Click OK.

To specify timeout and reconnect options for an existing connection

  1. Click in the main toolbar.
  2. Select the connection and click .
  3. Then click Options in the Connection dialog.

Environment Information

Benchmark Factory can collect and display database and host server information for a connection. The information is displayed in the Environment tab of the Connection dialog for an existing connection and also in the Database Under Test page of the New/Edit Job Wizard.

You can also create custom properties to add your own customized information to the connection.

To collect environment information

  1. Open the Connection dialog for an existing connection. Use one of the following methods:
    • Click in the main toolbar. Select a connection and click in the Edit Connections dialog.
    • Select View | My Connections. In the My Connections pane, select a connection and click .
  2. Select the Environment tab in the Connection dialog.
  3. Click Detect Environment Information.

    Note: To successfully view all environment information requested by Benchmark Factory, the login account used in the connection must have sufficient permissions. See Environment Information for more information.

To collect environment information in the Job wizard

  1. Click New or Edit Job to open the Job Wizard.
  2. Select the Database Under Test page.
  3. (New job) Select a connection.
  4. Click Detect Environment Information.

    Note: To successfully view all environment information requested by Benchmark Factory, the login account used in the connection must have sufficient permissions. See Environment Information for more information.

To create a custom property

  1. In the Connection dialog for a connection, select the Environment tab.
  2. Click Add.
  3. Enter a property name and value. Click OK.
  4. The new property and value display in the Environment tab under Custom Properties.

Permissions Required to Detect Environment Information

In order to display database and host server information for a particular connection, the user account used in the connection must have the necessary permissions. Review the following special requirements for detecting environment information.

Connection Type Required Permissions
IBM DB2

To access database information, the SELECT or CONTROL privilege on the TBSP_UTILIZATION, SNAPTBSP, and SNAPTBSP_PART administrative views and the SYSCAT.TABLESPACES catalog view is required.

To access snapshot monitor data, the SYSADM, SYSCTRL, SYSMAINT, or SYSMON authority is required.

MySQL To access database metadata, the select privilege for INFORMATION_SCHEMA and INFORMATION_SCHEMA.GLOBAL_VARIABLES is required.
Oracle

Retrieving database information requires access to the following views: DBA_DATA_FILES, DBA_FREE_SPACE, SYS.V$LOG, V$OSSTAT, DBA_TEMP_FILES, and SYS.V$CONTROLFILE.

Alternatively, you could grant the SELECT ANY DICTIONARY system privilege to the user.

SAP To access database information, the select privilege on master.dbo.sysusages and master.dbo.sysdatabases is required.
SQL Server To view Host CPU Count and Host Memory, the login account requires the VIEW SERVER STATE permission

Performance Counters

Performance counters keep track of statistics during test execution. By default the following performance counters are recorded when a job executes, even though they do not display in the Performance Counter tab for a connection or job.

  • AVG_TIME
  • BPS
  • DEADLOCKS
  • TOTAL_ERRORS
  • MAX_TIME
  • RPS
  • TOTAL_BYTES
  • TOTAL_ROWS
  • TPS
  • USERLOAD

You can add performance counters to a connection or a job.

To add performance counters to a connection

  1. In the New Connection dialog when creating a new connection (or the Connection dialog for an existing connection), select the Performance Counters tab.
  2. To add a new counter, click .
  3. Select a computer from the drop-down list.
  4. To display counters, expand an object node by clicking the node's down-arrow.
  5. Select one or more counters and click Add.
  6. When you have finished adding counters, click Close to close the Browse Performance Counters dialog.
  7. To delete a counter, select the counter and click .
Related Documents