This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 93%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENS%3C/text%3E%3C/svg%3E)
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
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 21%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDB%3C/text%3E%3C/svg%3E)
What is the issue? Why do you think that changing the TCP configuration of the server or SQL Server will help? That's not a normal thing to do.
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