Get the latest news about SolarWinds Database Performance Analyzer (DPA)
Description This alert will run against the monitored Oracle databases and retrieve the time a session has been waiting ("Seconds Blocked" column) on a blocking session. It will also give some details about the blocking session in the "Message" column and this can be customized with anything else from v$session. ALERT…
I would like to know if it is possible to move an existing SQL Server (Express) repository over to MySQL? I don't want to use the full SQL Server for the repository since there are the target of the monitoring and I want the repository separate. I am running up against the 10GB limit in the database. Do all the tables have…
We’re excited to announce the upcoming changes to SolarWinds Database Performance Analyzer (DPA) is now available. You can find the latest version of DPA in your Customer Portal. Note: DPA 2021.1 is the generally available version for the 2020.4 Release Candidates. What’s new? * Find SQL—New SQL Diagnostics Workflow: Find…
Hi I was happy to see the new metrics for MS SQL Server database backups announced in release 2021.1 https://documentation.solarwinds.com/en/Success_Center/dpa/Content/Release_Notes/DPA_2021-1_release_notes.htm How is the behaviour of the metrics if the database is part of a AlwaysOn availability group? E.g. - Two node…
Description This alert will run against the monitored instance and retrieve the time each session has been blocked ("Seconds Blocked" column). It will also give some details about the blocking session in the "Message" column and this can be customized with anything else from sys.dm_exec_requests DMV. Alert Definition To…
Ok, I want to create a DPA Report for "Top Machines Ranked by Cumulative Wait Time". There is an option to Include a machine under "Machines to Display", then "User-Defined Machines", However I want to exclude one or two machines but report on the rest of them. Is there a way to do this? Thanks for any help.
In our organization we have multiple jobs running on different instance, in which few are critical and few are bound to fail, in DPA module we want to configure alert in such a way only if critical jobs are failing will be alerted, rest other jobs need to be ignore. Please help with it, its little urgent. for eg. in…
Hello, we're trying to upgrade DPA 12.0 to latest version available 2020, but, when we try to connect, we receive following message: - DPA Startup in progress. Please wait.......... Then, an error: - Request failed. Try again. Any clue how to solve that? It's a LINUX upgrade. Thanks and Regards. Ademir
Hi Guys, We would like to identify what are OTHER WAITS on Storage IO Monitoring. Is there a way to list or identify them? It must to be a reason to be listed: is it impacting the environment? Is there a way to reduce it? I think there is no sense it be showed just to tell it's not a storage IO issue. Thanks in advance!
Hello! I've been working on an *interesting* request from our audit team regarding some data they want to pull out of the DPA repository. None of the canned reports are giving me exactly what I'm looking for, so I'm hoping the community can help? I actually think I'll have two queries - one for detailed data and one for…
It looks like you're new here. Sign in or register to get started.