SQL Server release 11.0 provides new optimization strategies and new commands to control the use of those strategies for objects, sessions, and queries. Figure 6-1 shows the two cache strategies.
Figure 6-1: Cache strategy choices
SQL Server can:
Read pages in at the start of the MRU (most recently used) chain in order to keep the pages in cache so that they can be accessed many times without performing additional I/O
Read pages in near the end of the cache so that they will not force other pages out of the cache
See Chapter 16, “Memory Use and Performance,” in the Performance and Tuning Guide for performance information on cache strategies.