Troubleshoot data collection
Fix problems with collecting data from your Microsoft SQL Server database server or service.
Check these settings:
All the metrics that the Splunk Distribution of OpenTelemetry Collector collects by default are activated. Since these metrics are activated by default, you don't need to take any action unless you've deactivated them.
Your YAML override file is compatible with the latest changes in the Helm chart.
(For Microsoft SQL Server databases) Your OpenTelemetry collector's
receivers.sqlserver.serveris set to the fully qualified domain name (FQDN) or IP address of your Microsoft SQL Server database service. For example, in the context of a Kubernetes internal DNS system, if the service name ismssql-serverand the namespace ismssqltest,receivers.sqlserver.servershould bemssql-server.mssqltest.svc.cluster.local.When navigating to a database instance from the Database Monitoring Overview page, you see at least six tabs. If only you only see three tabs (Queries, Query samples, and Query metrics), it means that your OpenTelemetry collector's metrics pipeline, which sends database infrastructure metrics collected by the database receiver, is not configured properly. For help with metric pipeline configuration, see the documentation for Microsoft SQL Server receiver or Oracle Database receiver.