Get the latest news about SolarWinds Database Performance Analyzer (DPA)
Hello all, we recently upgraded one of our production applications. Since then TPS has dropped about 60%. Just trying to to determine if this is good or bad. Waits and blocking are noticeably down, so that is good. Any TPS input would be greatly appreciated. Thank you, David
Hi, We have an scenario when an app fails and some queries start running on our operational DB. The queries will change but they all use CHANGETRACKING which is specific to that app. I would like an alert that will notify us when DPA sees any query with CHANGETRACKING in the text. I found a custom alert that goes directly…
Description This alert will watch for SQL statements that execute and contain a specific string. For example, if you think a specific table is no longer being used and you want DPA to let you know if it sees any SQL with that table name in it, you can use this alert. Alert Definition To create this alert, click on Alerts >…
Hi, I have been trying to find a way to export all DPA settings, or at least the alarms created, so they can be imported in other DPA installations. I can't seem to find a way to do this. Is it possible? Thank you
DESCRIPTION This alert will query data already collected by DPA to be used in a custom alert. It will trigger based on thresholds you establish for estimated data loss due to latent AG replication. ALERT DEFINITION To create this alert, click on Alerts > Manage Alerts tab and create a Custom Alert of type Custom SQL Alert…
We have some DBs in Azure and were able to get them connected but it says we need a license. Are there different licensing needed for Azure? Can we get a temporary one to see if it will work? Thanks -Dave
Description This alert uses the system view named DBA_TABLESPACE_USAGE_METRICS (Oracle 11.2+) to calculate the free space remaining in all tablespaces. It includes both data and temp tablespaces as well as takes autoextend data files into account. Alert Definition To create this alert, click on Alerts > Manage Alerts tab…
Hello, We recently had an issue with an asynchronous AG replica that was far behind in replication. See attached. Is there a way to set up an alert that would fire if the estimated data loss exceeds a certain threshold? I don't find anything obvious at the moment in DPA. Thanks!
Hello all, I have to go through a process of hardening my SQL Server database servers, and one thing that has been detected is that in the SQL Server database repository for DPA, the "guest" account has been granted "CONNECT". Obviously this has been set by the DPA installation process, as this is a non-default setting,…
We want our NPM reports to read from out Secodnary AlwaysON SQL Server. Is this possible? Support has not been much help at all. Case # 00244458
It looks like you're new here. Sign in or register to get started.