May 4, 2006 at 10:14 am
hi
I have developed a db intensive website in asp .net. I was testing the connections using sp_who2. When the status is "sleeping" after all execution is done, does it mean its a connetion leak?
Also if you have any good sites/articles which talk about connection leaks etc, please let me know.
Thanks
May 4, 2006 at 10:45 am
It depends, could just be a pooled connection. To see if you have a leak, run the process multiple times. If a new connection is created and left sleeping the majority of the time then you are not closing and free you connections properly in your application. If however the majority of the time a handfull of connections remain then it may be using the pool correctly. To best determine beyond that you will need a testing tool to stress your application. Lot's of resources but right now I cannot think of a specific one.
Site that might help
msdn.microsoft.com
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply