How to set to allow MaximumTCP connection in windows server 2016

Antony Maxwin 281 Reputation points
2021-07-30T05:59:13.127+00:00

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

119189-image.png

Pic 2 TCP connection count fall into 10

119170-image.png

Windows Server 2016
Windows Server 2016
A Microsoft server operating system that supports enterprise-level management updated to data storage.
2,402 questions
Windows Network
Windows Network
Windows: A family of Microsoft operating systems that run across personal computers, tablets, laptops, phones, internet of things devices, self-contained mixed reality headsets, large collaboration screens, and other devices.Network: A group of devices that communicate either wirelessly or via a physical connection.
667 questions
{count} votes

Accepted answer
  1. Sunny Qi 10,906 Reputation points Microsoft Vendor
    2021-07-30T07:44:16.403+00:00

    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.

    0 comments No comments

0 additional answers

Sort by: Most helpful