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

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.
Upgrade to DPA 2024.2 Repository Question
We are currently running DPA 2023.2.1 which is running on Server 2016/SQL 2016. We have plans to upgrade DPA this year to new servers once we upgrade Orion to new servers. We are in the process of upgrading the Orion nodes now. I received the email about updating DPA to 2024.2 and going over the release notes it says that…
CUSTOM ALERT - DEADLOCK MySQL Aurora Version
in reference to the CUSTOM-ALERT DEADLOCK written for repository SQL SERVER This is for anyone needing it fixed for MySQL Aurora code: SELECT char(13) + char(10) + 'URL: SRVEFEVMDPA:8123/.../deadlockDetails.iwc' + CAST(DB_ID as CHAR) + '&dl_id=' + CAST(DB_ID as CHAR) + char(13) + char(10) , 1 FROM ( SELECT #DBID# AS DB_ID,…
Database Performance is Life and Death for Hospitals
Database Performance is Serious business for Hospitals I had an eye-opening lunch the other day with one of our clients. I’ll call him Mr. R. Mr. R.'s title is one we are going to see more of in the future as IT, Data, and Hospital Operations keep merging into one amalgamous blob that is almost indecipherable as individual…