Share via

Reset dynamic port for TCP/IP /Best value recommended

Venkat 1 Reputation point
2020-10-06T14:00:51.313+00:00

Hi All,

From the Recent Past we have observed issues with Database, we have understood that this is issue with JDBC Connections.

I have verified the dynamic port connections and below are the values observed in DB server.

netsh int ipv4 show dynamicport TCP and UDP

Protocol tcp Dynamic Port Range

Start Port : 49152

Number of Ports : 16384

I would need help to apply best practices to increase TCP connection for server 2012R2 where MSSQL is installed.

i have also verified couple of commands to increase as below

netsh int ipv4 set dynamicport tcp start=10000 num=20000"

Could someone provide me the steps to increase TCP Connections and solve this issues

can this he done from registery or command based

After changes does server requires restart ?

Regards,

Venkatt.

Azure SQL Database

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Navtej Singh Saini 4,221 Reputation points Microsoft Employee
    2020-10-07T22:54:50.627+00:00

    @Venkat

    Can you please confirm is this an issue for the SQL server on a VM or Azure SQL which is PaaS offering for the SQL Server. If it is the former we will reroute this to the proper forum.

    Regards
    Navtej S

    0 comments