RE: Finding if there was CPU or memory pressure yesterday night

SSC Guru

Points: 1003863

May 16, 2016 at 3:15 pm

coolchaitu (5/16/2016)
A DBA maintenance job failed yesterday night. Is there a way to find if there was CPU or memory pressure when this job ran yesterday night..

Rather than jumping to that type of conclusion, what does the job log say as to what the failure reason was?

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