Thursday, May 31, 2012

Delete cache

When You need to delete data from cache, it can be done with following command:


DBCC DROPCLEANBUFFERS
 
On link more info about this subject can be found.
 
Also, if You want to remove procedure plans from cache, it can be done with following command:

DBCC FREEPROCCACHE

 On following link more info can be found. 

No comments:

Post a Comment