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.
asked
How to increase the connection pool size in Sql Server 2008?
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.
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.
