[feature request] Sending service custom dimensions on Microsoft.Data.SqlClient.EventSource

[gustavodaquino]

Component

OpenTelemetry.Instrumentation.EventCounters

Is your feature request related to a problem?

When using OpenTelemetry.Instrumentation.EventCounters@1.5.1-alpha.1 together with Microsoft.Data.SqlClient@5.2.2, the custom dimensions service.name and service.instance.id are not being sent with the metrics.

Minimal setup to reproduce:

builder.Services.AddOpenTelemetry()
    .UseAzureMonitor()
    .WithMetrics(metrics =>
    {
        metrics.AddEventCountersInstrumentation(options =>
        {
            options.AddEventSources("Microsoft.Data.SqlClient.EventSource");
        });
        metrics.AddView(
            instrumentName: "Microsoft.Data.SqlClient.EventSource",
            new MetricStreamConfiguration
            {
                TagKeys = ["service.name", "service.instance.id"]
            }
        );
    });

What is the expected behavior?

Both service.name and service.instance.id should be sent as custom dimensions on customMetrics bucket, on Azure Monitor.

Which alternative solutions or features have you considered?

I tried unsuccessfully to send them manually, using the extension method AddView.

Additional context

No response

Tip

_{React with 👍 to help prioritize this issue. Please use comments to provide useful context, avoiding +1 or me too, to help us triage it. Learn more here.}

[github-actions]

Tagging component owner(s).

@hananiel @mic-max