Hi All, I have a single instance SQL 2005 EE, on win 2003 EE box with 16GB RAM.To fully utilize all the available memory I decided to go for AWE enabled. I have implemented following steps to achive this 1. Add /pae at the end of last line inside c:\boot.ini 2. Run gpedit.msc. On the left hand pane,...

Hi Everyone, The following article I read puzzles me regarding the Paging File, http://technet2.microsoft.com/windowsserver/en/library/00284c8d-7a42-40f2-8a01-8de61dccd8c91033.mspx?mfr=true. "... Under such circumstances, the effectiveness of this large of page file could be minimal, based on the...

Check out the AWE memory tips on this website. Yes, you do need to turn own on, which is explained in the tips section.