Home Forums SQL Server 2008 SQL Server Newbies Finding if there was CPU or memory pressure yesterday night RE: Finding if there was CPU or memory pressure yesterday night

  • June 1, 2016 at 1:37 pm

    #1882633

    coolchaitu (6/1/2016)

    Hi Jeff,

    The Senior DBA got CPU and memory utilization data for last 7 days from system admin team. He found that there was no CPU or memory pressure when the job ran.

    Thank you. Did you figure out what the actual cause was? Can you post the error from the job history?

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