Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

 

 

 

Home > Success Center > Database Performance Analyzer (DPA) > DPA 11.0 Administrator Guide > Create the repository database

Create the repository database

Table of contents
Created by Anthony.Rinaldi, last modified by Anthony.Rinaldi on Sep 15, 2016

Views: 2 Votes: 0 Revisions: 4

After you install DPA and open it for the first time, you must create a repository database.

The repository database is the permanent storage location for monitoring user credentials and performance data captured by SolarWinds DPA from the monitored database instances.

You can use a SQL Server, Azure SQL, MySQL, or Oracle database as the repository. When planning your connection, consider the following:

  • The repository host machine
  • The number of monitored database instances
  • The load on the monitored instances

SolarWinds DPA requires one of the following users to create users and grant them privileges to create the repository:

  • SQL Server: SYSADMIN
  • Azure SQL: repository administrator
  • MySQL: repository administrator
  • Oracle: database administrator (DBA)

The SolarWinds DPA server connects to the repository through a TCP/IP connection. Make sure that connection is not blocked by a firewall.

Select the database type

Last modified
13:51, 15 Sep 2016

Tags

Classifications

Public