Browse by Tags

What events will cause a flushing of plan in cache?

Published 14 May 7 7:17 AM | SqlServer-QA.net (SSQA)

We already know that using DBCC FREEPROCCACHE will have the affect of flushing all the cache with immediate affect and also DBCC FREESYSTEMCACHE (new in SQL 2005) has similar affect but will flush the plans asynchronously that are marked as unused anymore...

Filed under: sql server, management, memory, security, perfmance, plan, cache

Reset cached plan - how to and what to?

Published 14 May 7 3:53 AM | SqlServer-QA.net (SSQA)

I don't believe you would need to reset the cache on a production server, it is not a best practice to perform in this case. Most of the times in development or test environments for the purpose of benchmarking you would need to reset the cache for...

Filed under: sql server, package, indexes, memory, integration, perfmance, plan, cache