Post reply

Query Timeout help

  • 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

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply