Swimming in SQL's Buffer Pool

SQL Server will typically consume all the memory that you give it, and the Buffer Pool is the area of SQL Server that caches your database in this memory. Knowing how SQL Server adds to and removes data from the Buffer Pool can be advantageous to optimize your workload, whether it is an OLTP or Data Warehouse workload. We’ll also learn about the Lazy Writer, the Checkpointer and look at some more advanced DBCC commands.