To find the SQL Statement

• ramana3327

  SSCoach

  Points: 19722

  More actions

  April 11, 2014 at 12:49 pm

  #292268

  Hi,

  Might be you feel like class room question but hoping some one will give answer.

  1)What is the plan_handle, query_hash & query_plan_hash? What is the use?

  2) How to retrieve the query that was executed by using these values?

  Please let me know. Thanks in advance

  Thanks,

  Ramana

• TheSQLGuru

  SSC Guru

  Points: 134017

  More actions

  April 11, 2014 at 2:20 pm

  #1705472

  Try out Grant Fritchey's free ebook on execution plans: https://www.simple-talk.com/books/sql-books/sql-server-execution-plans,-second-edition,-by-grant-fritchey/

  Best,
  Kevin G. Boles
  SQL Server Consultant
  SQL MVP 2007-2012
  TheSQLGuru on googles mail service

• ramana3327

  SSCoach

  Points: 19722

  More actions

  April 11, 2014 at 3:51 pm

  #1705477

  Ok. Thank you

• Grant Fritchey

  SSC Guru

  Points: 398890

  More actions

  April 12, 2014 at 6:41 am

  #1705526

  Also take a look at Louis Davidson and Tim Ford's book on Dynamice Management Views.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning

• ramana3327

  SSCoach

  Points: 19722

  More actions

  April 13, 2014 at 7:28 pm

  #1705618

  Thanks Grant. I will take look