How to find existing Query plans?

• Roy Ernest

  SSC-Dedicated

  Points: 38780

  More actions

  December 17, 2007 at 8:35 am

  #122762

  Hi All,

  I have a SP that suddenly started to behave abnormally. I am trying to find how many query plans are present for this particular stored Proc.

  I know that I could just do Update Statisitics and then mark the Stored proc fpr recompile and will probably fix it. But I want to know if it has more than one query plan.

  Can someone help me to find the query plans?

  Thanks

  Roy

  -Roy

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737778

  More actions

  December 17, 2007 at 8:55 am

  #760722

  This should help

  http://www.sqlteam.com/article/what-query-plans-are-in-sql-server-memory

• Tommy Bollhofer

  SSChampion

  Points: 14940

  More actions

  December 17, 2007 at 8:56 am

  #760723

  http://www.sqlteam.com/article/what-query-plans-are-in-sql-server-memory

  Tommy

  Follow @sqlscribe

• Tommy Bollhofer

  SSChampion

  Points: 14940

  More actions

  December 17, 2007 at 8:56 am

  #760724

  Steve beat me to it

  Tommy

  Follow @sqlscribe

• Roy Ernest

  SSC-Dedicated

  Points: 38780

  More actions

  December 17, 2007 at 9:02 am

  #760730

  Thanks to both of you. Appreciate it..:)

  -Roy