Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Memory settings


SQL Memory settings

Author
Message
TST1
TST1
SSC Journeyman
SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)

Group: General Forum Members
Points: 88 Visits: 281
Hi,

I have SQL 2008 R2 installed on win2012 standard with 64 gig of ram. I have set sql to use 53 gig but task manager is only showing sqlserv using 32 gig? Any ideas?

Thanks
kshaileshbca
kshaileshbca
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 21
It is depend on system file installation. if you have installed windows on 32-bit platform, SQL consume max 32 GB.
you have to install Windows and SQL server both on 64 bit platform.
i sure, it will help you.
GilaMonster
GilaMonster
SSC-Forever
SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)

Group: General Forum Members
Points: 47189 Visits: 44356
kshaileshbca (3/15/2014)
if you have installed windows on 32-bit platform, SQL consume max 32 GB.


You might want to check your facts....
The memory limit on 32 bit is, in fact 2GB by default. 3GB with the /3GB switch and well above 32 GB with the /PAE switch and AWE enabled


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

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


GilaMonster
GilaMonster
SSC-Forever
SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)

Group: General Forum Members
Points: 47189 Visits: 44356
TST, hard to say anything definitive without a lot more data, but if SQL doesn't need more than 32GB it won't necessarily allocate more.

Check that nothing else on the server is consuming a lot of memory. Make sure you don't have large pages enabled. If it's a VM, check what the reserved memory is for that guest.

Are there signs of memory pressure? Is SQL under any load?


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

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


Greg Edwards-268690
Greg Edwards-268690
SSC Eights!
SSC Eights! (817 reputation)SSC Eights! (817 reputation)SSC Eights! (817 reputation)SSC Eights! (817 reputation)SSC Eights! (817 reputation)SSC Eights! (817 reputation)SSC Eights! (817 reputation)SSC Eights! (817 reputation)

Group: General Forum Members
Points: 817 Visits: 8254
First thing I would look at is Windows able to see all the memory.
If Windows cannot see the 64GB, neither will SQL server.
Not all versions can see 64GB, and Numa architecture actual memory configuration can be a factor.
I had a 2 proc machine, we took one proc out for licensing, and needed to fill certain slots that the one proc could see.
You could override this in the BIOS, but not as efficient.

Then as Gail mentioned, SQL will not use the full allocation unless it needs to.
So you would have to check for signs of memory pressure.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search