How can I trace Database operations with opentelemetry in ASP.NET Core?

Question

I have an ASP.NET Core Web API project, let's call it projectA.

ProjectA connects to a MySQL database.

Project A simply does this:

get a request
then make a query to the connected MySQL database
then return response to request

I want to measure time spent for database operation and send result to Jaeger.

For http requests opentelemetry automatically measure time spent for request and send results to jaeger.

How can I do the same thing with opentelemetry for database operations?

user_15270218 · Answer

You need to enable SQL Client instrumentation when configuring your tracer provider.

using OpenTelemetry.Trace;

public class Program
{
    public static void Main(string[] args)
    {
        using var tracerProvider = Sdk.CreateTracerProviderBuilder()
            .AddSqlClientInstrumentation()
            .AddConsoleExporter()
            .Build();
    }
}

Here's the official documentation: https://github.com/open-telemetry/opentelemetry-dotnet/tree/main/src/OpenTelemetry.Instrumentation.SqlClient#readme

How can I trace Database operations with opentelemetry in ASP.NET Core?

1 Answers