Get the latest news about SolarWinds Database Performance Analyzer (DPA)
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…
If you'd like to find out more about Database Performance Analyzer Release Candidates (current and future), please join the DPA RC Thwack Forum to get notifications and details!
showing me connection problem while trying to make connection with solarwinds Database Performance Analyzer. Server (Name or IP)= 10.57.38.181 Port = 1433 Authentication: Sql Server Authentication SYSADMIN Login: tajamul Password:abcd Suggestions: Try the IP address instead of the server name; ping the database server from…
All, Is there a setting or configuration or is it already available in DPA to get this info or I need to run off-shelf queries to find this info from SQL Server DB? Thanks Gladias
I want to know the best approach whether to use temporary tables #Tablename or permanent tables to store and update data temporary
It looks like you're new here. Sign in or register to get started.