• charbeljoseph (12/10/2008)


    Hi All,

    We have two clustered SQL Server 2005 Standard Edition based on Windows Server 2003 Enterprise R2 32Bit with those hardware specification:

    Intel Xeon CPU 3.16Ghz with 24GB of Ram.

    Do u advice us to enable AWE Memory for SQL Server ?? And what are the other methods to benefit from the maximum available memory on the server.

    and what about Enabling the Lock Pages in Memory Option (Windows)?

    Thank you

    You can enable for AWE while using Standard Edition, for more information see in SQL BOL.

    http://www.microsoft.com/Sqlserver/2005/en/us/compare-features.aspx