• Same for me. The alert does not fire.

    SQLServer: Resource Pool Stats

    Counter: CPU usage%

    Instance: default

    Alert when couter rise above: 0.01

    I do have alerts for different stuff that works fine.