Currently I run
DBCC FREEPROCCACHE when I want to wipe information out of the buffer pool between running SQL queries. However, I was reviewing this Technet article referencing
DBCC FREESYSTEMCACHE. What caches does
FREESYSTEMCACHE wipe that
There are many system caches available in SQL Server. I am referring to SQL 2008R2 (as I tested on it).
Below query will return all the caches available :
so for e.g. you want to clear all caches you will run
for specific caches to be cleared you can run
Using FREEPROCCACHE, you wont be able to clear all above mentioned at that detailed level.
FREEPROCCACHE ==> from BOL
So essentially, you might think of it as only related to Plan cache with the ability to remove specific plans from the cache with the plan handle and or pool name.
Fun With DBCC FREEPROCCACHE is a blog from Glenn Berry