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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top