Monday 1 December 2008

SQL Restart without a restart...

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: