Buffer Pool

Here is a curated list of Buffer Pool related links that I recommend visiting:

Buffer Pool Articles:

• docs.microsoft.com
  • Buffer Management
    • https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/aa337525(v=sql.105)
      • Reading Pages
        • https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/ms191475(v%3dsql.105)
      • Writing Pages
        • https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/aa337560(v%3dsql.105)
•  SentryOne
  • Nothing Is Free, Including Buffer Space – By Jason Hall
    • https://blogs.sentryone.com/jasonhall/nothing-is-free-including-buffer-space/
• SimpleSQLServer.com –
  • Cleaning up the Buffer Pool to Increase PLE (page life expectancy) by Steve Hood
    • http://simplesqlserver.com/2014/01/08/cleaning-up-the-buffer-pool/
  • Query the Buffer Pool
    • http://www.sqlservercentral.com/blogs/simple-sql-server/2016/01/04/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

Buffer Pool Articles from SQL Monitoring Tools:

• Redgate’s SQL Monitor:
  • Buffer pressure – By Grant Fritchey
    • http://sqlmonitormetrics.red-gate.com/buffer-pressure/
  • Top buffer cache object – By Fabiano Amorim
    • http://sqlmonitormetrics.red-gate.com/top-buffer-cache-object/
• Solarwinds – logicalread.com
  • SQL Server Memory Buffer Pools: Understand the BasicsLink TBD: – By Pinal Dave
    • https://logicalread.com/sql-server-memory-buffer-pools-pd01/#.W06_20xFw1U

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: