topic Re: SQL sleeping sessions was created by qlik replicate user in Qlik Replicate

SQL sleeping sessions was created by qlik replicate user

Megha_More — Tue, 12 Sep 2023 06:44:22 GMT

Hi Team,

Qlik replicate user created a sleeping session at SQL side, is this sessions remains as it is or will be deleted or clear in future, please share more info about this.

Thanks & Regards,

Megha

Re: SQL sleeping sessions was created by qlik replicate user

SushilKumar — Tue, 12 Sep 2023 08:00:25 GMT

Hello Team,

As any Sql session starts when you open a connection to the server. The session is terminated when the connection is closed or, in case of persistent connections, after a certain timeout or when the server shuts down.

So in that case of QR it will reinitiate the session as an when required. When QR need some data or information from Database it may or may not use existing connection.

and connection/session which are there you must need to put some query to remove then after a certain period. if they remain ideal.

reagrds,

Sushil Kumar

Re: SQL sleeping sessions was created by qlik replicate user

SachinB — Tue, 12 Sep 2023 08:02:21 GMT

Hello @Megha_More ,

Thank you for reaching out to the Qlik community!

SQL Server typically has a timeout setting for user sessions. This timeout determines how long an idle or sleeping session will be allowed to remain open before it's automatically closed by the server. The default timeout can be configured in SQL Server, and it's often set to a relatively short duration to free up resources efficiently. After this timeout period elapses, the session is usually closed, and associated resources are released.

However, you can find the below articles which talks about how many sessions replicate use for SQL.

https://community.qlik.com/t5/Qlik-Replicate/8-connections-were-created-for-every-task/m-p/2045050#M5217

https://community.qlik.com/t5/Official-Support-Articles/Why-are-there-two-open-transactions-on-source-SQL-database-when/ta-p/1946320

Hope this helps.

Regards,

Sachin B

Re: SQL sleeping sessions was created by qlik replicate user

avidary_qlik — Tue, 12 Sep 2023 08:10:54 GMT

Hi @Megha_More
Please find a community article about the above
https://community.qlik.com/t5/Qlik-Replicate/Qlik-Replicate-opens-4-connections-to-the-target/td-p/1994487

if you have any specific questions, please let me know

Thank you

Avidar

Re: SQL sleeping sessions was created by qlik replicate user

Dana_Baldwin — Tue, 12 Sep 2023 15:31:18 GMT

Hi @Megha_More

Here also is a knowledge article with general information on the number of connections to source and target: Number of Connections Qlik Replicate Uses on Sourc... - Qlik Community - 2073073