to follow, share, and participate in this community. Not a member? Join Now!
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... 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_Y... 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 firstname.lastname@example.org if ... 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: Application So... 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 re... 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 ... I want to add critical for selective jobs under 'SQL Server Job Failure' alert type. How can I do that ? Not seeing excessive CPU utilization and have allocated the max that SQL 2017 will allow for RAM and he'll have plenty of overhead for the OS. For instance I'm seeing a lot of wait time sourced from CPU/RAM this morni... Hello DPA. I was planning on updating the version of DPA that we run until one of the DBAs pointed out this feature below. So at this point it looks like I will have to remain on 12.1.6 until at some ... Hi Team, We are seeing huge amount of growth in following tables which store execution plan and query text, I would like to check following things: Can I check if purging is working\not working? Any w... I'm positive I'm not the first to ask this, but I spent about 20 minutes looking for the answer must have lost my ability to search today... Can someone point me to instructions on how... Hello, We have been testing a NetApp SSD to compare performance from our Hitachi SAN. One of our "problem" databases is SolarWinds_NPM which has an enormous amount of WRITELOG waits. After migrating the... Hi, I need an alert that sends a message when the actual tempdb usage is 80%. Our tempdb is pre-sized but I need to know when it close to filling up. I have DPA 12.1.698 installed using MySQL 5.7.9 (hey, it's free - don't judge ). I want to run queries directly against the DPA repository to yield the same results as Perfstack would. Longer story but I a... I dont see the above metrics being tracked in DPA for my SQL Server 2005 instance. Does DPA track those metrics? For installation of a DPA data repository in an MSSQL server, can it use an already existing login that is dbo in an already existing db For registering an instance of a MSSQL server to be monitored, can I run... I would like to know and suggest the opcion to add the graphics or other information and send it by mail in AUTOMATIC way or using the SCHEDULLER as a task scheduled at night to send by mail. I found a manually opcion... Hi, I want to create a alert when the PLE < 300seconds. Which values should I use for calculation and percentage?