Let SQL Server 2000 Ent. Use more than 4gb of RAM on Win2k AdvancedServer

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

gansmeier - 27 Apr 2005 10:34 GMT

Hello all,

how must i configure SQL Server Enterprise Edition so it uses up to 8 GB
ram on
windows 2000 advanced server?
We habe upgraded RAM from 4 GB to 8 GB but SQL Server still uses only 3
GB RAM.
Traces often show 'cache miss', so i think it really needs / would use
more RAM.

Must i reconfigure SQL Server?
awe anabled?
max server memory?

Are there any kb articles?

Thanks in Advance for help,

Markus Gansmeier

Reply to this Message

Keith Kratochvil - 27 Apr 2005 12:35 GMT

You probably need to specific /3GB /PAE within the boot.ini

And then set "awe enabled" to true.
Finally, you can set the min server memory (MB) and max server memory (MB)
to a specific value (we have a server set to 6144 -- 6GB).

Signature

Keith

> Hello all,
>
[quoted text clipped - 15 lines]
>
> Markus Gansmeier

Reply to this Message