5 Replies Latest reply on May 8, 2017 11:24 AM by njohnson@collectors.com

    Tying Plan Hash to query_plan_hash in SQL Server

    code_joe

      I have a problematic plan that I can find in DPA.  I would like to drop this plan from SQL server using DBCC FREEPROCCACHE.  The problem I am running into is that I can't find any way to correlate the Plan Hash in DPA (Plan Hash: 4468022644) to SQL Server DMV hash values such as query_plan_hash: 0xE57B30BE47CDFD80

       

      Is there any way to correlate the two?