Please advise me on how to increase the connection pool size in Sql Server 2008? The answer is urgently required as it is a matter concerning production server.
Answer by Melvyn Harbour 1 ·
This is quite a good article discussing connection pooling:
Perhaps if you give some more details as to what your problem is, and why you think that increasing the size of the pool will help, someone here might be able to guide you better.
Answer by Gustavo ·
ADO.NET Connection pooling page: http://msdn.microsoft.com/en-us/library/8xx3tyca.aspx
Also check your server max connections setting on SQL Server, this will reset it...
sp_configure 'user connections', 0 go reconfigure with override
Hope it helps.