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

Send a comment/complaint about this entry to Metamia.com:


Please provide any other details you think
will be useful to us in the text area below.