My question is an extension to this.
We have SQL Server Agent alerts(Deadlocks, Network IO etc) to monitor SQL Server performance. So i would like to write an alert for CPU increase percentage. Since We are using
SQL Server-2012 standard edition we are not able to write an alert for it. So i have googled and found options like; we can raise an
alert through Perfmon(Performance monitor). Please look below image.
In alert task tab, "
Run this task when alert is triggered" in this box i have given the path of .BAT file (which will run a query and send the current cpu expensive statements in a mail).
But alert is not firing when cpu percentage crosses certain limit. I guess the way i am configuring in perfmon is wrong for cpu alert. Can any one please suggest blogs or links for raising cpu alert from performance monitor? or Please suggest any other way to do this.
Basically, I am trying to call a batch file from performance monitor by using alerts. Please advice.