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 |
|
WeekendWarrior
Starting Member
1 Post |
 Posted - 2007-09-26 : 11:00:46
|
| Can someone lend a hand at explaining the correct reading of memory on SQL Server 2000 Enterprise Edition. I have a windows 2003 server (sp2) running SQL Server 2000 enterprise edition. The server has 28 GB of memory. When I launch Enterprise manager it display 28503(MB). When I look at the amount SQLServr.exe is taking via taskmgr I see < 1,759,000K. In perfmon, Total Server Memory (KB) "maximum" displays < 1664500. sp_configuration doesn't show "AWE" as enabled. Windows Server 2003 doesn't have /3GB or /PAE set in the boot.ini. I also read if a have SQL SERVER 2000 with SP4 and AWE enabled that SQL Server can only access up to 8GB. I would have to apply a fix to resolve the latter bug (Article ID 899761).ThanksCan anyone tell me how to best use this 28GB of memory for this database server.Thanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-26 : 23:26:34
|
| You need put /pae in boot.ini file and enable awe in sql, then set max memory. |
 |
|
|
|
|
|
SQL Server 2000 memory configuration/understanding