Sybase_memory_config

献给爱丽丝

如果您要配置内存>;1.5G且<2G，只需要做以下步骤就可以了，不需要使用
>; imagecfg
>; Step 1:
>;    You need to first set the shared memory starting address for the server
>;    to the minimun value:
>;
>;    1>; sp_configure 'shared memory starting address', 23662592
>;    2>; go
>;
>;    Step 2:
>;    Set the total memory to what you like it to be and recycle the server
>;    (in this example - 1.75 GB )
>;    Because shared addressable memory is in 2K pages.
>;
>;    1>; sp_configure 'max memory', 917504 (您也可以直接修改.cfg文件)
>;    2>; go

2.2.2: How to Configure More than 2G bytes of Memory for ASE on NT.

-------------------------------------------------------------------------------

The following was posted on news://forums.sybase.com/sybase.public.ase.nt ,
taken directly from a Sybase SPS case notes.

(I read recently that this is not needed, that Sybase does all of this for you
before it leaves the factory. If anyone knows the real answer, I would be
grateful for an update.)

If you are using NT server enterprise, or Windows 2000 Advanced Server, you may
be able to get up to 3gig:

Here is what you need to do in order to configure greater than 2GB memory for
ASE on NT:

Step 1: Make a backup copy of sqlsrvr.exe in the sybase bin directory

Step 2: Verify the current settings of sqlsrvr.exe using imagecfg.exe:

imagecfg sqlsrvr.exe
sqlsrvr.exe contains the following configuration information:
   Subsystem Version of 4.0
   Stack Reserve Size: 0x20000
   Stack Commit Size: 0x4

Step 3: 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

Step 4: verify ASE is able to start

Step 5: The NT machine must be booted with the /3GB flag and must have
sufficient paging file space (e.g., if you want ASE to access 3G of memory then
the paging file must be at least that size)

Step 6: increase total memory to say 2.2 gb (anything >; 2gb)

Step 7: increase starting virtual memory address to 23662592 decimal (which is
1691000 hex) as shown:

sp_configure 'shared memory starting address', 23662592

Step 8: restart server

Step 9: test to connect a lot of users (more than 240)

Back to top

小无赖

第5步操作中的/3GB 参数加在什么地方？

小无赖

哦，找到了，在boot.ini文件中添加/3GB参数

http://www.pconline.com.cn/pcjob/other/data/others/0405/371163.html

献给爱丽丝

呵呵，配置好啦！