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?

SQL server release memmory after service restart, but if I won't need to restart, how can I clear memmory? I don't know if it is even possible, but I am curious whether SQL Server cover that topic — veljasije, Feb 01 '13 at 12:24

score 6 · Accepted Answer · answered Feb 01 '13 at 12:27

6

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.

answered Feb 01 '13 at 12:27

Andomar

score 2 · Answer 2 · answered Feb 01 '13 at 12:25

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.

answered Feb 01 '13 at 12:25

cjk

Slowing down of queries may be of secondary importance to what the OP is trying to achieve. – Reversed Engineer Jul 27 '17 at 13:22

2 Answers2