SQL Server Performance

When does sp_reset_connection happen?

Discussion in 'SQL Server 2005 General DBA Questions' started by pcsql, Aug 7, 2007.

  1. pcsql New Member

    Does sp_reset_connection get executed when a connection is added back to the connection pool or it get executed when a connection is requested? Does it always get executed or conditionally?
    When a connection in the connection pool is timed out, does any sp get executed?
    How can I tell how many connections are in connection pool?
  2. satya Moderator

    Check such explanation in this article in thsi case.

Share This Page