Steve Jones - Editor (5/27/2008)
Tend to agree with Michael. Monitor and observe the system. AWE isn't needed for 64-bit and my guess is SQL will keep building cache and run to 30GB unless you limit it.
It's true that because of the vast amount of virtual address space available in 64-bit, the need for AWE is greatly diminished.
However, memory allocated through AWE is locked in (will not get paged out), and that may be beneficial for app performance even in a 64-bit environment (albeit at the risk of starving other processes off of needed memory).
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]