Docs » Monitor Database Query Performance » Troubleshoot Database Query Performance

Troubleshoot Database Query Performance 🔗

Follow the steps in the following sections to troubleshoot Database Query Performance issues:

Database Query Performance is not turned on 🔗

If you open Database Query Performance and notice the feature is not turned on, go to MetricSets Configuration and check if indexing for Database Query Performance tags is ACTIVE. If it’s not, see Turn on Database Query Performance for instructions to turn on indexing for Database Query Performance tags.

No supported databases available 🔗

If you open Database Query Performance and notice there are no supported databases available, check the following:

  • Ensure you have 1 or more of the types of SQL databases listed in Supported databases in your system.

  • Filter by environment, workflow, service or tags bring databases into view.

  • Ensure you are using the most recent instrumentation library version to make sure the database-related span tags are being ingested. If necessary, upgrade the instrumentation library you’re using.

New query data not processed because cardinality limits are exceeded 🔗

Enabling Database Query Performance turns on indexing for a set of 5 database-related span tags. These tags count toward cardinality limits for indexing span tags.

When the limit is exceeded across all indexed tags in your account, Splunk APM temporarily pauses indexing all Database Query Performance tags to allow for transient spikes in cardinality and manage billing in your account. After 15 minutes, Splunk APM attempts to restart indexing Database Query Performance tags automatically.

If you’re having persistent cardinality issues, try turning off indexing for other high-cardinality span tags to free up cardinality for Database Query Performance. See Limits on indexing span tags to learn more about managing cardinality.

Database issues are not originating with problematic queries 🔗

If you are seeing database latency, but the query itself is not causing the issue, the problem might be a slow connection or a bottleneck waiting for a queue of database queries. To identify these kinds of issues, you need to instrument the database itself. For instructions on instrumenting a SQL database, see the following links:

You can also use the Related Content tiles to pivot to Infrastructure Monitoring to further analyze database issues. See Related Content in Splunk Observability Cloud to learn more about Related Content.

Turn off database query normalization 🔗

By default, Splunk APM instrumentation sanitizes database queries to remove or mask sensible data, such as secrets or personal identifiable information (PII).

If you want to turn off database query normalization, follow these steps:

  • Java: Set the otel.instrumentation.common.db-statement-sanitizer.enabled property to false.

  • .NET: Query normalization is not activated by default.

Caution

Disabling normalization might result in personal identifiable information (PII) and secrets appearing in Splunk Observability Cloud.

Learn more 🔗

See the following links for more information about Database Query Performance:

This page was last updated on Oct 09, 2024.