Microsoft KB Archive/100946: Difference between revisions
(importing KB archive) |
m (Text replacement - """ to """) |
||
Line 39: | Line 39: | ||
<ul> | <ul> | ||
<li>Chapter 2 of the SQL Server | <li>Chapter 2 of the SQL Server "Installation Guide" gives several pointers for freeing available memory. You should refer to this for tips on how to disable read/write caching, turn off the MS-DOS session, and to set OS/2 swapping options.</li> | ||
<li>The preferred file system for SQL Server on OS/2 is FAT (File Allocation Table) instead of HPFS (High-Performance File System). The two greatest advantages to FAT are that it allows SQL Server to have access to more of the system's memory because FAT uses less than HPFS; and in the event of disk problems, you can restart from a MS-DOS disk and use any of the available MS-DOS utilities available to attempt hard disk repairs in the event of physical corruption on a device. Such utilities are much more widely available for FAT than for HPFS.<br /> | <li>The preferred file system for SQL Server on OS/2 is FAT (File Allocation Table) instead of HPFS (High-Performance File System). The two greatest advantages to FAT are that it allows SQL Server to have access to more of the system's memory because FAT uses less than HPFS; and in the event of disk problems, you can restart from a MS-DOS disk and use any of the available MS-DOS utilities available to attempt hard disk repairs in the event of physical corruption on a device. Such utilities are much more widely available for FAT than for HPFS.<br /> | ||
<br /> | <br /> | ||
Line 58: | Line 58: | ||
<br /> | <br /> | ||
A good way to determine if you have over-configured your SQL Server memory is to monitor the size of the SWAPPER.DAT file. The directory where this file is located is pointed to by the SWAPPATH= entry in the OS/2 CONFIG.SYS file. If this file is consistently getting larger than 11 or 12 MB, then you are probably doing too much swapping and it could be affecting your performance. | A good way to determine if you have over-configured your SQL Server memory is to monitor the size of the SWAPPER.DAT file. The directory where this file is located is pointed to by the SWAPPATH= entry in the OS/2 CONFIG.SYS file. If this file is consistently getting larger than 11 or 12 MB, then you are probably doing too much swapping and it could be affecting your performance. | ||
* On Novell networks running the Netware requester for OS/2 version 1.3, with Microsoft or IBM OS/2 version 1.3, with 16 MB of RAM on the computer, with the maximum available memory freed as described above, and running FAT with no MS-DOS compatibility box enabled, the suggested maximum amount of memory to configure SQL Server to use is about 12 MB. If using the Microsoft's | * On Novell networks running the Netware requester for OS/2 version 1.3, with Microsoft or IBM OS/2 version 1.3, with 16 MB of RAM on the computer, with the maximum available memory freed as described above, and running FAT with no MS-DOS compatibility box enabled, the suggested maximum amount of memory to configure SQL Server to use is about 12 MB. If using the Microsoft's "SQL Server Network Integration Kit for Novell Netware Networks," then about 11 MB is the suggested maximum. | ||
* On Banyan networks running VINES version 4.10 or later, with Microsoft or IBM OS/2 version 1.3, with 16 MB of RAM on the computer, with the maximum available memory freed as described above, and running FAT with no MS-DOS compatibility box enabled, the suggested maximum amount of memory to configure SQL Server to use is about 12 MB. If using the Microsoft's | * On Banyan networks running VINES version 4.10 or later, with Microsoft or IBM OS/2 version 1.3, with 16 MB of RAM on the computer, with the maximum available memory freed as described above, and running FAT with no MS-DOS compatibility box enabled, the suggested maximum amount of memory to configure SQL Server to use is about 12 MB. If using the Microsoft's "SQL Server Network Integration Kit for Banyan VINES Networks," then about 11 MB is the suggested maximum. | ||
* Microsoft is currently supporting SQL Server version 4.2 on IBM OS/2 version 2.0 on Novell and IBM LAN Server networks. At this time, we are still testing on IBM OS/2 version 2.1, but have clients who use it, and the memory configuration settings will probably be similar to OS/2 version 2.0.<br /> | * Microsoft is currently supporting SQL Server version 4.2 on IBM OS/2 version 2.0 on Novell and IBM LAN Server networks. At this time, we are still testing on IBM OS/2 version 2.1, but have clients who use it, and the memory configuration settings will probably be similar to OS/2 version 2.0.<br /> | ||
<br /> | <br /> |
Latest revision as of 09:16, 20 July 2020
The information in this article applies to:
SUMMARYMicrosoft SQL Server for OS/2 can be installed on several different network operating systems and on several versions of OS/2. However, the installation guide deals primarily with SQL Server configuration parameters on LAN Manager networks. While each user's SQL Server setup will be affected by their own application environment, there are some general guidelines for the configuration of memory on networks other than Microsoft LAN Manager and on OS/2 versions other than Microsoft version 1.3.
MORE INFORMATIONIt is very difficult with the OS/2 memory architecture for even the author of a program to determine his program's consumption of physical random access memory (RAM). This is because all OS/2 programs exist in a 512-megabyte (MB) virtual address space, and there is not an operating system application programming interface (API) that exists for querying either the amount of total RAM in the computer, or the amount of RAM consumed by a program. The only way to come close to determining the physical memory consumption of a program is to keep a record of all memory allocation requests. This article addresses ways to maximize SQL Server's use of memory in two ways:
A safe level is one where SQL Server gets the most out of available memory without causing OS/2 to get into a situation where it is frequently swapping chunks of memory to the hard disk and thereby causing a decrease in performance. Freeing Available Memory
Configuring SQL Server's Memory
Keywords : Version : Platform : Issue type : |
Last Reviewed: March 15, 1999 |