Find plan_handle

• Kwisatz78

  SSChampion

  Points: 12478

  More actions

  January 10, 2013 at 7:57 am

  #269181

  Hi - 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?

  Thanks

• Kwisatz78

  SSChampion

  Points: 12478

  More actions

  January 10, 2013 at 9:06 am

  #1575858

  Have figured it out by using this query:

  SELECT UseCounts, Cacheobjtype, Objtype, TEXT, query_plan, plan_handle

  FROM 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 '%%'