SolarWinds Database Performance Analyzer consists of:
- A SolarWinds DPA server
- A SolarWinds DPA repository database
- One or more database instances you want to monitor
The SolarWinds DPA server collects performance data from a set of database instances you choose to monitor. SolarWinds DPA stores this data in the repository database.
For optimal performance, the DPA server, repository database, and the monitored database instances must reside on the same high-speed LAN. If your environment contains database instances that are on separate LANs, SolarWinds recommends creating a repository database on each LAN. For cloud monitoring, SolarWinds recommends deployment to the same region.
The SolarWinds DPA server provides a web interface that displays performance data in a web browser from any computer with access to the SolarWinds DPA server.
SolarWinds recommends installing one SolarWinds DPA instance on a computer. If you must install multiple instances on the same computer, submit a support ticket.
Two key functions of the DPA server
- Collect data from the monitored database instances and store the data in the repository database.
- Provide a web interface that displays performance data from any computer with access to the SolarWinds DPA server. From this interface, you can configure monitoring, alerting, and email reports.
Monitored database instances
SolarWinds DPA remotely connects to each database instance using Java Database Connectivity (JDBC). SolarWinds DPA causes less than 1% overhead on the instance. No software is installed on the monitored server.
Monitored virtualization environment
In a virtual environment, SolarWinds DPA can remotely connect to each VMware vCenter Server, ESX, or ESXi host. SolarWinds DPA causes less than 1% overhead on the monitored systems. No software is installed in the vCenter Server, ESX or ESXi host, or virtual machines.