This may be last post in Performance Tuning & Security blog section here for this year!! Most of this year in the forums & newsgroups I have seen a common question asking about memory configuration within SQL Server 2005. As you may be aware that SQL Server 2005 (onwards) the memory allocation is set to DYNAMIC, that means the available memory on the server will be allocated to SQL Server and released whenever a windows service requests for such a memory. This includes when AWE is enabled....(
read more)
Read the complete post at http://sqlserver-qa.net/blogs/perftune/archive/2007/12/28/3048.aspx