Memory
Because memory management is a huge topic, covering every detail of it would require a whole book in itself. SQL Server 2012 introduces a significant rewrite of the SQLOS Memory Manager and has the first significant changes in memory management since SQLOS was introduced in SQL Server 2005. The goal of this section is twofold.
To provide enough information about how SQL Server uses its memory resources so that you can determine whether memory is being managed well on your system
To describe the aspects of memory management that you have control over so that you can understand when to exert that control
By default, SQL Server 2012 manages its memory resources almost completely dynamically. When allocating memory, SQL Server must communicate ...
Get Microsoft SQL Server 2012 Internals now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
