Query Timeout help

• brk5tr

  Ten Centuries

  Points: 1360

  More actions

  April 9, 2013 at 3:19 am

  #276253

  Hi,

  Could anyone tell me why the following query is timing out please?

  SELECT PLAN_HANDLE FROM SYS.DM_EXEC_PROCEDURE_STATS PS WHERE PS.PLAN_HANDLE = 0x05000A00ED4FE245402231CC000000000000000000000000

  If there is a better way to check if a specific plan exists in cache, please could you let me know.

  Thanks

• Jason Wolfkill

  SSCrazy Eights

  Points: 9832

  More actions

  April 10, 2013 at 8:41 am

  #1605264

  ggjjbb1983 (4/9/2013)

  ---

  Hi,

  Could anyone tell me why the following query is timing out please?

  SELECT PLAN_HANDLE FROM SYS.DM_EXEC_PROCEDURE_STATS PS WHERE PS.PLAN_HANDLE = 0x05000A00ED4FE245402231CC000000000000000000000000

  If there is a better way to check if a specific plan exists in cache, please could you let me know.

  Thanks

  What do you mean, "timing out"? Are you executing this from SSMS?

  Running the same query against sys.dm_exec_plan_cache will tell you whether a plan with that plan_handle exists in the cache.

  Jason Wolfkill