CA UIM sqlserver probe does not alert even if some metrics reaches threshold.
 

Release:
Component: UIMSQS

This is because the option 'Generate status only' under Setup tab is checked by default.
When it is checked the probe generates status and not an alarm when the threshold is breached.
 

sqlserver probe IM configuration:
https://docops.ca.com/ca-unified-infrastructure-management-probes/ga/en/alphabetical-probe-articles/sqlserver-sql-server-monitoring/sqlserver-im-configuration