I blogged last year on clearing sql servers' various memory caches, useful for testing code.
I read this today and it turns out that what i'm achieving here is restarting the server without restarting (if you follow).
Those commands again ...
-- To clear the procedure cache
DBCC FREEPROCCACHE
-- To clear the data cache
DBCC DROPCLEANBUFFERS
No comments:
Post a Comment