Clearing Caches in SQL Server — mattthehackdev


The following are a few useful commands for Database Performance testing: DBCC FREEPROCCACHE – Clears the procedure cache and forces SQL Server to recompile procedure plans the next time a respective procedure is run DBCC DROPCLEANBUFFERS – Clears the SQL Server data cache i.e any data that exists in the buffer cache from previous execution […]

via Clearing Caches in SQL Server — mattthehackdev

Advertisements