Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kotsas
Yak Posting Veteran
65 Posts |
 Posted - 2002-03-01 : 03:34:02
|
| I have server with 4256 MB memory. If I want my win2k advance server to see more than 4gb of memory I wiil put /pae switch in boot.ini. What will be with sql 2000 enterprise??? How much memory can I than reserve. Still stay 1GB for operating system and remaning part for sql??? Thas this mean that for sql server I will have 3256 MB memory???, or must I enable AWE in sql server 2000??Thank |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-03-01 : 11:07:09
|
| You would need to enable AWE for SQL to use this much memory. Make sure you set Max Server Memory to be 3256 MB.Also, if you are using AWE, it is very important that this is a dedicated SQL box. Any other app will be starved for memory if you have AWE enabled (As SQL will not release memory).-Chad |
 |
|
|
|
|
|
/PAE SWITCH (AWE MEMORY)