a: Cache ~
b: junk drawer
What: "In a previous posts, SQL Server pros Patrick O'Keefe and Richard Douglas provided some tips on managing the SQL Server plan cache . If the plan cache is like the junk drawer on the bottom of your filing cabinet that stores some usefully, but also a lot of infrequently used stuff, the buffer cache is like the workspace folder on your desktop. It's the folder that has become a memory bank for files that you need handy or have in progress, and don't want to go searching through drives to access through a more cumbersome path. "
Writer: Patrick O'Keefe and Richard Douglas
Date: Aug 29 2014 7:49 PM
# 6160 Critique Analogy