I'm using Azure Application Insights for a website (Azure App Service). On that I'm using a clustered Umbraco setup and hangfire. These two alone keep hitting the database every minute and are flooding my 'App Insights'.

So my question is, how do I disable the Sql Dependency Tracker? I've had a look at the ApplicationInsights.config and couldn't find anything obvious. I can see Microsoft.ApplicationInsights.DependencyCollector which is probably responsible, but I don't want to remove all types of dependency telemetry, only sql.

Thanks

CodePudding user response：

Your best bet here is to use a Telemetry Processor to filter out certain types of dependency requests. Check out these resources below for information.

Sometimes the sqlBackend.Name property has values like . | Hangfire | Open, or . | Hangfire | sp_getapplock, but the Target property is still just ``. | Hangfire` e.g.: