nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Database Performance Analyzer (DPA)

Database Performance Analyzer (DPA) Feature Requests
Newsroom
Get the latest news about SolarWinds Database Performance Analyzer (DPA)

Recent Discussions

Table deletion is not captured in this tool
Please let me know the way to look deletion executed queries in this tool when finding exact time from the server to solarwinds tool the statement show " SQL statement not available" kindly help me to find the delete statement in the solarwinds tool
Solarwinds DBA Guide.pdf
Briefly written step by step Solarwinds Database monitoring guide.
Solarwinds Database Monitoring
I have been assigned a task to monitor the database of our company. We have around 25 SQL servers and I am currently looking for a tool to monitor the best. The major KPI's that we want to monitor are 1- CPU Wise Most Expensive Queries 2- Queries Having Most Physical Reads 3- Long Running Stored Procedures and Scripts 4-…
Smart queries
Has someone compiled queries to run against the dpa_repository database for some insight into tuning metrics versus GUI option? e.g. I researched these DPA tables and trying to decipher data ! [dpa_repository].[ignite].[CONST_9] [dpa_repository].[ignite].[CONSPT_9] [dpa_repository].[ignite].[CONSPA_9]…
Trigger all alerts to send emails
Is there a way to trigger *all* alerts setup to be sent? Maybe in some sort of test mode? I'm configuring over 30 alerts across 4 servers right now, and it's simply not efficient to test these 1 by 1. Especially since the test doesn't show actual text, just place holders.
DPA Alerts and dpa.body
The documentation outlines this variable consists of alert status link, the alert notification text, and the value that triggered the alert. However, if I try to format my own email with the alert message, I cannot get it. The alert.notificationText pulls the text from the alert definition, not the alert that was…
DPA Custom Email Template and alert.status.message
I'm trying to display either the alert.notificationText or the alert.status.message. I had assume one or the other would be blank base on the status value (BROKEN or one of the other values). So in my template I have it formatted like such: <b>Alert Message</b> [=alert.notificationText][=alert.status.message] That way…
Alerting on new and dropped databases
Is there a way to monitor for databases that are either dropped or added? Using SolarWinds DPA 2019.4.1054 for SQL Server.
Alerts - to assign databases instances in the alert definition or through Alert Groups
To me, it seems like creating alerts with no database instances selected and assigning the servers via Alert Groups would be the best option. But are there any alerts that this will not work on? For example, lets say one alert is supported on 2012 and later, but one of my servers is 2008. Or take the Windows Service Not…
SQL Server Error Log alerts
With the way the SQL Server error log alert is designed, I have to create 1 alert for every "clause" I want to search for. For example "Error" would be 1 alert, "Fail" would be another alert, and "whatever other string" is yet another alert... and so on. Well, if I were to model what SCOM does, there are several hundred…