First thing that you need to clarify is whether or not your app commits/rollback transactions in your stored procedures
is mentioned. A work around given by IE for this issue is here. But this cannot be used in our case as we can't ask our clients to change their registry settings.Clients that use persistent connections SHOULD limit the number of simultaneous connections that they maintain to a given server. A single-user client SHOULD maintain AT MOST 2 connections with any server or proxy.