How do we increase running the health check attempt

Problem

Heath check keeps on failing and upon restarting it passes. 

Resolution

We can increase the value in MAXIMUM_HEALTHCHECK_RETRY_COUNT in tbl_pj_controlsetting and restart the Distributed services , this will help in decrease the health check as the health check up will rerun when it fails 

 IF EXISTS(select TOP 1 1 from tbl_pj_ControlSetting where [key] ='MAXIMUM_HEALTHCHECK_RETRY_COUNT')

UPDATE tbl_pj_ControlSetting  SET [Value] ='4' WHERE [key] ='MAXIMUM_HEALTHCHECK_RETRY_COUNT'

ELSE

INSERT INTO tbl_pj_ControlSetting  ([Key],[Value],AdditionalNotes)

SELECT 'MAXIMUM_HEALTHCHECK_RETRY_COUNT', '4', 'Distributed service and plugin health checkup retry count'