SQL Server internals

Articles on SQL Server internals, with measurements of the engine, its memory structures and its plan cache.

SQL Server plan cache

How SQL Server caches compiled plans: stores, cache keys, parameterization, entry costs, eviction, limits, invalidation, and clearing, from 2005 to 2025.