nadersam (2/20/2012)

---

Hi All,

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.

Nader