Get the latest news about SolarWinds Database Performance Analyzer (DPA)
In DPA, I can see that my SQL Server's CPU utilization is riding about 25% during business hours. What is the easiest way for me to see which queries are using the most CPU? e.g. "This stored procedure is contributing to about 10% (2.5% overall) of the CPU usage." This seems to me to be different than monitoring wait stats…
Why is it that I can look at what's going on now and see issues, but the next day nothing? For example, I can look at a specific server and see that there are currently blocked sessions occuring - sometimes way more than the five for a critical. When I look the next day there are none showing at all. Same thing on queries,…
Description This alert will calculate the average blocking time per session and helps you understand the severity of the issue. It is similar to the Total Wait Time for Blocking - Repository alert in that it uses the data already in the repository, but instead of returning a total amount of blocking time, it divides that…
Hello, I find how to get DPA to ignore Query advisors but I don't find the same to turn off table tuning advisors. We have 2 tables in an SAP system that I can't do anything about (without SAP to change them) and they are red all of the time. I would like to ignore these. Is that possible? Thanks!
Hello We have an instance that has 2 availability groups. If we setup monitoring on each AG there is overlap for data collection. In DPA, we see the activity for ALL databases on the server, not filtered by the AGs. This means that we have 2x the data collection that we need. If we remove one of the AGs from monitoring,…
Whenever I add or redefine an Index, I add an Annotation in DPA. These are really useful markers for the current 30 days. What happens to them after the 30-days have gone by? How can I go back further to pull a list of Annotations from my repository? Instance, date-time, title, description, who, are all I can enter in the…
Hi, Does anyone know is it possible to include annotation tags on trending reports. I want to create weekly\monthly reports for management that show how tool is been used by DBA team and having annotations included who show correlation between changes and improvements. Thanks, David
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
It looks like you're new here. Sign in or register to get started.