Get the latest news about SolarWinds Database Performance Analyzer (DPA)
As part of the procedure for installing the SSL certificate for the DPA Configure DPA to use a custom certificate for SSL/TLS (solarwinds.com). These steps require the password for the Keystore file: C:\Program Files\SolarWinds\DPA\iwc\tomcat\conf\server.xml How can we retrieve or reset the Keystore password?
Hello - I am looking to update to 2023.2.1.504 and have a question about the HTTP to HTTPS part that needs to be done so users can still access DPA. 1. Does this change to the server.xml have to be done after the update has been done? 2. Can I do something now to change how everyone connects to they connect via HTTPS prior…
What are the minimum roles and privileges required for the Solarwinds Database Performance Analyser service account? Because the security team and security best practices consider granting the Enterprise and Domain Admins privileges to be excessive. Based on this KB article: Register a SQL Server instance for DPA…
blocking details has perfect GUI sent it customer or analysing in excel it is become problematic if you run copy paste you details of blocking truncated I tried to extract data using query provided in…
On the DPA, I am seeing a recommended index for a column on one of the DB tables due to "Inefficient table/index access steps discovered by DPA" from a cluster index scan with an estimated number of rows of 6M. There are also the warnings "Parallelism warning" and "Predicate - no index". The predicate here is the same…
I have a need to dig into the numbers collected for the Round Trip metric. I am not seeing a way to put a custom date/time range to view numbers collected in the past - only last hour, day, week, month, etc. Preferably, I would like to see the individually collected numbers instead of averaged/mean/whatever numbers DPA…
Hello! We are looking to migrate all things Solarwinds to 2022. I wanted see if anything has changed in 4+ years. https://thwack.solarwinds.com/product-forums/database-performance-analyzer-dpa/f/forum/10727/moving-dpa-repository-to-new-sql-server Currently monitoring up to 100 databases, some Azure, and also use the VM…
On the DPA start page we have this nice overview table of how all instances are. Wouldn't it be nice to have that in an Orion view as well! The number of widgets in Orion for DPA information is a bit limited. So is also the information in Orion database about DPA status. Almost all info for this exist though. So we created…
When I open a query plan to review, the message displays The plan 4022976130 does not have any text. Has the plan been purged from Cache? Is there a way to see the plan or query it from SQL?
We have recently seen a sudden jump in the frequency a specific user-defined function is called. Can DPA be used to identify the call stack, to show us the most frequent callers for this function?
It looks like you're new here. Sign in or register to get started.