How do you stop dependency sql from being logged?

[s21-himesh]

I've tried the following options to try dependency sql logs to stop being logged in the applicationinsight.json file. However, they keep being logged:-

{ "preview": { "generalExportQueueCapacity": 4096 }, "connectionString": "InstrumentationKey=xxxxxxxxxxxxxxxx;IngestionEndpoint=https://uksouth-1.in.applicationinsights.azure.com/;LiveEndpoint=https://uksouth.livediagnostics.monitor.azure.com/;ApplicationId=xxxxxxxxxxxxxxxxxxxxxxxx" }, "role": { "name": "xxxxxxxxxxxxxx" }, "sampling": { "percentage": 20, "requests": { "percentage": 20 }, "dependencies": { "percentage": 1 } }, "instrumentation": { "logging": { "level": "warn" }, "micrometer": { "enabled": true } }, "jdbc": { "enabled": false }, "dependencies": { "excludedTypes": ["SQL"] } }

Example Log:-

Event time | 12/06/2025, 11:33:32.048 (Local time) |   -- | -- | -- Type | SQL |   Call status | true |   Duration | 306 μs |   Name | SQL: INSERT _meta_menu.meta_connect__32 |   Operation Id | db194a11e7cf42651dac8c69a2352ab2 |   Parent Id | db194a11e7cf42651dac8c69a2352ab2 |   Id | 278785e33b46242b |   Performance | <250ms |   Telemetry type | dependency |   Device type | PC Base name | h2 \| _meta_menu -- | --

[zoomingrocket]

@s21-himesh - You can add in your JSON sampling overrides to shut off a particular dependency type.
Go through this link for examples - https://learn.microsoft.com/en-us/azure/azure-monitor/app/java-standalone-sampling-overrides

[s21-himesh]

Hi @zoomingrocket,

Thanks for your response. I've tried more things with no joy:-

{ "connectionString": "InstrumentationKey=**************************;IngestionEndpoint=https://uksouth-1.in.applicationinsights.azure.com/;LiveEndpoint=https://uksouth.livediagnostics.monitor.azure.com/;ApplicationId=***********************", "role": { "name": "****************" }, "preview": { "generalExportQueueCapacity": 4096 }, "sampling": { "percentage": 20, "requests": { "percentage": 20 }, "overrides": [ { "telemetryType": "dependency", "attributes": [ { "key": "type", "value": "SQL", "matchType": "strict" } ], "percentage": 0 } ] }, "instrumentation": { "logging": { "level": "warn" }, "micrometer": { "enabled": true }, "dependency": { "enabled": false } }, "jdbc": { "enabled": false }, "dependencies": { "excludedTypes": ["SQL"] } }