Maximum connection pool size in SQL Server 2008

Question

We are using SQL Server 2008 express. At the moment, in the connection string, we have the default pool size of 100. At peak times, we get a timeout error while processing transactions in the database.

The situation has improved since we set the pool size to 200. My question is, what maximum pool size can you have in the express edition? This edition works with GB of RAM.

We also have a full version of SQL. Can we specify a larger pool size with a full-scale version, and if we increase the size of the pool, we will need to increase things like RAM, etc., to see the benefits?

Thanks in advance,

Mt.

Answer 1

Whenever you have such questions, you should go to Maximum Capacity for SQL Server . Strictly speaking, the size of the connection pool is a client setting, but the engine must support an open connection so that you can hit the boundaries of the server. The values ​​of Connections per client are Maximum value of configured connections , which implies that it is configured using the Server configuration option and thinks that it is, see user connections :

The User Connections parameter specifies the maximum number of concurrent user connections that are allowed on an instance of SQL Server. The actual number of connections allowed by the user also depends on the version of SQL Server you are using, as well as the limits of your application or applications and hardware. SQL Server allows a maximum of 32,767 user connections. Since user connections are a dynamic (self-tuning) option, SQL Server adjusts the maximum number of user connections automatically as needed, to the maximum allowable value.