Upgrading Windows to 3 Gigabytes

It may be necessary to upgrade your system memory.

  1. Make a backup copy of sqlsrvr.exe in the sybase bin directory.

  2. Verify the current settings of sqlsrvr.exe using imagecfg.exe (a utility that is available with the Windows resource kit, or advanced server).
    imagecfg sqlsrvr.exe
    sqlsrvr.exe contains the following configuration information:
    • Subsystem Version of 4.0

    • Stack Reserve Size: 0x20000

    • Stack Commit Size: 0x4

  3. Use imagecfg to switch on large addressing using the -l (lowercase L) switch: imagecfg -l sqlsrvr.exe sqlsrvr.exe contains the following configuration information:

    • Subsystem Version of 4.0

    • Stack Reserve Size: 0x20000

    • Stack Commit Size: 0x4

    sqlsrvr.exe updated with the following configuration information:
    • Subsystem Version of 4.0

    • Image can handle large (>2GB) addresses

    • Stack Reserve Size: 0x20000

    • Stack Commit Size: 0x4

  4. Verify that Adaptive Server can start.
  5. Start the Windows machine with the 3GB flag in the boot.ini file and must have sufficient paging file space (if you want Adaptive Server to access 3GB of memory then the paging file must be at least that size).
  6. Increase total memory to anything greater than 2GB.
  7. Increase starting virtual memory address to 23662592 decimal (which is 1691000 hexadecimal) as shown:
    sp_configure 'shared memory starting address', 23662592
  8. Restart the server.