question

Did you run a checkpoint before running any of the commands? Also are you sure you want to clear all of your proc and buffer cache? You are aware that everything will run slow while the caches are repopulated? I would NEVER run DBCC FREEPROCCACHE or DBCC DROPCLEANBUFFERS on a production system. Reducing memory allocation wont cause data loss, SQL will slowly move data from cache back to disk as part of its normal checkpointing and cleanup processes

SQL is designed to consume the memory you allocate to it. What DBCC commands have you run? Is this a production box? SQL does use memory from outside of its allocation for various processes. Linked servers, xp_oa... procedure calls, unsafe CLR etc If you want to reduce the amount of memory utilization, you will need to reduce the amount of memory you allocate to SQL

dbcc freesystemcache('all') with mark_in_use_for_removal dbcc freesessioncache with no_infomsgs dbcc freeproccache dbcc dropcleanbuffers I have executed the above commands. Yes, this a production box. If we will reduce the amount of memory utilization there is a chances of data loss. Is there anything u can suggest.

Yes i did run the checkpoint before running the commands. I will try the suggestion given by you and let you know in case of any issue.

Why are you concerned about the memory usage? Are you using that server for more than just SQL Server? You should limit SQL Server to the amount of RAM you are comfortable with it using. Are you experiencing performance or other issues?

We have a total of 16GB RAM and SQL is allocated around 12GB. We are facing high memory and CPU utilisation on server due to SQL. So, Plz suggest if something could be done to release the memory.