How to set to allow MaximumTCP connection in windows server 2016

Question

HI
I have one SQL DB server ( windows server 2016) and two IIS server. in both DB server and application server, when the TCP connection reaches 500, suddenly there is a choking happening and it won't allow any other new TCP connections , and it again starts from 10. is there any way can i increase the maximum connection limit in windows , or is it depends on the traffic ?.
I have done some changes in registry but still no changes

PIC 1 - TCP connection count reaches 500

Pic 2 TCP connection count fall into 10

Answer 1

Hi,

Thanks for posting in Q&A platform.

I noticed that you have posted this new thread for your question. Sorry for the late response since I didn't receive the notification for the previous thread.

I did lots of research and found that there is a parameter that limits the maximum number of connections that TCP may have open simultaneously. You could have a try:

HKEY_LOCAL_MACHINE \System \CurrentControlSet \Services \Tcpip \Parameters

Name:TcpNumConnections
Value type: REG_DWORD - Number
Valid range: 0 - 0xfffffe
Default: 0xfffffe
Description: This parameter limits the maximum number of connections that TCP can have open at the same time.

For more details regarding of TCP/IP protocol, please refer to the following article:

https://learn.microsoft.com/en-us/troubleshoot/windows-client/networking/tcpip-and-nbt-configuration-parameters

And I also find the following article for configuring the max limit for concurrent TCP connections, you could have a look:

Configure the max limit for concurrent TCP connections
Please Note: Since the web site is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information.

----------

If the Answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.