question

Venkat avatar image
Venkat asked

How to increase the connection pool size in Sql Server 2008?

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.

sql-server-2008connection-pool
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Melvyn Harbour 1 avatar image
Melvyn Harbour 1 answered

This is quite a good article discussing connection pooling:

http://www.pythian.com/news/1270/sql-server-understanding-and-controlling-connection-pooling-fragmentation

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.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Gustavo avatar image
Gustavo answered

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.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.