Why Adding Some Memory Doesn’t Fix All Caching Problems
18 Comments
It seems obvious: add some memory, and SQL Server should be able to cache data, thereby making queries run faster … right? Well, if you can’t cache everything you need for a query, you might be surprised to find that SQL Server may still read the entire table up from disk, regardless of what parts of the…
Read More