If SQL Server is running slow and operations are throwing errors due to lack of memory, it is necessary to look into memory issue. If SQL Server is restarted all the cache memory is automatically cleaned up. In production server it is not possible to restart the server. In this scenario following three commands can be very useful.
When executed following three commands will free up memory for SQL Server by cleaning up its cache.
DBCC FREESYSTEMCACHE
DBCC FREESESSIONCACHE
DBCC FREEPROCCACHE
Reference : Pinal Dave (http://www.SQLAuthority.com)
=============== AND ===============================
For Microsoft SQL (MSSQL).
Use this to clear the cache and buffers to ensure comparison are accurate.
dbcc freeproccache
go
dbcc dropcleanbuffers
go
