Get the latest news about SolarWinds Database Performance Analyzer (DPA)
We recently upgraded DPA from version 10.2 to version 2020.2. One item I can not find in the new version is the query history. Am I missing something? Has it been moved?
DPA on Windows running MySQL 5.7 I tried to change the password in the Admin, but it said the way to reset the password is to edit repo.properties and restart DPA. That doesn't work. It fails and goes to the error screen. The one where it says, "if the port has changed." I've tried doing it the way they say with…
Is the DPA product also vulnerable to Sunburst? Running v2020.2.731
If the DPA Server is unexpectedly down, follow these steps to detect if it crashed and to also gather diagnostic information to provide to SolarWinds Support. * Review the content of this directory and see whether there are files with *.mdmp and *.log extensions.* Go to <DPA_install_dir>\iwc\tomcat directory * Look for the…
In DPA there is an option to set custom privileges and roles to a DPA user. This is discussed here https://documentation.solarwinds.com/en/Success_Center/dpa/Content/DPA-DPA_Roles_Privileges.htm What is some cumbersome in DPA however is getting an audit of these custom permissions for a large list of users. In the options…
Hi all, We're trying to use IIS on a Windows 2019 server that has DPA installed. We recently added the IIS role and bound a new IP address to the server for IIS to use, but it appears (from netstat) that Tomcat for DPA is using port 80 on all IPs and the IDC_WIZARD_SECURE_URL is binding to the IP that we're trying to use…
I am new to the community and to Solarwinds, that being said I am in need but to pull execution counts for a specific query. I know that in the GUI I can drill down to the query and see executions and wait time per execution but only for a couple hour time period. I need the counts of the query execution by Minute or hour…
A third Release Candidate of SolarWinds Database Performance Analyzer (DPA 2020.4 RC3) is now available. You can download the DPA release candidate from the SolarWinds Customer Portal. DPA 2020.4 RC3 resolves a problem experienced by a few customers where the DPA Server periodically crashes after a few days. You can…
I had thought the ERD for DPA stored metrics for the wait types Total IO Wait, Total Read IO Wait, and Total Write IO Wait in the relevant CON_METRICS_DAY_(n) table. However after querying these tables, and comparing them to the data displayed in DPA resource graphs, I find the numbers to be completely different. Any…
With the release of the Database Performance Analyzer 12.1 and the Management API, I have started developing a PowerShell module called PSDPA. The module is now available through the PowerShell Gallery and GitHub. I would still consider this release a "beta" release, as not everything has been implemented and not…
It looks like you're new here. Sign in or register to get started.