stored procedure taking long time

• mpradeep23

  SSCommitted

  Points: 1868

  More actions

  January 2, 2015 at 8:27 pm

  #313332

  hi team

  my stored procedure was running fine

  now it is taking long time what are the steps i need to follow to check what is the problem

  thanks,

  pradeep

• pietlinden

  SSC Guru

  Points: 63503

  More actions

  January 2, 2015 at 9:29 pm

  #1767517

  Got details??

  A rough analogy to your description is like saying that "my car used to run fine, now it doesn't." The obvious response is "What changed between when it worked well and now?"

  What does your stored procedure do? Can you post the T-SQL for it?

• Jeff Moden

  SSC Guru

  Points: 1004356

  More actions

  January 2, 2015 at 9:38 pm

  #1767518

  mpradeep23 (1/2/2015)

  ---

  hi team

  my stored procedure was running fine

  now it is taking long time what are the steps i need to follow to check what is the problem

  thanks,

  pradeep

  Step 1. Determine what the values of the input parameters are. (I normally do this with a quick trip to the SQL profiler).

  Step 2. Call the proc using the input parameters with the "Actual Execution Plan" enabled.

  Step 3. Analyze the execution plan.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)