Category Archives: Plan cache

Don’t believe everything you read: Reconfigure flushes the plan cache

I’ve been doing a fair bit of research and investigation into theĀ behaviorĀ of the plan cache recently. So I was concerned when I read somewhere that the reconfigure statement causes the SQL Server plan cache to be flushed. If this is … Continue reading

Posted in Plan cache, SQL Server, Uncategorized | Tagged , | 7 Comments

Plan cache in SQL Server 2008R2

I was curious to look at the effect of database options, on the SQL server plan cache. I have restored the Adventure works sample database onto my SQL Server 2008 R2 RTM instance four times as AW1, AW2, AW3 and … Continue reading

Posted in Plan cache, SQL Server | 1 Comment