Get the latest news about SolarWinds Database Performance Analyzer (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?
Our DBA team uses both DPA and SQL Sentry to monitor all things database. We had an issue kind of creep up that we noticed in DPA and I was asked the question "What does DPA use for metrics in VMWare?" What does Disk Red mean? I was trying to find the answer on Solarwinds site but got stuck in the Buy Me Now loop. Is there…
TLDR: In DPA 2023.2.0.501, connections to instances using AAD accounts appear to no longer work. Change your connections to use local SQL Server accounts instead before you upgrade. Issue might have been introduced by the MS JDBC driver update to version 12.2, in version 2023.2.0.501. Hi, After upgrading to…
I went to upgrade a new DPA instance and I noticed the download for DPA version 2023.2.0.501 was no longer available from my customer portal. I also see the Thwack page announcing that version being Generally Available is now a dead link. A quick forum search and I don't see any announcements about pulling that version. I…
It looks like you're new here. Sign in or register to get started.