sql server how to clear cache code example

Example 1: clear query cache sql server

DBCC FREEPROCCACHE
DBCC DROPCLEANBUFFERS

DBCC DROPCLEANBUFFERS clears clean (unmodified) pages from the buffer pool
Precede that with a CHECKPOINT to flush any dirty pages to disk first
DBCC FLUSHPROCINDB clears execution plans for that database

Example 2: sql server management studio reset cache

sql server reset cach

Tags:

Sql Example

Related