How to set to allow MaximumTCP connection in windows server 2016

Antony Maxwin 281 Reputation points

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


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


    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

    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:

    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