October 3, 2013 at 4:50 am
Hello,
I am building a new virtual server - Windows 2008 R2 DataCenter.
Installed SQL Server 2008 R2 Standard Edition - 64 bit.
The "Maximum server memory" is set to 4096 MB
The server is having 6GB RAM.
Why is SQL server crossing the threshold memory and utilizing most of the available 6GB RAM.
With no other client connection yet and in idle server condition, currently I have got only 400 MB available.
Why is it eating up most memory?
Thanks,
Bij
October 3, 2013 at 4:57 am
Output of DBCC MemoryStatus
VM Reserved 6394360
VM Committed 4379288
Locked Pages Allocated 0
Reserved Memory 1024
Reserved Memory In Use 0
October 3, 2013 at 6:08 am
Max server memory controls the buffer pool. SQL uses a small amount of memory outside of the buffer pool as well. If SQL's using too much memory, drop max server memory.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 3, 2013 at 8:40 am
have you experienced the memory crunch after the max memory decrement ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 4, 2013 at 10:19 am
Thank you Gail.
That seems to have worked. I reduced to half the given memory and so far it's not crossed the threshold drastically.
Given that, I will need extra 2 GB on it to make it functional - production server.
Thanks once again.
You are a star!
Bij
October 4, 2013 at 10:24 am
kotharibij (10/4/2013)
Given that, I will need extra 2 GB on it to make it functional - production server.
Is it a good time to point out that my home gaming machine has twice the memory of your production server and my home media server has almost three times the memory of your production server?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply