Is AWE enabled on SQL 2005 Standard? We currently have it setup using "locked pages in memory" for a domain account and haven't noticed any performance problems.
This article however states that only the SQL2005 Enterprise Edn supports "locked pages in memory". Can anyone confirm this?
http://support.microsoft.com/kb/918483
If I'm mistaken, how should the memory options be set for a server with 8gb ram running on SQL 2005 Standard which runs on Win2003 Enterprise? Should the min and max memory be set or left alone as default?
SQL 2005 does support AWE. However it does not support "locked pages in memory".
SQL 2005 should be set with AWE and the OS should have /3GB and /PAE in the boot.ini. This will allow Standard Edition to use all 8 Gigs of memory. Set the max memory to between 7 and 7.5 Gigs of memory.
|||Thanks. Our current configuration has the switches /3GB and /PAE, but it wasn't clear on the "locked pages in memory". Do you know the benefit of having this feature? Also, what would you recommend our minimum memory to be set to?
No comments:
Post a Comment