All Apps and Add-ons

Splunk db connect add on creating a sleeping query, Can connection be turned off after dbxquery transactions?

cjasenrobles
New Member

We have Splunk DB Connect Add On connected into a SQL Server, after all connections are successful.
We monitor the database activity and we saw queries in sleeping mode, DBAs mentioned that connection should be turned off after transacting a query. Is this possible?

Labels (1)
0 Karma

isoutamo
SplunkTrust
SplunkTrust

Hi

DBX is using connection pools for actual DB connections to DB. There are some parameters in config files which you can try to change to disable this or decrease timeouts before connection is closed. Those are added here for performance point of view and in normal situation you should leave those there.

Are there any real issue with those "sleeping" connections or are this something nice to have clear view without those? If there is issue with those, then 1st try to find reason why and if needed decrease amount of those first than just disable that feature in DBX.

You could look files db_connection*.conf files for these.

r. Ismo

0 Karma
Get Updates on the Splunk Community!

New in Splunk Observability Cloud: Automated Archiving for Unused Metrics

Automated Archival is a new capability within Metrics Management; which is a robust usage & cost optimization ...

Calling All Security Pros: Ready to Race Through Boston?

Hey Splunkers, .conf25 is heading to Boston and we’re kicking things off with something bold, competitive, and ...

What's New in Splunk Observability - July 2025

What’s New?  We are excited to announce the latest enhancements to Splunk Observability Cloud as well as what ...