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

Display DPA AG information in Orion
Hi, I have been asked if it would be possible to display information about Availability Groups from DPA on a dashboard in Orion. With the help of @kpmarcin we were able to reproduce the following information from DPA as Custom Tables in Orion with the following result: However we had to use some workarounds as there is no…
list of Queries for specific DB
Hello, I would like to know if it is possible with DPA to obtain the list of queries which have been executed on an SQL database within a defined period of time? I saw "Find SQL", but I am missing the chronology of events. Thank you
Slow response on DPA homepage
Hey there, I am experiencing really slow response on DPA homepage, taking between 20-30 seconds to load. Digging into a specific server is all fine, but homepage (dashboard) is super slow. Any ideas? Thanks
Install DPA through powershell
Hey there, Is there a way to install DPA on Windows through Powershell (or command line)? Thanks
How to build URL to a specific time slice.
To assist our App Support team we would like to construct the an Ignite url that will take them to a specific time slice based on the time & date fields in the application log we are monitoring. Where a number of the parameters in the url are obvious some are not so obvious. Is there any guidance url parameters?…
DPA home page sort by group names
I upgraded my DPA to latest version (2021.3.7388) yesterday. After upgrade, found that the list of servers is not sorted by Group Names anymore. Is it a known issue? Is it possible to achieve it?
Change order of reports depending on which server is primary?
We have an Always On Availability Group with a primary and 2 secondary SQL Servers. We routinely fail over to do maintenance. This changes which server is primary/secondary. When we set up reports to be emailed we "hard-code" which server info is first, second, etc on the report. I would like it so that we could always…
correlate SQL HASH with query_id from query store in in SQL server
Hi is anyway I can correlate SQL HASH with query store in in SQL server? I tried collect SELECT H,SUBSTRING(ST,1,4000) FROM ignite.CONST_001 and SELECT [qsq].[query_id], [qst].query_sql_text FROM [sys].[query_store_query] [qsq] JOIN [sys].[query_store_query_text] [qst] ON [qsq].[query_text_id] = [qst].[query_text_id] group…
Upgrade DPA on Linux Script
I've only just started working with Database Performance Analyzer (DPA) running on Linux, but I do have to say that I'm digging it. That is until I had to do my first upgrade. It wasn't a difficult task by any means. Unlike the Windows installation, it installs all the necessary files in a separate folder (by design) and…
How to find out all queries run against a specific database since we started monitoring using DPA?
BI Team is asking me about finding out who has ever run query or queries against a specific database on an instance we are currently monitoring using DPA. T-SQL code to be executed against DPA database will be useful. I am not really looking for a report.