What is the Maximum size of Max Pool Size in iis web.config?

Question

Hi All What is the Maximum size of Max Pool Size in iis web.config? And when do we need to use this? Thanks Hari

Rajeev Punhani · Answer

Hi Hariharan The max pool size that we can set is  32767 as sql server allows 32767 connections by default.You can see the user connections in sys.configurations .We can change this value also.So we can increase this value using EXEC sp_configure 'user connections' ;

Hariharan Krishnamoorthi · Answer

Hi all The Max Pool size's default value is 100. I want to know that what is the maximum limit we can set for this property?

Vignesh Mani · Answer

https://forums.asp.net/t/1981511.aspx?Where+in+the+web+config+should+I+set+the+max+pool+size+ https://www.codeproject.com/questions/683855/is-necessary-to-add-max-connection-pool-in-asp-net

Rajeev Punhani · Answer

Hi Hariharan The Max Pool size is 100.See this article for details https://www.codeproject.com/articles/17768/ado-net-connection-pooling-at-a-glance