Tuesday, August 29, 2006

Plan cache gets cleared

"Blog this!", my colleague said to me, so I am. Just a simple note this time to mention that when you change the max degree of parallelism on an instance, the plan cache gets cleared. Kind of logic when you think about it because you are changing the rules for the stored plans, but nevertheless he thought it was useful info.

EXEC sp_configure 'max degree of parallelism', 0
RECONFIGURE

2 comments:

WesleyB said...

Thanks for listening to me. Now my long term memory is spread over 2 different sites :-)

NickVdA said...

>Nah, you wouldn't read my blog even if I would write one.

Actually... I do read your blog :)