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

DPA Query to report on Top Machines
Hi, Is there a way to get a list of Top Machines connecting to the database instances defined in DPA. I am using the OOB report and the options to customize the report is limited. What I am looking for is the database instance name and the Top Machines connected to it. I am wondering if there is a query to get this data…
Remove Tuning Advisor Column - Main DPA Page
Hello All, I saw a few other Tuning Advisor related topics. None of them answered my question specifically. Is there a way to remove the "Tuning" column completely from the main page? I just don't need to see it, it's always red and I'm currently trying to remove all of the "red" so that DPA isn't crying wolf all the time.…
DPA Upgrade Path from 2021.3 to latest version
Quick question :) Anyone knows the upgrade path for DPA from 2021.3 to latest version please? Thanks in advance.
wait with message commit and not full query text
Hi, I am using DPA 2023.4.300.502 and monitoring a Microsoft sql server instance V 15.0.4355.3. I have been trying to figure out the best way to troubleshoot and get hold on the query text for a query that is contributing to most of wait time on the server see image1/3. The DPA is great to highlight the culprit query wait…
Tuning Advisor
I'm new to SolarWind and I have a question in Tuning Advisor. Does this mean it advise me to create another non-cluster index ? The table already contain cluster index on columns OrderNo and TestCode. And non-cluster index on columns ReceivedDate, HN and OrderDate. When I press Show index DDL. This query message display…
Does DPA capture batch executed stored procedures?
Hi team- I know DPA captures all queries and transactions. I do see the stored procedures ran manually or scheduled ones in DPA - Find SQL. However, not able to see the same SPs if ran as a batch. Any thoughts why? Or do we have limitations on transactions/query pulling from DPA?
remove/unregister database after server has been shutdown
Hi I have shutdown the server. Now trying to remove/unregister Database Instance from DPA but does not allow. Any idea, how it can be
Alert for Round trip
How to create an alert for monitoring round trip time? I see in DPA that there is the critical and warning icons next to the round trip graph but I don't find any way to create an alert for the same.
Can you move DPA repository from MYSQL to MS SQL server
We would like to know if it is possible to move our DPA repository from MYSQL to MS SQL server.
How do I setup DPA alert that notifies me when a database has returned to narnal? I get the alert that lets me know when the DB is spiking or has gone down but I would to receive an alert that let me know that it has returned to normal. Thank you
Hello Everyone, How do I setup a DPA alert that notifies me when a database has returned to normal? I get the alert that lets me know when the DB is spiking or has gone down but I would to receive an alert that let me know that it has returned to normal. Thank you very much.