Reassembly Failures on Windows (ID 6291562)

On the Windows platform, with certain configurations and loads, a large number of reassembly failures might occur in the operating system. The problem has been seen with configurations of more than 20 nodes when running several table scans (select *) in parallel. Possible symptoms include transactions aborting frequently, repair or recovery taking a long time to complete, and frequent timeouts occurring in various parts of the system.

Solution

To fix the problem, the Windows registry variable HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters can be set to a value higher than the default 100. For best results, increase this value to 0x1000 (4096). For more information, see article 811003 from the Microsoft support pages.