JSI Tip 8998. How can I improve Access or Jet database performance on Windows Server 2003?

Windows Server 2003 supports file system aliasing, a feature that lets multiple file names refer to the same file.

If you are not using mount points and reparse points on your Windows Server 2003, you can improve Access or Jet database performance by turning off file system aliasing.

Using PsShutdown.exe, I have scripted NoAliasingOnFileSystem.bat to turn off file system aliasing.

The syntax for using NoAliasingOnFileSystem.bat is"

NoAliasingOnFileSystem [R]

Where R is an optional parameter that will restart the Windows Server.

NOTE: A restart is required for the NoAliasingOnFileSystem setting to become effective.

NOTE: See You experience significant delays when opening files over the network in a multi-user application?

NOTE: See NTFS - Disable 8.3 Name creation.

NoAliasingOnFileSystem.bat contains:

@echo offsetlocalset sd=%1set key="HKLMSYSTEMCurrentControlSetServicesLanmanServerParameters"call :quiet>nul 2>&1if /i {%sd%} NEQ {R} endlocal&goto :EOFendlocalPsShutdown -r -f:quietreg add %key% /V NoAliasingOnFileSystem /T REG_DWORD /F /D 1