This module provides automatic instrumentation for mssql
There are 2️⃣ variations
This is the recomended variation. The source code can be found here
npm install --save opentelemetry-instrumentation-mssqlconst { NodeTracerProvider } = require('@opentelemetry/node'); const { registerInstrumentations } = require('@opentelemetry/instrumentation'); const { MssqlInstrumentation } = require('opentelemetry-instrumentation-mssql'); const traceProvider = new NodeTracerProvider({ // be sure to disable old plugin plugins: { mssql: { enabled: false, path: 'opentelemetry-plugin-mssql' } } }); registerInstrumentations({ traceProvider, instrumentations: [ new MssqlInstrumentation({ // see under for available configuration }) ] });MSSQL instrumentation has few options available to choose from. You can set the following:
| Options | Type | Description |
|---|---|---|
ignoreOrphanedSpans | boolean | Set to true if you only want to trace operation which has parent spans |
| Instrumentation Version | OTEL Version |
|---|---|
0.0.2 | 0.15.0 |
0.1.1 | 0.16.0 |
0.2.1 | 0.17.0 |
0.3.1 | 0.18.0 |
This variation would be depreciated soon. The source code can be found here
npm install --save opentelemetry-plugin-mssqlimport {LogLevel} from '@opentelemetry/core' import {NodeTracerProvider} from '@opentelemetry/node' import {registerInstrumentations} from '@opentelemetry/instrumentation' // Enable OpenTelemetry exporters to export traces to Grafan Tempo. const provider = new NodeTracerProvider ({ plugins: { mssql: { enabled: true, // You may use a package name or absolute path to the file. path: "opentelemetry-plugin-mssql", }, }, logLevel: LogLevel.ERROR, }); registerInstrumentations({ tracerProvider: provider });| Plugin Version | OTEL Version |
|---|---|
0.1.0 | 0.15.0 |
0.2.0 | 0.16.0 |
0.3.0 | 0.17.0 |
Supported
Request.queryConnectionPool.queryConnectionPool.request
Future
Request.executeRequest.batchRequest.bulkConnectionPool.batch
Start mssql server as follows (for development)
docker run -p 1433:1433 -d -e ACCEPT_EULA=Y --name otmssql -e SA_PASSWORD=P@ssw0rd mcr.microsoft.com/mssql/server