Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Memory threshold for SQL server 2008 Expand / Collapse
Author
Message
Posted Thursday, October 3, 2013 4:50 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, March 20, 2014 9:49 AM
Points: 19, Visits: 72
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
Post #1501110
Posted Thursday, October 3, 2013 4:57 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, March 20, 2014 9:49 AM
Points: 19, Visits: 72
Output of DBCC MemoryStatus

VM Reserved 6394360
VM Committed 4379288
Locked Pages Allocated 0
Reserved Memory 1024
Reserved Memory In Use 0
Post #1501113
Posted Thursday, October 3, 2013 6:08 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 10:05 AM
Points: 42,829, Visits: 35,961
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 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1501139
Posted Thursday, October 3, 2013 8:40 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 12:26 AM
Points: 2,840, Visits: 3,963
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
Post #1501223
Posted Friday, October 4, 2013 10:19 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, March 20, 2014 9:49 AM
Points: 19, Visits: 72
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
Post #1501669
Posted Friday, October 4, 2013 10:24 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 10:05 AM
Points: 42,829, Visits: 35,961
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 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1501673
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse