Would you suggest using AWE Memory on Windows 2008 R2 for MS SQL 2008?
What are the benefits of using it or not using it.
Thanks
AWE will allow a 32-bit SQL Server to use more than 2-3 GB of RAM. If it's not a 32-bit installation of SQL Server, or the system doesn't have more RAM than that, then you don't need to enable it.