InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 17:34:37 GMT20http://www.sqlservercentral.com/Forums/Topic1405474-391-1.aspxHave figured it out by using this query:[code="sql"]SELECT UseCounts, Cacheobjtype, Objtype, TEXT, query_plan, plan_handleFROM sys.dm_exec_cached_plans CROSS APPLY sys.dm_exec_sql_text(plan_handle)CROSS APPLY sys.dm_exec_query_plan(plan_handle)WHERE TEXT like '%%'[/code]Thu, 10 Jan 2013 09:06:19 GMTKwisatz78http://www.sqlservercentral.com/Forums/Topic1405474-391-1.aspxHi - If I know the executing query whats the best way to get the plan_handle such that I can look at the plan in the plan cache?ThanksThu, 10 Jan 2013 07:57:47 GMTKwisatz78