Database server

This topic describes the database server and how to view the properties of the database server that was defined during the installation process.

About the database server

The database server is defined during the LoadRunner Enterprise installation process. For installation details, see LoadRunner Enterprise Installation Guide.

The database server stores three types of schemas:

  • Site Administration schema. Stores information related to the LoadRunner Enterprise system, such as domains, users, and site parameters. A row exists in this schema for each project you create. Irrespective of how you configure your system, there is always only one Site Administration schema.

  • Lab Management. Stores lab information related to managing performance testing on remote hosts, LoadRunner Enterprise server data, and licenses. There is only one Lab Management schema.

  • Project schemas. Stores project information, such as entity data and user data. A separate schema exists for every project you create.

The schemas can reside on an Oracle, Microsoft SQL, or PostgreSQL database server.

Note: Support for PostgreSQL is provided as a tech preview version.

Back to top

View database server properties

This section explains the database server properties that are displayed in LoadRunner Enterprise Administration.

Note: You can modify the database server properties from the LoadRunner Enterprise Configuration wizard. For details, see the LoadRunner Enterprise Installation Guide.

  1. In LoadRunner Enterprise Administration, select Configuration > Servers, and click the DB Server tab.

  2. The database server details are displayed (read only):

    UI Element Description
    Server Name Name of the database server.
    Type

    The type of database server being used: Oracle, Microsoft SQL (using SQL or Windows authentication), or PostgreSQL.

    Oracle Service Name

    (Oracle only)

    The net service name for an Oracle database server found in the local tnsnames.ora file.

    Site Admin Schema Name The name of the source Site Admin schema (read only).
    Lab Project Admin Schema Name The name of the source LAB database schema (read only).
    Description Description of the database.
  3. The Database Administration Credentials section displays the name of the administrator user account that is used for creating LoadRunner Enterprise projects on the database server.

    Note: The User name box is unavailable for MS-SQL (Win Auth.) because the login name of the database administrator is the Windows user that is set to run as a service.

  4. The Connection Details section displays the connection option that is being used.

    • Connection string parameters. If selected, the database server name and port number are displayed.

    • Connection String. If selected, the connection string is displayed.

    Note: For an Oracle database, the connection string parameters are grayed out.

  5. Click Check Connection to check the connection to the database server using the database administrator user and password supplied.

Back to top

See also: