Finding if there was CPU or memory pressure yesterday night

Question

Post reply

Finding if there was CPU or memory pressure yesterday night

coolchaitu

SSChampion

Points: 10332
More actions
May 16, 2016 at 8:57 am

#316553

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

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

joeroshan SSChampion Points: 10377 More actions · Answer 1

You can get some info from DMV, if the instance hasn't been restarted in between.

https://sqlserverperformance.wordpress.com/2010/04/20/a-dmv-a-day-%E2%80%93-day-21/

----------------------------------------------------------------------------------------------------------------------------------------------------
Roshan Joe

Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Joie Andrew One Orange Chip Points: 27360 More actions · Answer 2

Do you have a monitoring tool like SCOM or a third-party tool? That could also be pulling metrics data that you can view over time.

Joie Andrew
"Since 1982"

Jeff Moden SSC Guru Points: 1003859 More actions · Answer 3

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)

gfoxxy93 Right there with Babe Points: 776 More actions · Answer 4

Do you have any performance counters running on the server?

Jeff Moden SSC Guru Points: 1003859 More actions · Answer 5

gfoxxy93 (5/31/2016)
Do you have any performance counters running on the server?

Even if someone did, it's a bit crazy to start looking at things like performance counters unless the error from the failed job had something in it to lead one to think it was CPU or Memory. We don't even know what the "maintenance job" that failed was.

It also appears that the OP has become unresponsive. Can't help much when there's no responses to the posts.

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

coolchaitu SSChampion Points: 10332 More actions · Answer 6

Good morning experts

Sorry for delay. Our senior dba got the data from the sysadmin team. Thanks a lot for your help

Jeff Moden SSC Guru Points: 1003859 More actions · Answer 7

coolchaitu (5/31/2016)
Good morning experts
Sorry for delay. Our senior dba got the data from the sysadmin team. Thanks a lot for your help

Two way street. What data did the DBA get from the sysadmin team and did it actually help figure out why the maintenance plan failed?

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

coolchaitu SSChampion Points: 10332 More actions · Answer 8

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.

Joie Andrew One Orange Chip Points: 27360 More actions · Answer 9

Do did you find out what the cause of your failed maintenance plan was? What did the maintenance plan history show?

Joie Andrew
"Since 1982"

Jeff Moden SSC Guru Points: 1003859 More actions · Answer 10

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)