I've read the articles and posting regarding increasing SQL's memory
utilization using either /3G or AWE, but I still clarifying a couple of
things.

1) Can you use both /3G and AWE together? Do you get even more memory
utilization with both? Or is it hierchachial, use /3g or if you want more,
use AWE?
2) Can someone send (or post) an actual screenshot of what the boot.ini
file should look like with these entries? I've read that your supposed to
place the /3G entry "on the appropriate line", but other than putting it
within the server configuration section, I'm not sure what "appropriate"
means.

Thanks!

Ross

You are confused as to what each of these actually do so I suggest you read
these articles:

http://sqljunkies.com/Tutorial/0D4FF...2FE2D58F6.scuk
Memory
http://www.sql-server-performance.com/awe_memory.asp Using AWE Memory
http://www.support.microsoft.com/?id=321363 SQL Server 7 & 2000 memory
usage
http://www.support.microsoft.com/?id=274750 Memory config
http://www.support.microsoft.com/?id=283037 Large Memory Support Is
Available in Windows 2000 (AWE)
http://www.support.microsoft.com/?id=811891 Can not use more than 2GB of
memory


--
Andrew J. Kelly SQL MVP

"Ross Culver" <rculver@warrenalloy.com> wrote in message
news:uTtjRORXHHA.5008@TK2MSFTNGP05.phx.gbl...
> I've read the articles and posting regarding increasing SQL's memory
> utilization using either /3G or AWE, but I still clarifying a couple
> of things.
>
> 1) Can you use both /3G and AWE together? Do you get even more memory
> utilization with both? Or is it hierchachial, use /3g or if you want more,
> use AWE?
> 2) Can someone send (or post) an actual screenshot of what the boot.ini
> file should look like with these entries? I've read that your supposed to
> place the /3G entry "on the appropriate line", but other than putting it
> within the server configuration section, I'm not sure what "appropriate"
> means.
>
> Thanks!
>
> Ross
>

You got that right! Thanks.


"Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
news:%23oaOEPTXHHA.4216@TK2MSFTNGP02.phx.gbl...
> You are confused as to what each of these actually do so I suggest you
> read these articles:
>
> http://sqljunkies.com/Tutorial/0D4FF...2FE2D58F6.scuk
> Memory
> http://www.sql-server-performance.com/awe_memory.asp Using AWE Memory
> http://www.support.microsoft.com/?id=321363 SQL Server 7 & 2000
> memory usage
> http://www.support.microsoft.com/?id=274750 Memory config
> http://www.support.microsoft.com/?id=283037 Large Memory Support Is
> Available in Windows 2000 (AWE)
> http://www.support.microsoft.com/?id=811891 Can not use more than 2GB of
> memory
>
>
> --
> Andrew J. Kelly SQL MVP
>
> "Ross Culver" <rculver@warrenalloy.com> wrote in message
> news:uTtjRORXHHA.5008@TK2MSFTNGP05.phx.gbl...
>> I've read the articles and posting regarding increasing SQL's memory
>> utilization using either /3G or AWE, but I still clarifying a couple
>> of things.
>>
>> 1) Can you use both /3G and AWE together? Do you get even more memory
>> utilization with both? Or is it hierchachial, use /3g or if you want
>> more, use AWE?
>> 2) Can someone send (or post) an actual screenshot of what the boot.ini
>> file should look like with these entries? I've read that your supposed
>> to place the /3G entry "on the appropriate line", but other than putting
>> it within the server configuration section, I'm not sure what
>> "appropriate" means.
>>
>> Thanks!
>>
>> Ross
>>
>
>