SQL SERVER - Clear Buffer Pool or Clear Cache Memory

Note: I will suggest to you don't run below query on the production server because it's slow down your performance.

So using the following query you can Drop or clear the Cache Memory in SQL Server.

DBCC DROPCLEANBUFFERS;

Result:

DBCC execution completed. If DBCC printed error messages, contact your system administrator.