[db] Add docs for context info propagation

[sincejune]

Relevant to #2162

Changes

Added documentations for instrumentations to propagate context information to databases

Merge requirement checklist

• [x] CONTRIBUTING.md guidelines followed.
• [x] Change log entry added, according to the guidelines in When to add a changelog entry.
  • If your PR does not need a change log, start the PR title with [chore]
• [ ] schema-next.yaml updated with changes to existing conventions.

[pellared]

@open-telemetry/semconv-db-approvers, PTAL

[nenadnoveljic]

Added documentations for instrumentations to propagate context information to databases

Should we clarify that this article is specific to MS SQL Server, since context_info is only available there? Other databases like Oracle and Postgres can use fields like v$session.action or application_name to propagate tracecontext.

[sincejune]

Added documentations for instrumentations to propagate context information to databases

Should we clarify that this article is specific to MS SQL Server, since context_info is only available there? Other databases like Oracle and Postgres can use fields like v$session.action or application_name to propagate tracecontext.

@nenadnoveljic I only added the context_info section to the SqlServer's documentation, so I believe we should be fine with that. What do you think?

[XSAM]

I have refactored the PR to the following structure. @trask @nenadnoveljic @zacharycmontoya PTAL

• For every database
  • Put service.name on sql comments.
• For sqlserver (extension)
  • Put traceparent value via SET CONTEXT_INFO (opt-in)

---

Failed CI is irrelevant to this PR. https://github.com/open-telemetry/semantic-conventions/actions/runs/15172537474/job/42665853199?pr=2236 (fix)

[github-actions[bot]]

This PR was marked stale due to lack of activity. It will be closed in 7 days.

[cheempz]

Just saw this and very interested in any effort to clarify the role of sqlcommenter in OTel. @tammy-baylis-swi and i will be sharing our learnings at the Open Observability Summit June 26th, would love to talk about it with any maintainers or TC members there.

[XSAM]

Superseded by #2495