Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

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_ret, last modified by Anthony.Rinaldi_ret on Sep 15, 2016

Views: 166 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