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 |
|
Davidvoo
Starting Member
1 Post |
 Posted - 2009-02-11 : 17:09:56
|
| We have a Dell R900 server with 128GB and 4 (6 cores) CPUs with Windows 2003 EE R2 SP2 64-bit installed. What is the maximum memory I can assign to the SQL 2000 EE (32-bit) instance? I used SQL 2005 Studio to assign minimum 16GB memory to the instance but the SQL log got the message saying: Warning unable to allocate 'min server memory' of 16000MB. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-11 : 22:35:42
|
| There are issues with your Configuration.1)You have 64-bit Windows 2003 Server with 128GB RAM but you are using 32-bit SQL Server.2)You are unnecessarily wasting lots of Memory .By Default ,SQL 2000 EE 32-bit gives 2GB for user mode and 2GB for Kernel mode. The Max Memory you can use is 64 GB.To get More Memory:1)Enable /PAE and AWE. 2)Configure Max and Min Memory for SQL Server and Other apps,OS.3)Also Enable 'Lock pages in Memory'.I would strongly suggest to use SQL 2005 64-bit EE .You can achieve whole lot of Memory with it |
 |
|
|
|
|
|
Max Memory for SQL 2000 EE (32-bit)