Cache hit ratio SQL

Question

Morning i keep receving the following alter Component Cache Hit Ratio of Application, which is flooding the alerts mailbox. Is there a way within SAM to adjust the threshold

Thanks

aLTeReGo · Accepted Answer

Most certainly! Simply click the "Edit Application Monitor" button on the "Application Details" resource for the monitoring AppInsight for SQL application.

Then expand the "Cache Hit Ratio" component and click 'Override Template' to adjust the threshold to your liking. Leaving this field blank/empty will remove the threshold entirely so it will no longer alert or change status.