Check that connection is closed

  • Thread starter Thread starter jazzandlatin
  • Start date Start date
J

jazzandlatin

Hi everybody
Could somebody tell me how it is possible to check that any connection
opened in a page be closed when the page has been published ?

My problem is that SQL server looks saturated very quickly. I 've
checked the code but something must be wrong.. there are lots of
sleeping connections in SQLServer... might this be the reason and how
can i solve the problem
Thanks a lot
Jazz
 
To add to this, it should be noted that connection pooling is going to
keep some connections open so that the overhead of repeatedly opening and
closing connections is not incurred.
 
Back
Top