Plan Cache refreshing every 24 hours

Question

Post reply

Plan Cache refreshing every 24 hours

Viewing 2 posts - 16 through 16 (of 16 total)

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

MMartin1 One Orange Chip Points: 27826 More actions · Answer 1

Thank you for that good information. I will start to look into this direction.

----------------------------------------------------

Jeff Moden SSC Guru Points: 1004556 More actions · Answer 2

The update stats job you have running every night isn't a huge problem. The rebuilding of plans is usually not a problem. Having stats rebuild in the middle of the day could be a huge problem, which is probably why someone create a job to do it at night.

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

Plan Cache refreshing every 24 hours

Cookies on SQLServerCentral