I'm constantly surprised by the number of people that don't follow the CSS SQL blog – some of the best SQL people in the industry post there. I just revisited a couple of really interesting posts by my good friend Bob Ward on memory management internals that I'd like to publicize.

The first (from June this year) discusses the Large Page allocations that can occur on 64-bit systems and how they affect the memory used by SQL Server. Apart from explaining how this works and the conditions under which it is possible, this post also explains some of the potential problems that may occur from using them, especially with fragmented Windows Server memory. You can get to the blog post at: SQL Server and Large Pages Explained…

The second post from a week or so ago discusses the MemToLeave behavior of SQL Server (leaving memory from SQL Server's virtual address space for stuff outside the buffer pool) and some of the issues around that (and that it doesn't happen on 64-bit systems). You can get to that post at: Come on 64bit so we can leave the mem…

Enjoy!