Answer
The buffer pool is SQL Server’s memory area used for caching data and index pages.
- Logical reads come from memory.
- Physical reads occur only when data is missing in cache.
- High buffer reuse improves performance.
If buffer pool is too small: more disk reads, lower PLE, and slower query execution.