db statement (or) tracing database calls.

[francisxx01]

Hi Team,

Issues: We don't see database call and query details that application makes are not visible to Elastic search kibana. We have installed opentelemetry .net agent. We don't have anything at dbstatement. We are using oracle database.

We have .net application runs on iis manager, we have .net framework 4.8 verified from regedit and have configured below system environment variable

OTEL_DOTNET_AUTO_INSTRUMENTATION_ENABLED=true
OTEL_DOTNET_AUTO_INSTRUMENTATION_INCLUDE_SQLCLIENT=true
OTEL_DOTNET_AUTO_TRACE_ENABLED=true
OTEL_DOTNET_AUTO_METRICS_ENABLED=true
OTEL_DOTNET_AUTO_LOGS_ENABLED=true
OTEL_DOTNET_AUTO_SQLCLIENT_SET_DBSTATEMENT=true
OTEL_DOTNET_AUTO_INSTRUMENTATION_LOG_LEVEL=debug
OTEL_DOTNET_AUTO_DEBUG=TRUE

OTEL_DOTNET_AUTO_SQLCLIENT_SET_DBSTATEMENT_FOR_TEXT=true
OTEL_DOTNET_AUTO_ENTITYFRAMEWORKCORE_SET_DBSTATEMENT_FOR_TEXT=true
OTEL_DOTNET_AUTO_ORACLEMDA_SET_DBSTATEMENT_FOR_TEXT=true
OTEL_DOTNET_AUTO_GRAPHQL_SET_DOCUMENT=true
ELASTIC_APM_OPENTELEMETRY_BRIDGE_ENABLED=true
OTEL_DOTNET_AUTO_LOG_DIRECTORY: C:\Program Files\OpenTelemetry .NET AutoInstrumentation
OTEL_LOG_LEVEL: debug
OTEL_EXPORTER_OTLP_ENDPOINT: http://:8200
OTEL_METRICS_EXPORTER: otlp
OTEL_LOGS_EXPORTER: otlp
OTEL_TRACES_EXPORTER=otlp
OTEL_RESOURCE_ATTRIBUTES: service.name=Apriso,service.version=2019,deployment.environment=development

We saw loading sqlclient.dll was succeeded no issues but still we don't see dbstatement.

Please help us to resolve the issues ASAP.

Thanks & Regards,

Francis
9731966646

[TimothyMothra]

This is the SDK repo, we don't work on OpenTelemetry .NET AutoInstrumentation.
If that's what you're using you should post your question on that repo: /~https://github.com/open-telemetry/opentelemetry-dotnet-instrumentation

If you're doing this manually, you should confirm that the Sql Instrumentation library is added to your config. You can review their configuration options here: /~https://github.com/open-telemetry/opentelemetry-dotnet-instrumentation
And you could use the Console Exporter to inspect the telemetry being collected from your application: /~https://github.com/open-telemetry/opentelemetry-dotnet/tree/main/src/OpenTelemetry.Exporter.Console