Get the latest news about SolarWinds Database Performance Analyzer (DPA)
What are DPA's capabilities for monitoring and troubleshooting when [tempdb] runs out of space? Can DPA... * Identify SPIDs/transactions consuming the most space in [tempdb]? * Identify related SQL statements of SPIDs/transactions? * Identify [tempdb] file space usage (size, allocated size, unallocated size, version store…
I see it in the Online Demo but according to former release notes it is not supported. (In 2020.2 Release notes - DPA can no longer be used to monitor SQL Server 2008 R2 database instances.) Is this some demo trickery? This is the main reason we have not upgraded past v2019.4.
I need help figuring out why Single Sign-on is not working. I have implemented AD groups in DPA and it is working, but we cannot figure out why the single sign-on is not working. Using the steps from SolarWinds Knowledge Base :: Configuring DPA for Single Sign-On, I have the files created and in place, but after the…
I have a custom alert that captures DB sizes and stores that in the con_alert_history_results table in the DPA Repository. I had previously adjusted a configuration option to store 365 days of data, but it seems that an upgrade somewhere along the way changed things. Can anyone tell me which setting controls when data is…
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…
It looks like you're new here. Sign in or register to get started.