Home Forums SQL Server 2008 T-SQL (SS2K8) high cpu RE: high cpu

  • January 1, 2014 at 12:37 pm

    #1676756

    pmadhavapeddi22 (12/19/2013)

    Hi

    I have one stored procedure which in turn executes 3 more sps in it.

    All the 4 stored procedures just update the records of two tables. Every column is updated individually.(20 columns for each table)

    But the rows in each table are above 2,00,000. So the cpu is almost touching 100% for 30 secs.

    We have a job which executes this SP for every five minutes. So, cpu touches 100%

    very frequently.

    Please suggest me to avoid this 100% cpu utilization.

    (let me know if you need any other information )

    Actually, this is a common problem caused by an illegal form of the UPDATE statement. Please post the UPDATE statements involved so I can see if they have that problem.

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