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

  • February 12, 2014 at 7:46 am

    #1688352

    pmadhavapeddi22 (2/12/2014)

    jeff,

    I have re written the query by joining the de norm table in from clause, but the no of

    reads and cpu are high with the new query. Old query is showing low cpu and less no of reads. I also executed DTA for any new indexes but it showed no recommendations

    Thanks

    I have to admit that you have just confused the heck out of me. I thought you said you were at 100% before. Please post the same query you made changes to and let's have a look. You might have done the new join incorrectly.

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