Day: May 1, 2008

Checking the cached execution plans

We are going to take a look into sys.dm_exec_cached_plans, sys.dm_exec_requests, sys.dm_exec_query_plan, and sys.dm_exec_plan_attributes.