SQL sleeping sessions was created by qlik replicate user

[Megha_More]

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

[SushilKumar]

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  

[SachinB]

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#M...

https://community.qlik.com/t5/Official-Support-Articles/Why-are-there-two-open-transactions-on-sourc...

Hope this helps.

Regards,

Sachin B

[avidary_qlik]

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/1...

if you have any specific questions, please let me know

Thank you

Avidar

[Dana_Baldwin]

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