Documentation forDatabase Performance Analyzer

Create an Azure SQL Database repository database

After you install DPA, you must create the repository database, which holds the performance data that DPA collects. Use this procedure to create an Azure SQL Database repository database.

To create a different type of repository database, see Create a SQL Server repository database, Create an Oracle repository database, or Create a MySQL repository database.

Azure SQL Managed Instance (ASMI) is not supported as a DPA repository database. See the system requirements for more information.

If one or more monitored database instances is created with multi-byte support, the repository database should also be created with multi-byte support.

Before you start

Before you run the Repository wizard:

Create a database in Azure SQL Database.
The DPA server connects to the repository through a TCP/IP connection. Make sure that connection is not blocked by a firewall.

Run the wizard

  1. To open DPA, enter the following URL in a web browser, where yourServer is the hostname or IP address of the DPA server:

    https://yourServer:8124

    If the repository database has not been created, the Repository wizard opens automatically.

  2. Click Create New Repository.

  3. Complete the remaining wizard panels as described in the following table.

Panel Instructions
Select Repository Database Instance Type Select Azure SQL as the database type.
Enter Repository Connection Information

Before connecting, the database must exist in Azure and be empty.

  1. Enter the server name, port, and database name. You cannot use an IP address in the Server Name field.
  2. Select a method for creating or configuring the repository administrator.

To create a new account:

  1. Click Let DPA create and configure the user for me.

  2. Enter the credentials of an existing user with privileges to create the repository user and to grant the required permissions.

    This user must be a member of the db_owner role.

To specify an existing account, enter the user name and password of an existing account that DPA will use the interact with the repository.

Alternatively, you can use the provided script to create the repository user.

  1. Click Repository User Creation Script, and follow the on-screen instructions.
  2. Copy and run the edited script on your Azure SQL database.
  3. Provide this user as your repository administrator.
Enter Repository Login

DPA can create the repository administrator account, or you can specify an existing account. To ensure that the account has the required permissions, SolarWinds recommends creating a new account.

To create a new account:

  1. Click Let DPA create a new user.
  2. Enter a user name and password for the new account.

To specify an existing account:

  1. Click Let DPA configure an existing user.
  2. Enter the user name and password of an existing account.
Contact Information

Enter your name and email. DPA sends database performance reports to this address.
Summary

Review the information and click Create Repository.
Finished Repository Creation

After the repository has been created, click Register Database Instance to start registering instances, or close the wizard and register instances later.