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!

Observability Highlights | January 2023 Newsletter

 January 2023New Product Releases Splunk Network Explorer for Infrastructure MonitoringSplunk unveils Network ...

Security Highlights | January 2023 Newsletter

January 2023 Splunk Security Essentials (SSE) 3.7.0 ReleaseThe free Splunk Security Essentials (SSE) 3.7.0 app ...

Platform Highlights | January 2023 Newsletter

 January 2023Peace on Earth and Peace of Mind With Business ResilienceAll organizations can start the new year ...