Geek Answers Handbook

SQL Server Explicit Memory

Is it possible to flush RAM from data filled with SQL Server?

Is there any procedure or option that can do this?

+1
source share
2 answers

you can use

CHECKPOINT
DBCC DROPCLEANBUFFERS

to delete all data pages from memory . It is useful to check server performance: the request is executed in different ways if the data pages that it needs are not cached.

+2
source

You do not free memory. If you want it to use less memory, add a limit to the server settings.

If you release the memory, this will slow down your requests, since everything will again need to be read from disk.

+2
source

More articles:


All Articles