Here is a curated list of Buffer Pool related links that I recommend visiting:
Buffer Pool Articles:
- docs.microsoft.com
- SentryOne
- Nothing Is Free, Including Buffer Space – By Jason Hall
- SimpleSQLServer.com –
- Cleaning up the Buffer Pool to Increase PLE (page life expectancy) by Steve Hood
- Query the Buffer Pool
Buffer Pool Presentations:
- Professional Association for SQL Server (requires free login)
- PASS Summit Recordings
- http://www.pass.org/Learning/Recordings/Listing.aspx?category=Summit
- The Great Buffer Pool Extension Mystery By John Martin
- Field Testing Buffer Pool Extension and In-Memory OLTP Features in SS2014
- http://www.pass.org/Learning/Recordings/Listing.aspx?category=Summit
- PASS Summit Recordings
Buffer Pool Articles from SQL Monitoring Tools:
- Redgate’s SQL Monitor:
- Buffer pressure – By Grant Fritchey
- Top buffer cache object – By Fabiano Amorim
- Solarwinds – logicalread.com
- SQL Server Memory Buffer Pools: Understand the BasicsLink TBD: – By Pinal Dave
Buffer Pool Videos:
- SQLPassion – SQL Server Quickie #22 – The Buffer Pool – by Klaus Aschenbrenner
- Direct YouTube Link:
- SQL Masters Consulting – SQL Server 2014 – Buffer Pool Extension
- Direct YouTube Link:
- SQLServer Work – What is the Buffer Pool
- Direct YouTube Link: