Posted by masri999 on 09/12/06 04:48

I have a few questions about memory setting inherited

Windows 2003, SQL Server SP4, both Enterprise Edition 8 GB RAM

1. How to know how much Memory SQL can address ( SQL script is better
as there is no access to Perfmonitor or EM ) . ie what is maximum
memory SQL can use ?

2. In this server awe is set to 0 . Do I have to turn it to 1 so that
SQL can use all memory .

3. If awe is enabled, what is the minimum and maximum memory size need
to be set ?

4. Should I set max worker set also ?

If someone can provide examples of /PAE, /AWE. /3GB ,/USERVA etc , I am
grateful

Thanks

Srinivas

• Next in forum: Tree table
• Prev in forum: Re: How to get a SP return value on another SP?
• Thread view: Memory setting right ?

[Reply to this message]