cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 8

Monitor Windows processes high CPU excluding SQL

Jump to solution

Hi,

What I want to do is generate an email of processes and how much CPU they're using on servers running SQL Server. The catch is I only want to send an email if CPU usage is over 90% and SQL is using less than 80%, in other words some other process is taking a lot of CPU and we're trying to identify it.

I've set up an alert using " Execute program : APM\SolarWinds.APM.RealTimeProcessPoller.exe...", now I'm looking for ways to refine it.

Thanks!

0 Kudos
1 Solution

Do you have SAM?  MUCH easier to just create a service monitor for your sql instance and then you can build a component alert that says if the sql process is below 80% cpu and node cpuload is >90 then trigger.

- Marc Netterfield, Github

View solution in original post

3 Replies

Do you have SAM?  MUCH easier to just create a service monitor for your sql instance and then you can build a component alert that says if the sql process is below 80% cpu and node cpuload is >90 then trigger.

- Marc Netterfield, Github

View solution in original post

I agree in principal and logic though I could not stop myself from commenting the typo 'cpuload is <90', that should be >90.

(sorry, carryon! )

0 Kudos

Haha yeah that would indeed make a difference

- Marc Netterfield, Github