SolarWinds uses cookies on our websites to facilitate and improve your online experience. By continuing to use our website, you consent to our use of cookies. For further details on cookies, please see our cookies policy.

Hide this message.

      • Orion Platform
      • Enterprise Operations Console (EOC)
      • User Device Tracker (UDT)
      • Network Performance Monitor (NPM)
      • IP Address Manager (IPAM)
      • VoIP & Network Quality Manager (VNQM)
      • Netflow Traffic Analyzer (NTA)
      • Network Topology Mapper (NTM)
      • Log Analyzer (LA)
      • Network Configuration Manager (NCM)
      • Server & Application Monitor (SAM)
      • Server Configuration Monitor (SCM)
      • Application Performance Monitor (APM)
      • Database Performance Analyzer (DPA)
      • Storage Resource Monitor (SRM)
      • Web Performance Monitor (WPM)
      • Virtualization Manager (VMAN)
      • SolarWinds Backup
      • Access Rights Manager (ARM)
      • Patch Manager
      • Threat Monitor
      • Security Event Manager (SEM)
      • Dameware Remote & Mini Remote Control
      • ipMonitor
      • Mobile Admin
      • Dameware Remote Everywhere (DRE)
      • Kiwi CatTools
      • Serv-U MFT & Serv-U FTP Server
      • Engineer's Toolset (ETS)
      • Kiwi Syslog Server
      • Web Help Desk (WHD)
      • Papertrail
      • Pingdom
      • Loggly
      • AppOptics
    • SolarWinds Smart Start Onboarding
    • SolarWinds Premier Support
    • Academy
    • eLearning
    • Classes
    • Certifications
  • Community
  • Customer Portal
  • Submit a Ticket
  • Contact Us
  • SolarWinds.com
  • Government
  • Customer Portal
  • Partners
  • Contact
 
  • PRODUCTS
    • Network Management
      • Orion Platform
      • Enterprise Operations Console (EOC)
      • User Device Tracker (UDT)
      • Network Performance Monitor (NPM)
      • IP Address Manager (IPAM)
      • VoIP & Network Quality Manager (VNQM)
      • Netflow Traffic Analyzer (NTA)
      • Network Topology Mapper (NTM)
      • Log Analyzer (LA)
      • Network Configuration Manager (NCM)
    • Applications & Systems
      • Server & Application Monitor (SAM)
      • Server Configuration Monitor (SCM)
      • Application Performance Monitor (APM)
      • Database Performance Analyzer (DPA)
      • Storage Resource Monitor (SRM)
      • Web Performance Monitor (WPM)
      • Virtualization Manager (VMAN)
      • SolarWinds Backup
    • Security & Compliance
      • Access Rights Manager (ARM)
      • Patch Manager
      • Threat Monitor
      • Security Event Manager (SEM)
    • Tools
      • Dameware Remote & Mini Remote Control
      • ipMonitor
      • Mobile Admin
      • Dameware Remote Everywhere (DRE)
      • Kiwi CatTools
      • Serv-U MFT & Serv-U FTP Server
      • Engineer's Toolset (ETS)
      • Kiwi Syslog Server
      • Web Help Desk (WHD)
    • Cloud
      • Papertrail
      • Pingdom
      • Loggly
      • AppOptics
  • ONBOARDING
      SolarWinds Smart Start Program

      This program gives customers and partners one-on-one expert guidance, enabling them to quickly and effectively configure, customize and optimize their SolarWinds environments.

      Learn More About SolarWinds Smart Start
      SolarWinds Premier Support

      Access to a designated, experienced support team who understands your environment and IT management goals. Includes health checks and scheduled upgrade- and optimization-assistance.

      Learn More About SolarWinds Premier Support
  • TRAINING
      Academy

      The SolarWinds Academy provides relevant and high quality education programs for IT Professionals. Our training curriculum promotes a comprehensive understanding of the SolarWinds portfolio of products through certifications, instructor-led classes, and eLearning videos.

      Learn More About Academy
      eLearning

      The online eLearning library contains training videos to help you learn about your product and setup, including key features and popular optimizations.

      Learn More About eLearning
      Classes

      The SolarWinds Academy offers both fundamental and intermediate level classes where you can learn about your products deployment, configuration, and more.

      Learn More About Classes
      Certification

      The SolarWinds Certified Professional program is a suite of product certifications that shows you have the knowledge and skills needed to manage and administer SolarWinds software.

      Learn More About Certification
  • COMMUNITY
  • CUSTOMER PORTAL
SUBMIT A TICKET CONTACT US
Documentation forDatabase Performance Analyzer
  • Release Notes
    • DPA 12.1.701 Release Notes
    • DPA 12.1 Release Notes
    • DPA 12.0 Release Notes
    • DPA 11.1 Release Notes
    • DPA 11.0 Release Notes
    • DPA 10.2 Release Notes
    • DPAIM 11.1.1 Release Notes
    • DPAIM 11.1 Release Notes
    • DPAIM 11.0 Release Notes
    • DPAIM 10.2 Release Notes
  • Install or Upgrade
    • DPA Installation and Upgrade Guide
    • DPA installation overview
    • DPA installation preflight checklist
    • DPA system and monitoring requirements
      • DPA system requirements
      • Database versions you can monitor
      • Requirements for monitoring MySQL database instances
    • Install DPA
      • Install DPA on Windows
      • Install DPA on Linux
      • Install DPA on Azure Marketplace
    • Create the repository database
      • Create a SQL Server repository database
      • Create an Oracle repository database
      • Create a MySQL repository database
      • Create an Azure SQL Database repository database
    • Uninstall DPA
    • Upgrade DPA
      • Upgrade DPA on Windows
      • Upgrade DPA on Linux
      • Upgrade DPA on an Amazon Machine Image instance
      • Upgrade DPA on an Azure VM
  • Get Started
    • DPA Getting Started Guide
    • How do I get started with DPA?
    • Register database instances
      • Register a single SQL Server database instance
      • Register a virtual machine and view performance data
    • Investigate performance issues
      • The DPA approach to investigating performance issues
      • Investigate an application performance problem with DPA
      • Investigate an increase in wait time with DPA
    • Create a DPA alert to monitor SQL statement execution time
    • Create a DPA report to track wait types for a single SQL statement
    • After evaluation, activate DPA licenses
    • Integrate DPA with the Orion Platform
    • Beyond Getting Started with DPA
  • Administer
    • DPA Administrator Guide
    • Introduction
      • Introduction to DPA
      • DPA architecture
    • DPA licensing
      • DPA license types
      • DPA registration and licensing options for clustered environments
      • Requirements for monitoring a database instance running in a VM cluster
      • Purchase and view DPA licenses
      • Activate DPA licenses
      • Allocate or deallocate DPA licenses
      • Troubleshoot over-allocated DPA licenses
      • Deactivate your DPA licenses
    • Register a database instance for monitoring with DPA
      • Database instances DPA can monitor
      • Register multiple database instances
      • Register an Oracle database
      • Register a SQL Server database
      • Register a Sybase database
      • Register a DB2 database
      • Register a MySQL database
      • Register an Amazon RDS for Oracle database
      • Register an Amazon RDS for SQL Server database
      • Register an Amazon RDS for MySQL or Aurora database
      • Register an Azure SQL database
      • Register an Azure SQL managed instance
      • Unregister a monitored database instance
    • Database instance groups
      • About monitoring SQL Server Availability Groups with DPA
      • About monitoring Oracle multitenent databases (CDBs)
      • Manually group database instances
    • Monitor database instances with DPA
      • Update a monitored database instance
      • Stop monitoring a database instance for a period of time
      • DPA troubleshooting tips
    • Investigate performance issues with DPA
      • Access DPA query or table tuning advisors
      • Use DPA's query performance analysis to find the root cause of performance issues
      • Investigate inefficient queries running against a table
      • Identify blocking sessions and deadlocks with DPA
      • Find and investigate unusually long wait times (anomalies)
      • About anomaly detection in DPA
      • Add an annotation to document a change to the database
    • Manage SQL statement properties
      • Name SQL statements
      • Exclude SQL statements from DPA charts and analysis
      • Add excluded SQL statements back to DPA charts and analysis
    • Resource metrics in DPA
      • View resource metrics in DPA
      • About DPA resource metric baselines
      • View or change DPA resource metric thresholds
    • DPA user accounts
      • DPA roles and privileges
      • Create a DPA user account and assign privileges
      • DPA user authentication options
      • Configure DPA to use Active Directory or LDAP
    • DPA alerts
      • View the status of DPA alerts
      • Configure a DPA alert
      • Send SNMP traps from DPA alerts
      • Stop DPA alerts for a period of time
      • Use DPA to alert on increases in SQL wait times
      • Create a custom DPA alert to display the name of the active node in a SQL Server cluster
      • Create a DPA alert group
      • Create and manage DPA contacts and contact groups
      • Notification policy for DPA alerts
    • DPA reports
      • About DPA reports
      • Access and run DPA reports
      • Create a DPA report
      • Schedule a DPA report for email delivery
      • Create a DPA report group
    • Link together separate DPA servers
      • Set up a Central Server and add remote DPA servers
      • Configure authentication for the DPA Central Server
      • View information from remote servers on the DPA Central Server
      • Advanced configuration for the DPA Central Server
    • Automate tasks with the DPA REST API
      • Manage the tokens used for authentication to the DPA API
      • Learn about and experiment with the DPA API
      • Examples of using Python scripts to make DPA API calls
      • Examples of using PowerShell scripts to make DPA API calls
    • DPA administrative tasks
      • Stop and start DPA
      • Set advanced DPA configuration options
      • Enable SNMP Monitoring in SCOM
    • View DPA data in the Orion Web Console with DPAIM
      • Architecture of the DPA Integration Module
      • DPA and SAM integration with DPAIM
      • DPA and SRM integration with DPAIM
      • Azure SQL support with DPAIM
      • DPAIM integration overview
      • Requirements for the DPA Integration Module
      • Prepare SAM applications for DPAIM integration
      • Set up the DPA Integration Module
      • Manage relationships to database instances, applications, and storage objects
      • DPAIM relationship detection
      • DPAIM Discovery Central
      • DPA data in the Orion Web Console
      • DPA alerting in the Orion Platform
      • DPA reporting in the Orion Platform
      • Database instances in the AppStack environment
      • Customize a DPAIM view and apply limitations
      • DPAIM account limitations
      • Troubleshooting DPAIM issues
  • Release Notes
    • DPA 12.1.701 Release Notes
    • DPA 12.1 Release Notes
    • DPA 12.0 Release Notes
    • DPA 11.1 Release Notes
    • DPA 11.0 Release Notes
    • DPA 10.2 Release Notes
    • DPAIM 11.1.1 Release Notes
    • DPAIM 11.1 Release Notes
    • DPAIM 11.0 Release Notes
    • DPAIM 10.2 Release Notes
  • Install or Upgrade
    • DPA Installation and Upgrade Guide
    • DPA installation overview
    • DPA installation preflight checklist
    • DPA system and monitoring requirements
      • DPA system requirements
      • Database versions you can monitor
      • Requirements for monitoring MySQL database instances
    • Install DPA
      • Install DPA on Windows
      • Install DPA on Linux
      • Install DPA on Azure Marketplace
    • Create the repository database
      • Create a SQL Server repository database
      • Create an Oracle repository database
      • Create a MySQL repository database
      • Create an Azure SQL Database repository database
    • Uninstall DPA
    • Upgrade DPA
      • Upgrade DPA on Windows
      • Upgrade DPA on Linux
      • Upgrade DPA on an Amazon Machine Image instance
      • Upgrade DPA on an Azure VM
  • Get Started
    • DPA Getting Started Guide
    • How do I get started with DPA?
    • Register database instances
      • Register a single SQL Server database instance
      • Register a virtual machine and view performance data
    • Investigate performance issues
      • The DPA approach to investigating performance issues
      • Investigate an application performance problem with DPA
      • Investigate an increase in wait time with DPA
    • Create a DPA alert to monitor SQL statement execution time
    • Create a DPA report to track wait types for a single SQL statement
    • After evaluation, activate DPA licenses
    • Integrate DPA with the Orion Platform
    • Beyond Getting Started with DPA
  • Administer
    • DPA Administrator Guide
    • Introduction
      • Introduction to DPA
      • DPA architecture
    • DPA licensing
      • DPA license types
      • DPA registration and licensing options for clustered environments
      • Requirements for monitoring a database instance running in a VM cluster
      • Purchase and view DPA licenses
      • Activate DPA licenses
      • Allocate or deallocate DPA licenses
      • Troubleshoot over-allocated DPA licenses
      • Deactivate your DPA licenses
    • Register a database instance for monitoring with DPA
      • Database instances DPA can monitor
      • Register multiple database instances
      • Register an Oracle database
      • Register a SQL Server database
      • Register a Sybase database
      • Register a DB2 database
      • Register a MySQL database
      • Register an Amazon RDS for Oracle database
      • Register an Amazon RDS for SQL Server database
      • Register an Amazon RDS for MySQL or Aurora database
      • Register an Azure SQL database
      • Register an Azure SQL managed instance
      • Unregister a monitored database instance
    • Database instance groups
      • About monitoring SQL Server Availability Groups with DPA
      • About monitoring Oracle multitenent databases (CDBs)
      • Manually group database instances
    • Monitor database instances with DPA
      • Update a monitored database instance
      • Stop monitoring a database instance for a period of time
      • DPA troubleshooting tips
    • Investigate performance issues with DPA
      • Access DPA query or table tuning advisors
      • Use DPA's query performance analysis to find the root cause of performance issues
      • Investigate inefficient queries running against a table
      • Identify blocking sessions and deadlocks with DPA
      • Find and investigate unusually long wait times (anomalies)
      • About anomaly detection in DPA
      • Add an annotation to document a change to the database
    • Manage SQL statement properties
      • Name SQL statements
      • Exclude SQL statements from DPA charts and analysis
      • Add excluded SQL statements back to DPA charts and analysis
    • Resource metrics in DPA
      • View resource metrics in DPA
      • About DPA resource metric baselines
      • View or change DPA resource metric thresholds
    • DPA user accounts
      • DPA roles and privileges
      • Create a DPA user account and assign privileges
      • DPA user authentication options
      • Configure DPA to use Active Directory or LDAP
    • DPA alerts
      • View the status of DPA alerts
      • Configure a DPA alert
      • Send SNMP traps from DPA alerts
      • Stop DPA alerts for a period of time
      • Use DPA to alert on increases in SQL wait times
      • Create a custom DPA alert to display the name of the active node in a SQL Server cluster
      • Create a DPA alert group
      • Create and manage DPA contacts and contact groups
      • Notification policy for DPA alerts
    • DPA reports
      • About DPA reports
      • Access and run DPA reports
      • Create a DPA report
      • Schedule a DPA report for email delivery
      • Create a DPA report group
    • Link together separate DPA servers
      • Set up a Central Server and add remote DPA servers
      • Configure authentication for the DPA Central Server
      • View information from remote servers on the DPA Central Server
      • Advanced configuration for the DPA Central Server
    • Automate tasks with the DPA REST API
      • Manage the tokens used for authentication to the DPA API
      • Learn about and experiment with the DPA API
      • Examples of using Python scripts to make DPA API calls
      • Examples of using PowerShell scripts to make DPA API calls
    • DPA administrative tasks
      • Stop and start DPA
      • Set advanced DPA configuration options
      • Enable SNMP Monitoring in SCOM
    • View DPA data in the Orion Web Console with DPAIM
      • Architecture of the DPA Integration Module
      • DPA and SAM integration with DPAIM
      • DPA and SRM integration with DPAIM
      • Azure SQL support with DPAIM
      • DPAIM integration overview
      • Requirements for the DPA Integration Module
      • Prepare SAM applications for DPAIM integration
      • Set up the DPA Integration Module
      • Manage relationships to database instances, applications, and storage objects
      • DPAIM relationship detection
      • DPAIM Discovery Central
      • DPA data in the Orion Web Console
      • DPA alerting in the Orion Platform
      • DPA reporting in the Orion Platform
      • Database instances in the AppStack environment
      • Customize a DPAIM view and apply limitations
      • DPAIM account limitations
      • Troubleshooting DPAIM issues

DPA Installation and Upgrade Guide

Use this guide to prepare for installation and install Database Performance Analyzer (DPA). It also provides instructions for upgrading and uninstalling DPA.

PDF

  • Prepare for a new installation
    • Get an overview of the installation process and complete the pre-installation checklists.
    • DPA installation overview
    • DPA installation preflight checklist
  • DPA requirements
    • Review the requirements for installing DPA and monitoring database instances.
    • DPA system requirements
    • Database versions you can monitor
    • Requirements for monitoring MySQL database instances with DPA
  • Install DPA
    • Install DPA a Windows or Linux server, or in the cloud.
    • Install DPA on Windows
    • Install DPA on Linux
    • Install DPA on Azure Marketplace
  • Create the repository database
    • Create the DPA repository database, which stores monitoring user credentials and the performance data that DPA collects from monitored database instances.
    • Create a SQL Server repository database
    • Create an Oracle repository database
    • Create a MySQL repository database
    • Create an Azure SQL Database repository database
  • Uninstall DPA
    • You might need to uninstall and then reinstall DPA to resolve an issue or to move to a new server during a migration.
    • Uninstall DPA
  • Upgrade DPA
    • Prepare for and complete an upgrade to the latest version of DPA.
    • Prepare to upgrade DPA
    • Upgrade DPA on Windows
    • Upgrade DPA on Linux
    • Upgrade DPA on an Amazon Machine Image instance
    • Upgrade DPA on an Azure VM

Do you have feedback? We're listening. Contact Us

  • Privacy
  • EULA
  • Terms of Use
  • Trademarks
  • Product Documentation & Uninstall
  • Email Preference Center
© 2003-2019 SolarWinds Worldwide, LLC All rights reserved