Get the latest news about SolarWinds Database Performance Analyzer (DPA)
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…
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…
It looks like you're new here. Sign in or register to get started.