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) > Database Performance Analyzer Getting Started Guide > Install DPA > Plan your DPA installation

Plan your DPA installation

Created by Melanie Boyd, last modified by Melanie Boyd on Sep 29, 2016

Views: 267 Votes: 0 Revisions: 5
DPA_GS_Home.png

Use the following information to prepare for your DPA installation:

Installation options

The following installation environments are supported.

DPA server
  • Windows
  • Linux
  • Amazon Web Services (AWS) from an Amazon Machine Image (AMI)
  • Azure Marketplace
Repository database type
  • SQL Server
  • Azure SQL
  • Oracle
  • MySQL

This guide provides instructions for installing DPA on a Windows server, and configuring the repository on a SQL Server database. If you plan to use a different server OS or repository database type, see the DPA Administrator Guide for system requirements and installation instructions.

Installation overview

To install and implement DPA, you must perform the following tasks:

  1. Install DPA on the DPA server.
  2. Use the Repository Wizard to create the DPA repository database. This database stores the data that DPA collects.
  3. Use the setup wizard to register the database instances that you want DPA to monitor.

After installation, you can integrate DPA with the Orion Platform. Integration displays information from all DPA servers in the Orion console, and provides additional information about the applications using each database instance.

DPA server requirements for a self-managed Windows server

To install DPA on a self-managed Windows server, ensure that the server meets the following minimum requirements. Some requirements depend on the number of database instances you plan to monitor.

  • For information about all supported DPA server options, see Server requirements in the DPA Administrator Guide.

  • You can also install DPA in the Azure Marketplace. The DPA virtual machine contains a DPA server on Windows and a built-in Microsoft SQL Server database instance configured as the DPA repository.

  1 - 20 Monitored DB Instances 21 - 50 Monitored DB Instances 51 - 100 Monitored DB Instances 101 - 250 Monitored DB Instances*
CPUs 1 2 4 4
RAM Dedicated to DPA 1 GB 2 GB 4 GB 8 GB
OS Architecture 64-bit 64-bit 64-bit 64-bit
OS
  • Windows Server 2008 R2
  • Windows Server 2012 R2
  • Windows Server 2016
  • Windows 8.1
  • Windows 10

* If you plan to monitor more than 250 database instances, consider using more than one DPA server and linking the servers together.

Other requirements and recommendations:

  • The DPA server must have network connectivity to the DPA repository and to all the database instances you will monitor.
  • The DPA server must be available at all times.
  • Do not install DPA on a server that runs applications whose performance is critical.
  • SolarWinds does not recommend installing DPA on a server with monitored database instances.
  • DPA can be installed on the same server as the repository, but this is not recommended.

Repository database requirements

Before you configure the repository database, a supported database instance must be installed on the database server.

Supported SQL Server database versions

The repository database can be configured on the following versions of SQL Server:

  • Microsoft SQL Server 2008 R2 SP3
  • Microsoft SQL Server 2012 SP3
  • Microsoft SQL Server 2014 SP2
  • Microsoft SQL Server 2016 SP1

Standard or Enterprise editions are recommended. Express editions are supported, but they are not recommended for production environments because of the database size limits.

The repository database can also be configured on an instance of MySQL or Oracle. For all supported versions, see Repository database requirements in the DPA Administrator Guide.

Do not host the repository on a database instance that you plan to monitor, because this affects the performance of that instance.

Repository database server

The database server must meet the following minimum requirements. If you install DPA on the same server as the repository database, the server must meet these requirements in addition to the DPA server requirements.

  1 - 20 Monitored DB Instances 21 - 50 Monitored DB Instances 51 - 100 Monitored DB Instances 101 - 250 Monitored DB Instances
CPUs 2 2 4 4
Reserved RAM 4 GB 8 GB 8 GB 16 GB
OS Architecture 64-bit 64-bit 64-bit 64-bit

Disk space for the repository database

The amount of disk space your repository uses is determined by the number of database instances you are monitoring and the activity level of each instance.

Database Instance Activity Level Disk Space Required

Low

1 GB

Medium

3 GB

High

5 GB

Example

You are monitoring five low, three medium, and two high activity database instances.

(5 × 1 GB) + (3 × 3 GB) + (2 × 5 GB) = 24 GB

Reserve at least 24 GB to provide adequate disk space for this repository database.

Supported web browsers

You can use the following browsers to access the SolarWinds DPA web interface:

  • Microsoft Edge
  • Microsoft Internet Explorer 11

    Do not use IE compatibility view. It may cause DPA to function incorrectly.

  • Mozilla Firefox: latest stable version
  • Google Chrome: latest stable version
Last modified
15:20, 29 Sep 2016

Tags

Classifications

Public