Get the latest news about SolarWinds Database Performance Analyzer (DPA)
Is this "Database Peformance Analyzer - Subscription (Linux)" (you can Google "aws marketplace dpa subscription" as well) still valid? I tried reaching out to dpa-aws@solarwinds.com (listed on this page) and it bounced. My Sales contact at Solarwinds for my upcoming renewal isn't aware of this subscription option and…
Hello - My post from 2 weeks ago is gone in the whirl of new THWACK so let's try this again. A THWACK user was able to help me with the account lockout script which is working great. SELECT CASE WHEN LOGINPROPERTY(name, N'IsLocked') = 1 THEN 'The login ' + name + ' was locked out at ' + CAST(LOGINPROPERTY(name,…
We are running DPA 2025.3 against AWS RDS PostgreSQL database at version 14.17. We see these persistent errors coming from the PREPARE dpaprepare() statement sent by the monitor utility. How do we resolve (or interpret) these errors? Is there anything we need to configure? 2025-10-21 23:03:27…
We have been using SolarWinds DPA for quite a while. One of our monitored database instances had been on SQL 2017. When we Enabled Deadlock Collection, an Extended Events session named dpa_deadlock_capture was created. It had an event_file target for saving event data to *.xel files, which were created in this path:…
Can I create a report that will send me the top index recommendations from a server? For example, can it send me these values in a report once a week?
DPA 24.X & 25.x does not list MS SQL 2016 as supported databases. My question is can we still monitor SQL 2016, not expecting any support. We are upgrading from DPA 2023.4
I am able to get the ignite service to run with a gMSA account, but when I try to map a database with the gMSA account, I get the following error. Exception thrown executing [AnnotatedAction@2b702ce8 targetAction = [RepointMonDbAction@f27dda6 formObjectName = 'idcFormData', formObjectClass = RepointMonDbData,…
need to setup the alert monitoring to get the query details hat's impacting the hard synchronization process — likely in an Availability Group with synchronous commit mode., does anyone has any idea about it.
Hi, we use DPA 2025.2 with some multi database SQL Server. On one of them we get an error 422, if we open the Tuning section in DPA. The index advisor is empty and in iwc.log this: ERROR (2025-06-26T14:57:02,930+0200) [https-jsse-nio-443-exec-2-rest-229] RestExceptionHandler:371 - RestResponse{data=null,…
The stored procedure having (Inserts is part of stored proc) is waiting for long time and Plan Hash showing Insert operation Clustered Index cost is 100%, Wondering how to resolve the issue ? The insert table has primary index and multiple non clustered indexes, wondering if excessive indexes will have any impact while…
It looks like you're new here. Sign in or register to get started.