Posted by Erland Sommarskog on 09/13/06 07:27

(masri999@gmail.com) writes:
> [Sri] My information is that , once you turn AWE , you should turn off
> Dynamically Configure memory . Otherwise SQL Server will utilise all
> the memory and leaving 128 MB to O/S . Am I right ?

Not entirely, but in essence. Since I don't this stuff too well, I looked in
Books Online. Check the topic "Using AWE Memory on Windows 2000" in Books
Online. There is also another configuration parameter "awe enabled" that
you need to change.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: cross server update problem
• Prev in forum: Flattening Parent Child, an issue, please help
• Thread view: Re: Memory setting right ?

[Reply to this message]