Skip to main content

Explain the difference between Physical Reads, Logical Reads, and Page Life Expectancy.

Senior MS SQL
Quick Answer Physical Read: SQL Server fetched the page from disk (slow). Logical Read: page was found in the buffer pool (fast, in-memory). Logical reads measure how much work a query did in memory รขโ‚ฌโ€ lower is better. Page Life Expectancy (PLE) shows how long pages stay in the buffer pool รขโ‚ฌโ€ low PLE means memory pressure and frequent disk reads.

Answer

These metrics help diagnose I/O and memory performance in SQL Server.

Logical reads: The number of 8KB pages read from the buffer cache (memory). High logical reads can indicate inefficient queries or missing indexes.

Physical reads: Pages read from disk because they were not found in the buffer cache. Physical I/O is orders of magnitude slower than memory access.

Page Life Expectancy (PLE): An indicator of how long pages stay in the buffer cache before being evicted. A consistently low PLE suggests memory pressure or inefficient queries repeatedly flushing the cache.

Senior engineers use these metrics together to determine whether to focus on query tuning, indexing, or adding memory/storage capacity.

S
SugharaIQ Editorial Team Verified Answer

This answer has been peer-reviewed by industry experts holding senior engineering roles to ensure technical accuracy and relevance for modern interview standards.

Want to bookmark, take notes, or join discussions?

Sign in to access all features and personalize your learning experience.

Sign In Create Account

Source: SugharaIQ

Ready to level up? Start Practice