LRU-K algorithm – Quick look
Dear Friends, To start with; we can use a data or index page only when they exist in memory. For improved performance it is very important to keep alive the supply …
Read MoreTag: buffer cache
SQL Server max memory – why to cap in 64 bit environments
Hi Friends, There is lot of questions floating around sql server max memory capping in 64 bit environments which I thought of discussing with an example so that we could have a picture as …
Read MoreSQL Server Key Lookup vs Index Seek – Buffer Pool Part 3
Hi Friends, Today I am going to explain about the impact of non clustered indexes on buffer pool or you can also say it as SQL Server key lookup vs index …
Read MoreSQL Server Buffer Pool Part 2: Impact of Clustered Index on Buffer Pool
Hi Friends, Here, I am going to introduce you with a very interesting thing about clustered indexes. We all knew that when we execute a particular select query then the required …
Read MoreSQL Server Buffer Pool Part 1: Deep Look inside buffer pool
Hi Friends, Today, i am going to explain various things about the sql server buffer pool which is also known as buffer cache. Buffer Pool consist of various type of cache …
Read More