Win 配置Sybase 内存

时间：2008-12-09 来源：chuxu

这段时间和网友讨论Win下Sybase的内存配置，本来一直没有使用过Win环境的Sybase，也没有可以使用的测试环境，所以一直只能纸上谈兵。终于在Vmware下安装了一个Win2003Enterprise，终于有机会测试一下了。关键参考了两个链接http://bbs.chinaunix.net/viewthread.php?tid=615325 和http://www.itpub.net/777645.html 把问题都说的很明白了。再查看Sybase网站上相关的case：

Case Description

We are running ASE 12.5.3 on Windows 2003. Not able to configure memory over 1 GB on server with 32 GB of memory. We have another machine running ASE 12.5.4 on Wind 2003 and is configured for 6GB using the /PAE switch.

When we try to configure memory on the ASE 12.5.3 machine to 1.5 GB, we get the following errors:

kernel NT operating system error 87 in module 'e:\ase1253\porttree\svr\sql\nt386\ksource\blkme\osmntmmap.c' at line 465: The parameter is incorrect.

kernel os_create_region: Failed to get virtual memory information.

kernel kbcreate: couldn't create server region 6.

kernel kistartup: could not create shared memory

kernel SQL Server system exception (0xc0000005) generated by a storage access violation.

.........

kernel kbcreate: couldn't get shmid for kernel region.

kernel kistartup: could not create shared memory

Both machines have a total of 32GB available memory. Virtual memory is 2GB on both servers.

Tip or Workaround

It turned out the 12.5.4 server was not actually using 6GB.

ASE does not support the use of the /PAE switch. Use of the /3GB switch and the following steps should allow you to get up to 2.7GB:

- add /3GB flag to Windows boot.ini file

- adjust "shared memory starting address" to 23662592

- adjust "allocate shared memory" to 1

- adjust "max memory" to 1408000 (~2.7GB)

- reboot Windows

Alternatively, you can upgrade to Windows 2003 Enterprise with ASE 15.0.1+, which can support up to 1TB.

Resolution

ASE supports the use of the /3GB switch, that will configure up to 2.7GB. ASE does not support the use of the /PAE switch. See "Tips and Workarounds", above for more details.

在我的测试环境下，Win内存3.5G，加了/3GB参数后，按照Sybase文档，修改max memory =1310720 (2.5G)，shared memory starting address=23662592,allocate shared memory=1 启动Sybase成功。将shared memory starting address恢复成default（0），启动失败。不过发现一个问题，再加了/3GB参数之后，win任务管理器性能中看到的物理内存竟然有15.7G，晕。

相关阅读更多 +