Maciej Pilecki - SQL Server lessons from the field - All Comments

re: Clearing your ad-hoc SQL plans while keeping your SP plans intact

Sankar13 — Thu, 09 Oct 2008 03:40:11 GMT

Nice tip Maciej! I cleared adhoc sql cache in 2 boxes which were 12-15 times bigger than the procedure cache.

Christian — Thu, 25 Sep 2008 16:16:37 GMT

Brilliant! Good thinking MacieJ, that's the best tip I've read in ages! :)

JasonMassie — Wed, 24 Sep 2008 04:21:23 GMT

Hi Maciej,

We met in Redmond for the 71-4?? test gig. Glad to see you are blogging.

I just wanted to say this is good info. I wish MS would document all of values that FREESYSTEMCACHE could take.

The "optimize for adhoc workloads" is a feature that will help too. I blogged about it tonight. statisticsio.com/.../This-Post-Needs-More-Stored-Procedures.aspx

tonyrogerson — Mon, 22 Sep 2008 07:27:25 GMT

Cool Maciej! Hear what you say though; what with work, home life etc... it's difficult to keep up....

Tony