These commands will clear the cache from Microsoft SQL-server. It can be used during test to emulate runing a query against a “cold” server. A server where the cache hasn’t been filled with data.
DBCC DROPCLEANBUFFERS
DBCC FREEPROCCACHE
These commands will clear the cache from Microsoft SQL-server. It can be used during test to emulate runing a query against a “cold” server. A server where the cache hasn’t been filled with data.
DBCC DROPCLEANBUFFERS
DBCC FREEPROCCACHE