SQL Server service resource does not fault even if detail monitoring fails

This issue may occur when detail monitoring is configured and IMF is enabled for SQL Server agents. (2536297)

If detail monitoring fails (either the database becomes unavailable or there is a failure in the detail monitoring script), the SQL service resources fault and VCS may then fail over the service group if the agent's FaultOnDMFailure attribute is set to 1.

It is observed that when IMF is enabled for SQL Server agents, the SQL service resources does not fault. Instead, the SQL Agent service resource (SQLServerAgent) faults.

This occurs because when detail monitoring fails, the SQL Server service agent invokes the clean function and as a result the SQL database engine service goes for a restart. As the SQL Agent service depends on the database service, the database service first stops the SQL Agent service as part of its own restart process. IMF instantly detects that the SQL Agent service has stopped and as a result the SQL Agent resource (SQLServerAgent) in the service group faults. As the SQL Agent resource has faulted, VCS initiates a fail over of the service group. The SQL Server service resource receives this VCS initiated offline and therefore does not fault in response to the original detail monitoring failure event.

Workaround: There is no known workaround for this issue at this time.