The buffer pool is SQL Server’s cache. It keeps 8 KB data pages in memory to avoid physical disk reads. The key internal components covered in the PDF include:
SELECT name, log_reuse_wait_desc FROM sys.databases WHERE name = 'SalesDB'; Guru Guide To Sql Server Architecture And Internals.pdf
The result: last_user_seek was yesterday. modifications was over 50,000. The buffer pool is SQL Server’s cache
The buffer pool is SQL Server’s cache. It keeps 8 KB data pages in memory to avoid physical disk reads. The key internal components covered in the PDF include:
SELECT name, log_reuse_wait_desc FROM sys.databases WHERE name = 'SalesDB';
The result: last_user_seek was yesterday. modifications was over 50,000.