Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a .net website connecting to SQL. Just wondering if connection pooling is enabled by default or is it something I have to activate myself?

share|improve this question

Essentially this is enabled by default when using the System.Data.SqlClient data provider. There is a very good article about the semantics which can be found here:

SQL Server Connection Pooling (ADO.NET)

Also, you can view the ConnectionString property reference of the SqlConnection class here:

SqlConnection.ConnectionString Property

This contains a lot of information about the options that are available when configuring a connection string for Sql Server.

You should also note that the actual connection pool itself is kept within the Application Pool assigned to the website/web application, so be aware that if you have multiple sites/web applications using the same Application Pool they will also share the same connection pool which may not be desirable to you.

As such, I would recommend assigning a new application pool for each website and each web application underneath the site itself. You can find information about application pools at the link below:

Application Pools

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.