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

Database Performance Analyzer (DPA)

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

Recent Discussions

automating annotation creation in DPA when objects are changed in SQL
I would like to have an annotation automatically created when objects (stored procedures, indexes, etc.) are created or changed. Does anyone already have a script to do that? Or, just point me to the DPA table(s) I will need to insert, and I can do it myself.
How to create a custom CPU report using DPA
Hello, We need to provide a CPU, Memory, DiskIO report to management every monday.. we are using DPA. Is there a way I can get this data from DAP or can DPA generate such a report for me. Any help is much appreciated.
Is there any way to create custom report for Buffer manager Lazy writes/sec in DPA
I have SQL query for Buffer manager Lazy writes/sec, can I use the same query in DPA and create a custom report in table format, if yes then how can I create a report in table format.? Below is the SQL query: SELECT object_name, counter_name, cntr_value, cntr_type FROM sys.dm_os_performance_counters WHERE [object_name]…
Poling in real time failing
Can you help me, in mid day some times, some graphs in real time stop poling data, but its very random, and i want to know the cause
How do you maintain the size of the DPA repository database?
Can someone point me to any documentation on maintaining the size of the DPA database? Is there an archive feature? Does the application do this automatically?
I/O Write Stalls versus I/O Wait by File (Write Tab)
The MS SQL Tips article below talks about "I/O Stalls" in investigating I/O bottlenecks. In DPA Write performance by file there is also a bar graph Total Wait and I/O Wait By File. Are I/O Wait Stalls the same as the I/O Wait represented in that graph?…
How to install DPA
We have solarwinds DPA installed on our OnPrem server. As we are migrating all our servers to cloud, would like to move DPA to the cloud. Can you please share step by step details for the migraiton. Currently we are on - DPA 2019.4.1054 Is it better we upgrade to newer version. If so pls let me know the installables and…
User group based access using AD authentication for easier user management and segregation
Problem: When we have large number of database servers and multiple users. To onboard users at times we might end up registering each user one by one and provide access to respective server. One way to overcome is to use AD authentication. Create Ad group on how you wish to group the users for particular servers. Use case…
Account in DB but doesn't appear in SolarWinds
I found some accounts in DB but these accounts don't appear in SolarWinds, and I don't why they don't exist in SolarWinds? and Is it safe to remove them ?
Demo DPA - Install DPA on SQL Express with SolarWinds Orion Latest version.
Hello, I would like to Demo DPA and Install DPA on SQL Express with SolarWinds Orion Latest version. Does anyone have steps they can provide during setup on the local server?