Microsoft.Data.SqlClient.Internal.Logging

Microsoft.Data.SqlClient.Internal.Logging

⚠️ Internal Package — Do Not Reference Directly

This package is intended for internal use by the SqlClient suite of packages only. It is not designed for direct consumption by application code and may undergo breaking changes without notice.

Description

This package provides ETW EventSource tracing and diagnostics for Microsoft.Data.SqlClient. It enables comprehensive logging and telemetry capabilities for SQL Server database operations.

Key Features

• ETW EventSource Integration: Structured logging using Event Tracing for Windows (ETW)
• Diagnostic Listeners: Hook into SqlClient diagnostic events
• Performance Counters: Track connection pool and query performance metrics
• Correlation Support: Integrate with distributed tracing systems

Supportability

This package supports:

• .NET Standard 2.0 (compatible with .NET Framework 4.6.1+, .NET Core 2.0+, and .NET 5+)

Installation

Install the package via NuGet:

dotnet add package Microsoft.Data.SqlClient.Internal.Logging

Or via the Package Manager Console:

Install-Package Microsoft.Data.SqlClient.Internal.Logging

Getting Started

Enable ETW Tracing

Use tools like PerfView or Windows Performance Recorder to capture ETW events:

# Using PerfView
PerfView.exe collect /Providers=*Microsoft.Data.SqlClient.EventSource

Subscribe to Diagnostic Events

using System.Diagnostics;

// Subscribe to SqlClient diagnostic events
DiagnosticListener.AllListeners.Subscribe(new SqlClientObserver());

public class SqlClientObserver : IObserver<DiagnosticListener>
{
    public void OnNext(DiagnosticListener listener)
    {
        if (listener.Name == "SqlClientDiagnosticListener")
        {
            listener.Subscribe(new SqlClientEventObserver());
        }
    }

    public void OnError(Exception error) { }
    public void OnCompleted() { }
}

public class SqlClientEventObserver : IObserver<KeyValuePair<string, object>>
{
    public void OnNext(KeyValuePair<string, object> value)
    {
        Console.WriteLine($"Event: {value.Key}");
        // Process event data...
    }

    public void OnError(Exception error) { }
    public void OnCompleted() { }
}

Event Categories

The logging extension emits events in these categories:

Documentation

• SqlClient Diagnostic Tracing
• ETW Tracing in .NET
• Microsoft.Data.SqlClient Documentation

License

This package is licensed under the MIT License.

Related Packages

• Microsoft.Data.SqlClient - The main SqlClient driver
• Microsoft.Data.SqlClient.Extensions.Abstractions - Core abstractions
• Microsoft.Data.SqlClient.Extensions.Azure - Azure integration extensions