I'm looking for recommendations/best practices for configuring SQL Server 2005 to take advantage of a recent memory upgrade to 32GB of RAM. The OS version is Windows 2003 64-bit Enterprise Edition. I've read that enabling "Address Windowing Extensions (AWE) is not required and cannot be configured on 64-bit operating systems."
Does this mean I don't have to do anything and SQL Server will take advantage of this memory by default? Please advise. Thanks!