Two scripts I share with clients all the time: they show the plan cache and data cache in memory, with cached plans by size and cached pages by table.
SQL SERVER – Minimum Maximum Memory – Server Memory Options
While reading about server memory options, I learned the lowest value you can set for max server memory is 16 MB. Anything lower is reset to 16 MB.
SQL SERVER – Queries Waiting for Memory Allocation to Execute
Find queries waiting for memory allocation with sys.dm_exec_query_memory_grants, plus wait_order and the query plan, when you suspect memory is short.
SQL SERVER – AWE (Address Windowing Extensions) Explained in Simple Words
What is AWE? Address Windowing Extensions let 32 bit SQL Server use very large amounts of physical memory. Here it is explained in simple words.
SQL SERVER – DBCC Commands to Free SQL Server Memory Caches
You do not need to restart the server to clear SQL Server memory caches. DBCC FREESYSTEMCACHE and related DBCC commands do it, for the rare times you need it.