Is there any restriction on concurrent SQL Server connections posed by IIS server?

Is there any limit on the no. of simultaneo开发者_Go百科us SQL connections by IIS server?

• Or is it solely dependent on the memory available?
• Or is there any other factor which would impose any restriction on the no. of concurrent SQL connections?

---

This is controlled via connection pooling which you can configure through web.config

http://msdn.microsoft.com/en-us/library/8xx3tyca.aspx

---

if you have your .NET code running in the web application properly designed to open and close immediately the connections after usage, the .NET connection pool will handle everything for you transparently.

it is my understanding that if you always use the same connection string only one connection will be created and managed and this is probably the best way to do it.

always avoid to keep any SQL Connection object opened and not closed or disposed immediately.

---

Yes there is, see the specs here.

It's 32,767. If you are hitting it you're probably not disposing connections.