To clear SQL Server’s cache, run DBCC DROPCLEANBUFFERS, which clears all data from the cache. Then run DBCC FREEPROCCACHE, which clears the stored procedure cache.
I never seem to have this info handy when I actually need to use it. Posting here for easy reference.
Source:
http://www.devx.com/tips/Tip/14401
No comments:
Post a Comment