SQL Server clear memory

Question

Is it possible to clear RAM memory from data that SQL Server fill in?

Is there any procedure or option which can do that?

Answer 1

You can use

CHECKPOINT
DBCC DROPCLEANBUFFERS

to remove all data pages from memory. It's useful to test server performance: a query performs differently if the data pages it needs are not cached.

Answer 2

You don't release memory. If you want it to use less memory, then add the restriction in server settings.

If you did release the memory, it would slow down your queries as everything would have to be read from disk again.