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

No critique for this page.
Feel free to be the first

Please review the linked page for context.
If you can think of something better than this,
please add it to the database

(email or url) optional

This is an anti-spam device. Are you Human?

If so, please click the circle next to 'Yes' to submit your comment