Upgrading Windows to 3GB

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

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

Verify that Adaptive Server can start.

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 3G of memory then the paging file must be at least that size).

Increase total memory to anything greater than 2GB.

Increase starting virtual memory address to 23662592 decimal (which is 1691000 hexidecimal) as shown:

sp_configure 'shared memory starting address', 23662592

Restart the server.