If you're in the Kansas City area tomorrow night I'm going to be doing a presentation on the procedure cache, parameterization and parameter sniffing. Details are on the Kansas City SQL Server User Group web site. I'm a last minute fill in but this is a presentation I've been working on for a while. Just to get you started I'll post two queries that I use in the introduction:
SELECT sum(single_pages_kb) AS Single_Pages_KB , sum(single_pages_kb) / 1024 AS Single_Pages_MBFROM sys.dm_os_memory_cache_counters SELECT LEFT([name], 20) AS [Name], LEFT([type], 20) as [Type], ...