I created an alert under sql server agent alerts.
I selected type as sql server performance condition alert, Object:Sql server :Resource Pool Stats,Counter :Cpu usage %, Instance:default,Alert if:Counter rises above 40.
I made response trigger running a job and notify database operator using email.
I ran some sqls to trigger high CPU usage but the alert is never triggered and nothing happens!!.
Looking forward for your feedback.