INF: Informing SQL Server That More Memory Has Been Added

ID Number: Q67625

1.10 1.11 4.20

OS/2

Summary:

To inform SQL Server that you have added new memory to a system, use

SAF to select the CONFIG menu and look at the memory options. Make

note of the number (in kilobytes) that is currently available to SQL

Server, and add to that number approximately 80 percent of the new

memory you are adding to the system.

You can experiment with raising that number, but be very careful about

pushing the limits; it may cause SQL Server to be unable to start or

to start very slowly.

If SQL Server does lock up, use the Buildmaster program to reset the

configuration values to what they were at install time. You can use

the following command:

bldmastr /r /C /d\sql\data\master.dat

The /C switch must be in uppercase letters, and is only necessary if

the SQL Server was originally installed as case insensitive.

Also keep in mind that OS/2 versions 1.3 and earlier can access only

16 MB of memory. On some machines, such as Paralan and Citrix

computers, parts of OS/2 version 1.3 have been rewritten so that more

then 16 MB can be accessed on these machines.

Additional reference words: 1.10 1.11 4.20