how to identify which db occupying more memory using sqlserver receiver OTEL metrics?

[Maheswari1812]

Hi ,

we have instrumented sql server metrics using OTEL.

https://github.com/open-telemetry/opentelemetry-collector-contrib/blob/main/receiver/sqlserverreceiv...

we have a tempdb ,

1.need to identify space usage ,

2.And which query contributes to more tempdb usage using sqlserver receiver OTEL metrics?

[bishida]

I recommend you first check all the available metrics from this receiver and be sure to enable the ones you want.
https://docs.splunk.com/observability/en/gdi/opentelemetry/components/mssql-server-receiver.html

If you don't see the metrics you need available, you may need to write your own custom SQL to retrieve the metrics you need using another receiver called SQL Query Receiver.
https://docs.splunk.com/observability/en/gdi/opentelemetry/components/sqlquery-receiver.html