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.

In this topic:

To access Analysis > Tools > Options > Database tab.
See also

Importing Data Directly from the Analysis Machine

Main Area

User interface elements are described below:

UI Element Description
MS Access

Instructs LoadRunner Professional to save Analysis result data in an MS Access database format (default).

Recommended if the Analysis session file is less than 2 GB.
SQL Server

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

Use this format if you need to work in multithread mode.

Recommended if the Analysis session file is 2 GB to 10 GB.
SQLite

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

Allows you to store up to 32 terabytes of data.

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

Recommended if the Analysis session file is more than 10 GB.
Server Details area

SQL server details. See description below.
Shared Folder Details area

SQL server 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. 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 Professional 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).

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

Back to top

Server Details Area

If you choose to store Analysis result data on an SQL server, 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 is running.

Enter in the format <machine name>\<DB instance name>. For example, mycomp_01\SQLEXPRESS.

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, 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. 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 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 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 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.

Notes:

  • 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

See also: