Get the latest news about SolarWinds Database Performance Analyzer (DPA)
The native sql query store does provide one key valuable ability to force a particular query plan once captured. Can or will DPA be able to capture this information and provide recommendations?
I use SW DPA to monitor our SQL production DB's. There is limited reporting options available and none of the options are what I'm looking for. Is there a list of DPA SQL tables that can be used for reporting on: CPU, Memory, Disk that is shown, in graphs, under the RESOURCES tab for each monitored SQL Instance? Thanks
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
It looks like you're new here. Sign in or register to get started.