Skip navigation

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 off
setlocal
set sd=%1
set key="HKLM\SYSTEM\CurrentControlSet\Services\LanmanServer\Parameters"
call :quiet>nul 2>&1
if /i \{%sd%\} NEQ \{R\} endlocal&goto :EOF
endlocal
PsShutdown -r -f
:quiet
reg add %key% /V NoAliasingOnFileSystem /T REG_DWORD /F /D 1



Hide comments

Comments

  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Publish