Tech Dreams

How To Clear SQL Server Query Cache

While analyzing performance of queries we may need to find out the amount of time taken by SQL queries. In order  to find the exact amount of time taken by queries, we should clear the SQL Server buffers that cache the data and store procedure execution plans .

The following two commands clear SQL Server cache and helps you in identifying the exact amount of time required for execution of queries

DBCC DROPCLEANBUFFERS  
DBCC FREEPROCCACHE