Get the latest news about SolarWinds Database Performance Analyzer (DPA)
I am trying to install DPA 12 in a VM running Windows Server 2012 and SQL Server. When I click on "Create New DPA Repository" there was no response. May I know what is the reason?
This computes the average duration of a job from the job history tables, and computes a number representing how many times longer it is currently running than usual. For example. Job1 usually takes 30 minutes. If it takes 90 minutes, it will return 3. It excludes jobs that take 30 minutes. In my particular environment,…
Can someone please tell me which SQL Server wait types constitute "Memory/CPU" in DPA? It's always the largest portion of my waits and I'm not sure specifically what they are since other CPU waits like SOS_SCHEDULER_YIELD are broken out separately. I have my own job that collects data from sys,dm_os_wait_stats every 30…
If so, we want to talk to you! The DPA team is working on refreshing their registration flows and we have some specific questions related to Oracle. Please email me at carley.cousineau@solarwinds.com if you're interested in helping us out! The Feedback session will last about an hour and you'll receive 3,000 THWACK points…
Hello, I want to know in which database table of solarwinds the number of CPU & Memory spike of a Nodes information gets stored.
Hi have a slight issue in that I am not a DBA so I'm not 100% sure what to look for. We had an issue last night on one of our main BI DBs where IO to the Temp DB drive went nuts; Log Name: ApplicationSource: MSSQLSERVERDate: 19/08/2019 21:25:00Event ID: 833 Task Category: Server Level: InformationKeywords: ClassicUser:…
Hi guys, I have two SQL servers on two different ESX host which have the VM license enabled. Both have a lot of "Host Dropped Received Packets" I see between 50 000 and 150 000 "host dropped received packets", on the Resources, Network tab. SQL Server 1 SQL Server 2: I Googled a bit and also have asked our VM team, Google…
Is it possible to configure MS SQL DPA to monitor only one database in instance? Thanks
We want to monitor a client of ours with DPA but they have a very particular architecture. They have a single DB instance with multiple databases, and we only own one of the databases. We would need DPA to be able to monitor that one DB and only that DB without being able to touch the other DBs in the same instance for the…
I want to add critical for selective jobs under 'SQL Server Job Failure' alert type. How can I do that ?
It looks like you're new here. Sign in or register to get started.