Hi Friends,

Performance tuning/ Query tuning in SQL Server is a combo of art and science. During the query tuning, we sometimes need to clear the cache for actual benchmarking purposes. Here is the code to do that:

To clear data from cache globally:

DBCC DROPCLEANBUFFERS;
To clear execution plans from cache globally:

DBCC FREEPROCCACHE;
To clear execution plans of a particular database:

DBCC FLUSHPROCINDB(<db_id>);

The above command is undocumented.

Note: Be careful of using the above commands in your productuon enviornments. It may impact performence negatively to a good extent. We use it more to analyze performance in test enviornments.