question

beingwase avatar image
beingwase asked

High memory usage

Hello, I'm going through high physical memory usage in SQL Server. It always around 90%. I have executed some queries of DBCC but still the memory is at its peak. can anyone please suggest me with suitable answer. server memory:16GB Instance allocated memory:14.4 GB
memory-utilization
7 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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
5 Likes 5 ·
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
3 Likes 3 ·
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.
0 Likes 0 ·
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.
0 Likes 0 ·
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?
0 Likes 0 ·
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.
0 Likes 0 ·
Show more comments

1 Answer

· Write an Answer
akash_101 avatar image
akash_101 answered
you can Use the 2 server memory options, min server memory and max server memory, to reconfigure the amount of memory (in MB) managed by SQL Server Memory Manager for an instance of SQL Server.. hope it helps
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.