Connection Pooling

Posted on 2009-02-16
Last Modified: 2013-11-07
We've been having some SQL Server connection issues and one of our Active Directory admins suggested using connection pooling (we get a lot of timeout expired errors when connecting to any SQL Server 2005, we have 4).  I'm a programmer, and my .Net applications use this by default with ADO.Net (I've ran tests to verify this).  However, we also have ODBC reports that are run on an application server, and I believe they're pooling but I don't know for sure.  Also, I've checked the open connections on the server via both a netstat and running an sp_who2 query and I haven't seen an extraordinary amount of connections open.

1.)  Is there anything that needs to be done on the server to enable connection pooling?
2.)  Do the microsoft ODBC drivers behave like the ADO drivers and enable pooling by default (if not, can they be enabled/how)?
Question by:IUFITS
    LVL 15

    Expert Comment

    Check your SQL Query wait. right click on the server instance >> Properties >> Advanced.
    Check the Query Wait value.
    LVL 15

    Expert Comment

    LVL 10

    Accepted Solution

    From a web application all you need to do is modify your web.config connection string and add "Min Pool Size,Max Pool Size & Connect Timeout" values.


    Hope this help.

    conn.ConnectionString = "integrated security=SSPI;SERVER=YOUR_SERVER;DATABASE=YOUR_DB_NAME;Min Pool Size=5;Max Pool Size=60;Connect Timeout=2;";

    Open in new window

    LVL 3

    Author Comment

    I'm going to accept jabcoco's answer... though it didn't exactly answer my question, he did link to an article that had a link in it that had the information I needed.  I'm going to include the verbiage from the part that helped me for posterity (this explains how connection pooling behaves with ODBC):
    Connection Pooling for Odbc
    Connection pooling for the .NET Framework Data Provider for ODBC is managed by the ODBC Driver Manager that is used for the connection, and is not affected by the .NET Framework Data Provider for ODBC.
    To enable or disable connection pooling, open ODBC Data Source Administrator in the Administrative Tools folder of Control Panel. The Connection Pooling tab allows you to specify connection pooling parameters for each ODBC driver installed. Note that connection pooling changes for a specific ODBC driver affect all applications that use that ODBC driver.  

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    In my previous article ( we saw the basics of serialization and how types/objects can be serialized to Binary format. In this blog we wi…
    In my previous two articles we discussed Binary Serialization ( and XML Serialization ( In this article we will try to know more about SOAP (Simple Object Acces…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now