Database Performance Analyzer consists of:
- A DPA server
- A DPA repository database
- One or more database instances you want to monitor
The DPA server collects performance data from a set of database instances you choose to monitor. 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 DPA server provides a web interface that displays performance data in a web browser from any computer with access to the DPA server.
SolarWinds recommends installing one 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 DPA server. From this interface, you can configure monitoring, alerting, and email reports.
Monitored database instances
DPA remotely connects to each database instance using Java Database Connectivity (JDBC). DPA causes less than 1% overhead on the instance. No software is installed on the monitored server.
Monitored virtualization environment
In a virtual environment, DPA can remotely connect to each VMware vCenter Server, ESX, or ESXi host. 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.