Get the latest news about SolarWinds Database Performance Analyzer (DPA)
We are using DPA version 12.0.3083. We are tracking a performance issue an hour earlier and found a few queries having some wait time. Using the drill-down, we are able to see the query context except one. This particular one would only show 'Sql Statement not available'. From other DPA info, we know it is a query from our…
How to create a custom alert/message on DPA for deadlocking or locking taking more than 1 minutes of time thanks Subhash
I had tried to add users and with AD group but not able to login with that users, Can anyone suggest for me step by step its DPA installed at Windows OS. Thanks Subhash
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…
It looks like you're new here. Sign in or register to get started.