Locked Pages, AWE, Task Manager and the Working Set
A great post from Bob that de-mystifies a lot of common memory misconceptions ... Source : Bob Ward - CSS SQL Server Engineers - MSDN.com
A Walk Down Memory Lane
A fantastic powerpoint presentation from Christian that covers all of the important memory configuration tasks including the limits of 32 bit systems, the memtoleave area, considerations for 64 bit systems, AWE on 32/64 bit systems and setting mix/max memory values ... Source : Christian Bolton - Coeo.com - pdf presentation
64 Bit & AWE
In this post, Slava clears up some confusion surrounding 64 bit & AWE. Be sure to read the comments for further illumination ... Source : Slava Oks - MSDN.com - Blog Post
Does SQL Server respond to Memory Pressure?
Another great Q&A post from Slava. In this one, he answers a question about how SQL Server 2005 responds to memory pressure regardless of the Lock Pages in Memory Setting. He also covers the importance of setting a Maximum Memory value to avoid memory pressure situations ... Source : Slava Oks - MSDN.com - Blog Post
MemToLeave and 32-bit SQL Backup failures
A common symptom of MemToLeave issues on 32 bit systems are backup failures with "reserve contiguous memory" related errors. In this post, Joe discusses adjusting the BufferCount and MaxTransferSize as an alternative to increasing the MemToLeave value (-g switch) ... Source : Joe Chang - SQLBlog.com - Blog Post
SQL Server Memory Usage & Task Manager
Relying on Task Manager to determine SQL Server's memory usage can be quite confusing unless you know how/what to look at ... Source : Kevin Kline - SQLBlog.com