Should I set max pool size in database connection string What happens if I don t

Question

This is my database connection string  I did not set max pool size until now   public static string srConnectionString                            server localhost database mydb uid sa pwd mypw      So currently how many connections does my application support  What is the correct syntax for increasing the connection pool size   The application is written in C  4 0

User · Accepted Answer

Currently your application support 100 connections in pool. Here is what conn string will look like if you want to increase it to 200:

public static string srConnectionString = 
                "server=localhost;database=mydb;uid=sa;pwd=mypw;Max Pool Size=200;";

You can investigate how many connections with database your application use, by executing sp_who procedure in your database. In most cases default connection pool size will be enough.

User · Answer

currently yes but i think it might cause problems at peak moments  I can confirm  that I had a problem where I got timeouts because of peak requests  After I set the max pool size  the application ran without any problems  IIS 7 5   ASP Net

User · Answer

We can define maximum pool size in following way                    lt pool gt                   lt min-pool-size gt 5 lt  min-pool-size gt                   lt max-pool-size gt 200 lt  max-pool-size gt                   lt prefill gt true lt  prefill gt                   lt use-strict-min gt true lt  use-strict-min gt                   lt flush-strategy gt IdleConnections lt  flush-strategy gt                   lt  pool gt

[sql] Should I set max pool size in database connection string? What happens if I don't?

Examples related to sql

Examples related to sql-server-2008

Examples related to connection-string

Examples related to connection-pooling