SQL Server Performance Forum – Threads Archive

Connection pool

Is there a way to pause a transaction? We have one that runs and it keeps opening new connections if the original connection doesn’t complete. It is a pretty intensive query so many new connections get open and sooner or later we reach the limit on the conncetion pool. Raising the pool limit doesn’t really help because our query will just keep opening connections. I was wanting to pause the query until the step in front of it succeeds. Charley Blum

Are you not closing those connections once the batch is finished?
I suggest to keep the batch as a minimum in order to get the transaction finished efficiently. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided Ã¯Â¿Â½AS ISÃ¯Â¿Â½ with no rights for the sake of knowledge sharing.

]]>