Get the latest news about SolarWinds Database Performance Analyzer (DPA)
I just upgraded to DPA v 21.3.7438 and now when I try to get to active alerts, I get this page error. Anyone have any clue why?
DPA's Ignite service (tomcat8.exe) took CPU to 100%, which lasted for almost 30 mins. During which number of connections to DPA DB almost doubled. This behaviour kicks off around midnight. Does anyone know what exactly DPA does in the background? To me, it looks like a scheduled maintenance or index analysis kind of job.…
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…
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
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
Hey there, Is there a way to install DPA on Windows through Powershell (or command line)? Thanks
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?…
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?
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…
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…
It looks like you're new here. Sign in or register to get started.