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

SSO / AD Login Option
I've recently configured SAML authentication on my DPA servers. For all other applications in our environment—such as ServiceNow and our internal HR portal—we use a single sign-on (SSO) URL that automatically logs users in via SAML. However, with DPA, when accessing the default URL (https://<server_name>/iwc/login.iwc),…
Import Certificate through "Trusted Certificate Management"
My certificate (SSL) is expiring and while working on setting up AD/SAML authentication I found the "Trusted Certificate Management" in the GUI. I noticed when I imported the root certificate for AD configuration it was requesting the password for the keystore. Can I import my new certificate (SSL) in this manor instead of…
N days of 'Anomaly Detection' chart
Is there a way to create a report just show the 'Anomaly Detection' chart of N days only and schedule it to send to email daily? Thanks.
DPA - difficulty monitoring DPA repository
We have our DPA repository running on the same MS SQL servers as our SolarWinds database. But... they run in separate SQL Instances - instances SOLARWINDSINSTANCE and DPAINSTANCE. Again, two instances on the same servers. Servers are set up as Always On Failover Clusters. Each AG (Availability Group) has its own 'listener'…
Configuring Alerts using a sql query with a gMSA
We installed DPA 2024.4 which supports using a gMSA Account for monitoring. The monitoring is working perfectly, as are Alerts that do not use a sql query to determine the Alert condition/status. Any alert on any Instance that needs to execute a database query is failing with this error: "A connection to the monitored…
installing current dpa to monitor sql 2008 R2
can it be done? we purchased 2 liscense of dpa to move around our customers to monitor their sites as needed. first one went smoothly and i am getting data second one failed because my user did not have proper permissions. third one worked up to the point of trying to connect to the insance being monitored. which is sql…
SQL query to fetch Availability group replicas failure readiness & estimated data loss from Solarwinds DPA database
SQL query to fetch Availability group replicas failure readiness & estimated data loss from Solarwinds DPA database. Is there any specific table I can look for to fetch the availability group replicas details.
Query DPA database for CPU Peak% for specified database node
Can anyone help me with query to fetch CPU peak % (last 2 hours) for any specified database node either from DPA reporting database or are any APIs available to fetch this information.
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.