Please can someone explain the different Buffer and Cache structures in SQL Server.
How they relate and if the cache is at SQL Server Storage Engine Level or at a SQLOS Level or is it like a Namedspace on the Hard Drive or on Memory?
Is there a diagram that can help elucidate their interaction. Thank you.
View Complete Post