Most frequently run queries can consume large SQL Server resources even when each call is fast; use plan cache and Query Store to find them.
Reading Memory Clerks to See Where Memory Goes
Memory clerks show how SQL Server allocates memory among engine components; learn to read the DMV, spot unusual growth, and investigate safely.
SQL SERVER – 2005 – Different Types of Cache Objects
A quick look at the different types of cache objects SQL Server 2005 keeps in the procedure cache, from a troubleshooting book I reviewed.
Scaling Out Read Queries
Scaling out read queries uses replicas, caches, and routing with measured freshness and operating cost; learn when each path fits.
Low Memory Signals in the Resource Monitor Ring Buffer
Read the resource monitor ring buffer alongside Windows and process memory signals to investigate cache shrinkage in SQL Server.