Question about SQL Server multiple TCP\IP resets

[sbettencourt]

Hello,

Our production SQL server 2005 has an issue which was addressed in KB 154628 (

http://support.microsoft.com/kb/154628/EN-US/).

My question is regarding the portion below:

• The new registry location for SQL Server 2000 and for SQL Server 2005:

For a default instance:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\SuperSocketNetLib
For a named instance:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Name\MSSQLServer\SuperSocketNetLib
2. Select the MSSQLServer subkey for SQL Server 6.5 and SQL Server 7.0, and select the SuperSocketNetLib for SQL Server 2000 and for SQL Server 2005. On the Edit menu, click Add Value.
3. Enter the following:
Value Name: WinsockListenBacklog
Data Type: REG_DWORD
Data: Range is 1 to 0xFFFFFFFF

NOTE: The data value affects overall system resources if it is set to a high value. Windows NT 3.51 has a maximum overall backlog of 100 and Windows NT 4.0 has a maximum overall backlog of 200 for all applications. The suggested method of testing with this value is to set the value in increments of five and observe the results until the connection reset stops.

My question is does windows server 2003 have a maximum value? I've searched everywhere and cant seem to find that information anywhere.

Thanks in advance.
Sean