SQL Server Performance

Persistent Connections? Connection Pooling?

Discussion in 'Non-Transact SQL Developer Performance Tuning' started by DanielSchaffer, Oct 28, 2004.

  1. DanielSchaffer New Member

    I'm very new to SQL Server, having only used MS Access before. What, if any, is the difference between perisistent connections and connection pooling? Also, I can't seem to find any articles about how to actually implement either of them. I am using ASP.NET (C#) to develop a web application.
  2. Chappy New Member

    I only have experience of persistent connections using MySql and PHP, so Im not really aware of what they mean in an MSSQL environment. Do you mean simply keeping a connection open during the lifetime of the application? This is often not a good idea, especially if you have a high usage server, but there are some times when you may want to do it.

    Connection pooling is your OLEDB providers ability to reuse a connection after it has been disconnected by the client application, but another request for a similar connection is then requested. Its a bit like thread pooling whereby the overhead of creating a new connection from scratch would be greater than the overhead of reusing the connection, however there are fairly strict conditions on how to write your connection strings to enable them to be reused. I read a useful article on these conditions recently, Ill see if I can dig it out.

    For connection pooling, you dont need to do anything. ADO.NET will pool connections by default, but like I say you need to be aware of how to NOT write connection strings which will defeat this process.

    We have a forum specific for client languages, this thread belongs there really
  3. satya Moderator

    As most of it covered by Chappy, I'm supporting them with the articles for further information:
    http://www.15seconds.com/issue/040830.htm
    http://www.sql-server-performance.com/asp_net_performance.asp
    http://www.developerfusion.com/show/4278/
    http://msdn.microsoft.com/library/e...nectionPoolingForSQLServerNETDataProvider.asp
    http://msdn.microsoft.com/library/e...nectionPoolingForSQLServerNETDataProvider.asp



    (And thread moved to the relevant forum as suggested from General DBA section)

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  4. DanielSchaffer New Member

    Thanks guys, this is very helpful!

Share This Page