When to use AWE

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joe Spears - 26 Jul 2006 15:57 GMT

Hi
We have a server with 8Gb memory, and 4 SQL Server instaces.

Should we run AWE??

Thanks

Reply to this Message

Paul Wehland - 26 Jul 2006 16:46 GMT

64 bit right?

In addition to using 'awe enabled', also use 'Max Server Memory (MB)' !

> Hi
> We have a server with 8Gb memory, and 4 SQL Server instaces.
>
> Should we run AWE??
>
> Thanks

Reply to this Message

Arnie Rowland - 26 Jul 2006 17:10 GMT

8 GB total memory / 4 instances = 2 GB per instance. (No /3GB or AWE
needed.)

Unless you are going to divide up the memory and provide one instance with a
lot more memory (and the others less), I don't think that you have a
justification for the overhead of AWE -in fact, I believe that AWE will
cause a net loss of available memory in your circumstance.

Signature

Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

> Hi
> We have a server with 8Gb memory, and 4 SQL Server instaces.
>
> Should we run AWE??
>
> Thanks

Reply to this Message