Get the latest news about SolarWinds Database Performance Analyzer (DPA)
Using the latest version of DPA, how can I view the SQL Agent job that is hogging resources?
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…
I am going to start here in the DPA area. How do you setup and also monitor SQL AG groups? I tried searching in THWACK but ended up with quite a few dead links. We have quite a few SQL AG and I know in the past I have read through some documents on how to set this up but cannot find any of these now. Thank you! - Dave We…
Description The query below will provide detailed metric values for any metric in the instance, e.g. the metrics shown on the Resources tab in DPA> Query DECLARE @DBID varchar(100), @MetricName varchar(50), @SQL varchar(1000); -- change the instance name here, matches the name shown in the Home page SELECT @DBID = ID FROM…
is there any way we can details on the thread counts that we see on the UI from the database. we are using DPA to monitor sqlservers and would like to get the dm_os_threads and dm_os_workers. I can get the data in the UI. For my analysis can we get the same level of details from the database dpa_ignite... Please let me…
Hi, DPA sends all the alerts with a link to https://[servername]:[port]/iwc/... etc. But that server address is a different one created in our DNS, "someotherfancyname.domain.com". How can I change that reference? Is it saved in some table? Thanks!
Our company has an initiative to remove all Oracle-derived Java from the enterprise, so if we must use an Oracle-supplied JVM for DPA, this will cause us some heartache. Does DPA support the use of AdoptOpenJava, which is what our company is moving to for all Java applications? Can I just install that on the DPA server and…
With the SQL TEXT or within DPA is there away of seeing the paramteers passed by the stored procedure? Thanks Clive
We are looking at ways to reduce space used in repository database on MS SQL server database Can we implement page compression on repository database tables ?
The support document linked below has to do with removing sysadmin privileges from the DPA monitoring user account on a SQL Server instance. https://support.solarwinds.com/Success_Center/Database_Performance_Analyzer_(DPA)/Knowledgebase_Articles/SQL_Server_permissions_for_DPA_monitoring We are evaluating v12 of DPA and the…
It looks like you're new here. Sign in or register to get started.