LLI Wiki — My Digital Knowledge Base

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

Mastodon LLIMastodon SocialFosstodon