SolarWinds
Database Performance Analyzer (DPA)
Pinpoint database slowness with wait-time analysis across many engines.
Database Performance Analyzer (DPA) is SolarWinds' specialised database monitoring tool, and its defining technique is wait-time analysis. Rather than just reporting CPU or memory, DPA measures what queries are actually waiting on — disk I/O, locks, latches, memory, CPU — and attributes that wait time to specific SQL statements, programs, and times. This answers the operational question directly: which queries are slow, and what resource are they blocked on.
A time-and-motion study for the database: instead of noting the kitchen is busy, it records that the chef spent most of the shift waiting for one oven — telling you precisely what to fix.
Key Concepts
1
DPA is agentless (it queries the database's own performance views) and supports many engines — SQL Server, Oracle, MySQL, PostgreSQL, and others — including cloud-managed databases. It trends performance over time, baselines normal behaviour, flags anomalies, and recommends tuning (indexes, problematic SQL). For interviews, the key concept is wait-based analysis: it reframes "the database is slow" into "this query spent 70% of its time waiting on lock contention", which is far more actionable than host-level metrics alone.