SQL Server Read Ahead Mechanism
Hi Friends, SQL Server Read Ahead mechanism allows to anticipate the need and fetch a data or index pages into buffer pool before they are actually needed. This is completely managed …
Read MoreTag: Buffer Pool
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 MoreSQL 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: Observing SQL Server Data Cache (Buffer Pool concepts)
Hi Friends, The Data Cache is the largest portion of SQL Server Buffer Pool, the main memory consumer in SQL Server. Data Cache is the place where every 8 KB page …
Read More