Windows: TCP/IP registry settings for a busy SQL Server host
Registry values TcpTimedWaitDelay, MaxUserPort, TcpNumConnections and TcpMaxDataRetransmissions and what they mean.
Windows TCP/IP settings commonly tuned on a SQL Server host that receives a large number of connections (for example BI workloads), to avoid port exhaustion.
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters]
"TcpTimedWaitDelay"=dword:0000001e
"MaxUserPort"=dword:0000fffe
"TcpNumConnections"=dword:00fffffe
"TcpMaxDataRetransmissions"=dword:00000005
What the values mean
| Value | Hex | Decimal | Purpose |
|---|---|---|---|
TcpTimedWaitDelay |
0x1e |
30 | Time (seconds) a closed connection stays in TIME_WAIT |
MaxUserPort |
0xfffe |
65534 | Highest ephemeral port number |
TcpNumConnections |
0xfffffe |
16777214 | Maximum number of simultaneous TCP connections |
TcpMaxDataRetransmissions |
0x5 |
5 | Number of times a data segment is retransmitted before giving up |
Notes
- Save the content as a
.regfile and import it, or create theDWORDvalues by hand. - A restart is generally required for the changes to take effect.
- Test outside production before rolling out.