Get the latest news about SolarWinds Database Performance Analyzer (DPA)
To receive updates on the DPA roadmap, JOIN thwack and BOOKMARK this page Here is a partial list of the things we are currently working on. Your comments and feedback are always welcome and have been vital in shaping Database Performance Analyzer into the product it is today. We are always listening, so please forward your…
I would like to get a count of the number of sessions (over a period of time) for a specific database user from specific machines on a specific database instance (Oracle). I see the DB Active Transaction count in the Resources tab, but you are unable to drill down and see what users and the remote machines where those…
Is there a way to make DPA use a ssh tunnel to connect to postgres DBs I have in aws? Any postgres tool I've ever used (pgadmin, dbbeaver, datagrip) has the option to connect to the DB this way.
How to Create a Custom Alert for long running queries from repository for SQL?
Hi People, I wanted to monitor 2 nodes Virtualized SQL Server 2017 Enterprise database cluster Always On, therefore I wonder if DPA can have some alert like the below: * SQLServer: Availability Replica object provides performance counters that are used to monitor the performance of AlwaysOn availability replicas. *…
I have read the DPA KB Article on issues related to the revoked code-signing certificate. We need clarity on which version I can download to replace our existing 2019.4.1054 version with a like version so we are not affected by the certificate revocation. We are not able to upgrade our DPA as we are still monitoring SQL…
We currently have 61 Category 2 licenses and at some point we were able to use these licenses in Azure to monitor SQL instances there. Is that still the case or was something changed that we have to purchase separate licensing to monitor SQL in Azure now? Thanks! - Dave
We are using DPA 2021.1 version to monitor MSSQL instance and I'd like to know if there is a way to set up alert on SP based on wait time per execution. Some SP , in normal time, wait time per execution is less than 10 millionSec. If wait time per execution is above 100 millionsec, I want to receive an alert. I've checked…
Hello We have hit some limitations with application compatibilities due to VEEAM backups and VSS snapshots cause long I/O freeze times. Does anyone have an idea how we might use DPA to monitor this? Been done before? Basically, in order to do it manually, we have to search the SQL logs, get the I/O frozen start time…
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…
It looks like you're new here. Sign in or register to get started.