Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning stored procedure taking long time RE: stored procedure taking long time

  • 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)