In SQL Server : Remove Unused Cache MARK_IN_USE_FOR_REMOVAL

 

Remove Unused Cache

Sometimes we realized that overall system is working fine after we tuned Disk IO and CPU. 

However, there is still some issue with the SQL Server and then we have to figured out and found that it is related to the memory. 

We realize that there are lots of unused plans in the cache and by removing them we can able to make the memory available to the SQL Server.

Here is the command which we can run to release entries from all current caches once the entries become unused.

DBCC FREESYSTEMCACHE ('ALL') 

WITH MARK_IN_USE_FOR_REMOVAL;

Now, this process should be automatic and one should not be doing this manually. 

Once we clear up unused cache, and right after that, we are able to get the necessary performance.