Stored procedure runs very slow

• beninimus

  SSC Veteran

  Points: 213

  More actions

  July 8, 2010 at 2:01 am

  #223059

  Hi,

  I have a stored procedure that runs for several minutes but when running the query in QA, it takes only 4seconds.

  I've already researched and done the following but to no avail:

  1. Dropped and re-created the stored procedure

  2. Used parameter sniffing method

  Hope somebody can help me ASAP.. 🙂

  Thanks in advance!

• Dave Ballantyne

  SSC-Dedicated

  Points: 33667

  More actions

  July 8, 2010 at 2:42 am

  #1190062

  Please see this article

  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  ---

  
  Clear Sky SQL
  My Blog[/url]