We have had a number of events that should have generated alarms, but no alarms are generated by the sqlserver probe.
You need to uncheck 'Generate Status Only' in the Setup > General tab of the sqlserver probe.