Database Tab (Options Dialog Box)

This tab enables you to specify the database in which to store Analysis session result data and to configure the way in which CSV files will be imported into the database.

To access Analysis > Tools > Options > Database tab.
Important information

Analysis data can be saved in one of three formats. Select the format based on the size of the analysis session file, as shown in the table below:

Size of the Analysis session file Recommended format
  • Less than 2 GB
Access 2000
  • 2 GB to 10 GB

SQL Server/MSDE

Select SQL Server/MSDE if you need to work in multithread mode.

  • More than 10 GB

SQLite

Note that the SQLite format allows you to store up to 32 terabytes of data.

Note: Both the Access 2000 database format and the SQLite format are embedded databases. The session directory contains both the database and the analysis data.

See also

Importing Data Directly from the Analysis Machine

User interface elements are described below:

UI Element Description
Access 2000

Instructs LoadRunner to save Analysis result data in an Access 2000 database format. This setting is the default.

SQL Server/MSDE

Instructs LoadRunner to save Analysis result data on an SQL server / MSDE machine. If you select this option, you have to complete the Server Details and Shared Folder Details, described below.

SQLite

Instructs LoadRunner to save Analysis result data in an SQLite database format.

If you choose this format, you will not be able to work in multithread mode.

Server Details area

SQL server / MSDE machine details. See description below.

Shared Folder Details area

SQL server / MSDE machine shared folder details. See description below.

Depending on which database you are using, this button performs the following action:

  • For Access. Checks the connection parameters to the Access database and verifies that the delimiter on your machine's regional settings matches the Microsoft JET delimiter on the database machine.

  • For SQL server / MSDE. Checks the connection parameters, the existence of a shared server directory, whether there are write permissions on the shared server directory, and whether the shared and physical server directories are synchronized.

  • For SQLite. This button is disabled.

When you configure and set up your Analysis session, the database containing the results may become fragmented. As a result, it will use excessive disk space. For Access databases, the Compact database button enables you to repair and compress your results and optimize your database. This button is disabled if you choose SQLite.

Note: Long load test scenarios (duration of two hours or more) will require more time for compacting.

Opens the Advanced Options dialog box, allowing you to increase performance when processing LoadRunner results or importing data from other sources.This button is disabled if you choose SQLite. For user interface details see Advanced Options Dialog Box (Database Tab).

Server Details Area

If you choose to store Analysis result data on an SQL server / MSDE machine, you need to complete the server details. User interface elements are described below:

UI Element Description
Server Name

The name of the machine on which the SQL server / MSDE is running.

Use Windows integrated security

Enables you to use your Windows login, instead of specifying a user name and password. By default, the user name "sa" and no password are used for the SQL server.

User Name

The user name for the master database.

Password

The password for the master database.

Back to top

Shared Folder Details Area

If you store Analysis result data on an SQL server / MSDE machine, you need to provide the shared folder details. User interface elements are described below:

UI Element Description
Import Data Directly from Analysis machine

Select this option to import data directly from the Analysis machine. For details on this option, see Importing Data Directly from the Analysis Machine.

Shared Folder on MS SQL Server
  • Shared folder path. Enter a shared folder on the SQL server / MSDE machine. For example, if your SQL server's name is fly, enter \\fly\<Analysis database folder>\.

  • This folder has different functions, depending on how you import the Analysis data:

    • If you did not select the option to import data directly from the Analysis machine, this folder stores permanent and temporary database files. Analysis results stored on an SQL server / MSDE machine can only be viewed on the machine's local LAN.

    • If you selected the option to import data directly from the Analysis machine, this folder is used to store an empty database template copied from the Analysis machine.

  • Local folder path. Enter the real drive and folder path on the SQL server / MSDE machine that correspond to the above shared folder path. For example, if the Analysis database is mapped to an SQL server named fly, and fly is mapped to drive D, enter D:\<Analysis database folder>.

  • If the SQL server / MSDE and Analysis are on the same machine, the logical storage location and physical storage location are identical.

Shared Folder on Analysis Host

If you selected the option to import data directly from the Analysis machine, the Shared folder path box is enabled. Analysis detects all shared folders on your Analysis machine and displays them in a drop-down list. Select a shared folder from the list.

    Note:
  • Ensure that the user running the SQL server (by default, SYSTEM) has access rights to this shared folder.

  • If you add a new shared folder on your machine, you can click the refresh button to display the updated list of shared folders.

  • Analysis creates the CSV files in this folder and the SQL server imports these CSV files from the Analysis machine directly into the database. This folder stores permanent and temporary database files.

Back to top