Get the latest news about SolarWinds Database Performance Analyzer (DPA)
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…
I need to fetch the blocking session details as we see on the UI with SPID, Blocking time, Program Name & machine name. I have checked in in CONSW table and able to fetch Program name, machine name & SPID of blocking session as suggested in CONSW Column Definition. But for blocking time I am unable to build any logic. I…
Greeting All. I have inherited an installation of DPA with DPAIM configured. However, it appears that some metrics do not transfer successfully from my one DPA instance into SAM - AppInsight for SQL (such as top fragmented indexes). I suspect that I need to unregister and re-register my server in DPAIM. DPA documentation…
I've recently configured SAML authentication on my DPA servers. For all other applications in our environment—such as ServiceNow and our internal HR portal—we use a single sign-on (SSO) URL that automatically logs users in via SAML. However, with DPA, when accessing the default URL (https://<server_name>/iwc/login.iwc),…
My certificate (SSL) is expiring and while working on setting up AD/SAML authentication I found the "Trusted Certificate Management" in the GUI. I noticed when I imported the root certificate for AD configuration it was requesting the password for the keystore. Can I import my new certificate (SSL) in this manor instead of…
Is there a way to create a report just show the 'Anomaly Detection' chart of N days only and schedule it to send to email daily? Thanks.
We have our DPA repository running on the same MS SQL servers as our SolarWinds database. But... they run in separate SQL Instances - instances SOLARWINDSINSTANCE and DPAINSTANCE. Again, two instances on the same servers. Servers are set up as Always On Failover Clusters. Each AG (Availability Group) has its own 'listener'…
We installed DPA 2024.4 which supports using a gMSA Account for monitoring. The monitoring is working perfectly, as are Alerts that do not use a sql query to determine the Alert condition/status. Any alert on any Instance that needs to execute a database query is failing with this error: "A connection to the monitored…
It looks like you're new here. Sign in or register to get started.