Sleeping Connections

• David Bailey

  SSC Enthusiast

  Points: 179

  More actions

  August 25, 2004 at 9:05 am

  #161416

  I am currently testing a ASP.NETapplication which uses SQL Server 2000. I notice that there a number of connections sleeping although every connection is explictly closed by the calling code. What is the cause of this and how can I get these connections to clear automatically?

  Thanks

   

   

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  August 25, 2004 at 10:21 am

  #520564

  It sounds like you have connection pooling enabled.

  Check the registry HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\W3SVC\ASP\Parameters

  for entry "StartConnectionPool", if the value is set to 1, ADO and ASP will utilize connection pooling.