Cpu-Alert in SQL Server -2012 standard edition 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.
Have you tried the DMV sys.dm_os_performance_counters ? Using this view you can get several perf. counters, where you can sample by intervals to have an idea how your system is going. 

This is the documentation by Microsoft: https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-os-performance-counters-transact-sql

Here you can find a few examples how to use it:
http://www.sqlservercentral.com/articles/Performance+Tuning/71784/

And here is an example how to get your current CPU usage: 

select perfCount.object_name
     , perfCount.counter_name
     , CASE 
            WHEN perfBase.cntr_value = 0
            THEN 0
            ELSE (CAST(perfCount.cntr_value AS FLOAT) / perfBase.cntr_value) * 100
      END AS cntr_Value
FROM
    (select * 
        from sys.dm_os_performance_counters
        where object_Name = 'SQLServer:Resource Pool Stats'
          and counter_name = 'CPU usage %' 
     ) perfCount
inner join (select * 
            from sys.dm_os_performance_counters
            where object_Name = 'SQLServer:Resource Pool Stats'
            and counter_name = 'CPU usage % base'
            ) perfBase
ON perfCount.Object_name = perfBase.object_name