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

Monitor HA pair or the individual servers?
Stupid question I'm sure, but in an effort to limit the amount of necessary licenses, is monitoring the HA pair sufficient in lieu of monitoring the actual servers themselves? Thanks!
List all Unused Indexes using DPA database
I want to list all MSSQL Indexes which are unused from the last system restart and compile them for a cleanup. Could you please suggest if we could query DPA database to get the details.
Can DPA monitor and alert on table growth and data usage?
We're looking to track table growth over time, and alert on sudden spikes in data growth. We also want to track and alert on data usage (i.e. queries against the data). Is there a way to leverage DPA to accomplish either of these? If so, has anyone done either of these using DPA? I know DPA can do custom metrics, but I…
Custom Alert Status Return - No Notifications
Type Custom SQL Alert - Single Alert Status ReturnDescription Executes a user-defined SQL statement that will return a single string value that represents an alert status. Valid values are: NORMAL, INFO, LOW, MEDIUM, HIGH This alert monitors the status of commands to ensure they are executed correctly. It captures issues…
Availability Group - what nodes and listeners need to be registered?
Greetings All. A few months ago I inherited a DPA installation (ver. 2024.3). I'm a pretty good Solarwinds admin but have never worked with DPA before. License renewal time coming up and, since I am now the DPA 'guru' I'm asked how many licenses do we need to cover our SQL AG's? Taking an example cluster - call it 'AG1': >…
Custom report || active sessions count per monitored instances across DPA
Hi All- As subjected, need help in creating a report to check active sessions count per monitored instances across DPA. The reason i am doing this as we are facing issue with memory leak and causing outages. Saw below in system requirements These are estimates. They are based on testing done with an average of 2-3 active…
Can you do dynamic notifications on alerts?
Is there a way to have a simple alert like a IO Waits that when it gets triggered will go to a notification group based on some property like the ServerName or Database Name or Custom Property? So you have a bunch of different environments that different groups are responsible for and don't want to create a separate alert…
Trends view is showing short video screen but doesn't show the trends
Solarwinds DPA is showing only video screen in TRENDS view and not showing and not letting us go into view the trends. All other screens are showing the data. The only change that was made was repository database user but it has same permissions as the old user
Custom Alert - if a particular query is using more than N percentage of memory resources
As subjected need help in creating a custom alert for few SQL database instances where in if we can know if a particular query is using more than N percentage of memory resources. Not sure if this is correct way to check against a SQL statement, as in i see most of the parameters its against is only Waittime
DPA Repo ERD
Where can I find documentation on how the repo tables are populated. Specifically I am looking to understand consw and conss. Tks.