Search This Blog

Thursday, August 14, 2014

How to remove Cache and Buffers in MS SQL Server

To remove procedure/TSQL cache and buffers execute below queries.

DBCC FREEPROCCACHE
DBCC DROPCLEANBUFFERS

No comments:

Post a Comment