Slow MDB access in Windows 2008

Recently we undertook a project to replace a Windows 2000 domain controller with a nice new Windows 2008 server. The old Windows 2000 server was responsible for sharing an MDB database. Since moving this database to the new server, we’ve experienced some rather frustrating performance issues.

The MDB application shows a lot of latency, taking several seconds between screens. Having looked at the MDB Performance FAQ we discovered that a technique called SMB signing can decrease network transfer speed by 10-25%. There are a couple of registry keys that can be tweaked:

HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\Lanmanworkstation\Parameters\enablesecuritysignature

HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\Lanmanworkstation\Parameters\requiresecuritysignature

On a domain controller the default setting is to have “requiresecuritysignature” set to 1. We’ve changed this to 0 and will report our findings back shortly.

Leave a Reply

Your email address will not be published. Required fields are marked *

one × three =