INF: Informing SQL Server That More Memory Has Been Added

 Last reviewed: April 25, 1997
Article ID: Q67625

The information in this article applies to: 

  - Microsoft SQL Server version 4.2 for OS/2

SUMMARY

To inform Microsoft SQL Server for OS/2 that you have added new memory to a system, use SQL Administrator and select SYSTEM/Manage/Configure SQL Server. Make note of the amount of memory (given in 2K pages, 512 pages = 1 MB) that is currently available to Microsoft SQL Server for OS/2 and add to that number approximately 80 percent of the new memory you are adding to the system.

MORE INFORMATION

You can experiment with increasing the memory reserved for Microsoft SQL Server for OS/2 but be very careful. Configuring the memory incorrectly may cause SQL Server to be unable to start or to start very slowly.

If Microsoft SQL Server for OS/2 fails to start, use the bldmstr 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, otherwise do not use /C. Note that this command will reset all other configuration parameters to their defaults as well. Any modifications you had made to the SQL Server configuration prior to running bldmastr will be lost and will have to be reapplied.

Keep in mind that OS/2 versions 1.3 and earlier can access only 16 MB of memory. On some machines, however, 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.

Additional query words:
Keywords : kbusage SSrvGen SSrvServer SSrvSQL_Admin
Version : 4.2
Platform : OS/2

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: April 25, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.