Guru's Guide to SQL Server Architecture and Internals, The

Recap

So there you have it: SQL Server memory management in a nutshell. Understanding how an application allocates and manages memory is essential to understanding how the application itself works. Memory is such an important resource and its efficient use is such an integral element of sound application design that understanding how memory is managed by an application gives you great insight into the overall design of the application.