Sqlserver probe does not sent out alarms after threshold breach.
Make sure 'Generate status only ' and 'Suppress All Alarm' are not selected in probe UI. Equivalently keys setup\suppress_all_alarms and setup\report_only are set to 'no' in probe raw config.
The 'Generate status only ' will control whether alarms will be raised after threshold breach. When set to 'yes', no alarms will be raised according to checkpoint threshold defined in the profile.
The 'Suppress All Alarm' option when set to 'yes' will suppress any alarms from sqlserver probe including checkpoint execution alarms.