Ingesting Metrics from SQLServer

[amurilloc]

Hi, does anyone had any success importing metrics from SQLServer on Self Hosted? This is what my Otel Config looks like on the SQLServer machine. It has a local port mapped to the SigNoz instance inside a Linux VM:

receivers:
  sqlserver:
    collection_interval: 30s
    username: sa
    password: "*********"
    server: 127.0.0.1
    port: 1433

exporters:
  debug:
    verbosity: detailed
    sampling_initial: 5
    sampling_thereafter: 200
  otlp:
    endpoint: "localhost:4317"
    tls:
      insecure: true

service:
  telemetry:
    logs:
      level: INFO
  pipelines:
    metrics:
      receivers: [sqlserver]
      exporters: [otlp, debug]

Log exporter is showing it is sending the data to SigNoz (self-hosted inside a VM, port mapped to the host):

otelcol-contrib.exe --config sqlserver-metrics-collection-config.yaml
2024-10-14T18:40:24.544-0600    info    [email protected]/service.go:136 Setting up own telemetry...
2024-10-14T18:40:24.544-0600    info    telemetry/metrics.go:70 Serving metrics {"address": "localhost:8888", "metrics level": "Normal"}
2024-10-14T18:40:24.545-0600    info    builders/builders.go:26 Development component. May change in the future.        {"kind": "exporter", "data_type": "metrics", "name": "debug"}
2024-10-14T18:40:24.546-0600    info    [email protected]/service.go:208 Starting otelcol-contrib...     {"Version": "0.111.0", "NumCPU": 16}
2024-10-14T18:40:24.546-0600    info    extensions/extensions.go:39     Starting extensions...
2024-10-14T18:40:24.784-0600    info    [email protected]/service.go:234 Everything is ready. Begin running and processing data.
2024-10-14T18:40:25.880-0600    info    MetricsExporter {"kind": "exporter", "data_type": "metrics", "name": "debug", "resource metrics": 13, "metrics": 66, "data points": 67}
2024-10-14T18:40:25.880-0600    info    ResourceMetrics #0
Resource SchemaURL:
ScopeMetrics #0
ScopeMetrics SchemaURL:
InstrumentationScope github.com/open-telemetry/opentelemetry-collector-contrib/receiver/sqlserverreceiver 0.111.0
Metric #0
Descriptor:
     -> Name: sqlserver.page.buffer_cache.hit_ratio
     -> Description: Pages found in the buffer pool without having to read from disk.
     -> Unit: %
     -> DataType: Gauge
NumberDataPoints #0
StartTimestamp: 2024-10-15 00:40:24.5460031 +0000 UTC
Timestamp: 2024-10-15 00:40:25.8788183 +0000 UTC
Value: 100.000000
ResourceMetrics #1
Resource SchemaURL:
ScopeMetrics #0
ScopeMetrics SchemaURL:
InstrumentationScope github.com/open-telemetry/opentelemetry-collector-contrib/receiver/sqlserverreceiver 0.111.0
Metric #0
Descriptor:
     -> Name: sqlserver.user.connection.count
     -> Description: Number of users connected to the SQL Server.
     -> Unit: {connections}
     -> DataType: Gauge
NumberDataPoints #0
StartTimestamp: 2024-10-15 00:40:24.5460031 +0000 UTC
Timestamp: 2024-10-15 00:40:25.8788183 +0000 UTC
Value: 4
ResourceMetrics #2
Resource SchemaURL:
ScopeMetrics #0
ScopeMetrics SchemaURL:
InstrumentationScope github.com/open-telemetry/opentelemetry-collector-contrib/receiver/sqlserverreceiver 0.111.0
Metric #0
Descriptor:
     -> Name: sqlserver.lock.wait.rate
     -> Description: Number of lock requests resulting in a wait.
     -> Unit: {requests}/s
     -> DataType: Gauge
NumberDataPoints #0
StartTimestamp: 2024-10-15 00:40:24.5460031 +0000 UTC
Timestamp: 2024-10-15 00:40:25.8788183 +0000 UTC
Value: 4.000000
ResourceMetrics #3
Resource SchemaURL:
ScopeMetrics #0
ScopeMetrics SchemaURL:

However, I can't find any data in the clickhouse tables, or maybe I don't know where to find it.

Any guidance would be greatly appreciated.

Update: Tested vs Cloud version and the ingestion works correctly. Only self hosted is not ingesting.