sql server 2012 memory limit

Question

sql server 2012 memory limit

timscronin

SSCertifiable

Points: 6851
More actions
June 4, 2013 at 1:23 pm

#294899

My bad it looks like sql 2012 standard edition only can use 64 gig of memory (change from 2008) 2 ?, I have seen some people post this is not true, anyone else seen that. Also I have an active passive cluster, since my server has 256 Gig of Ram could I create another active/passive cluster and set aside 64 gig for this and 64 gig for the existing cluster?

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

i don't think there's a limit on RAM;

the default setting is 2048 terabytes of ram as the default maximum setting until you change it to something less than what is really available;

where are you seeing 64 gig?

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

timscronin SSCertifiable Points: 6851 More actions · Answer 2

timscronin

SSCertifiable

Points: 6851

June 4, 2013 at 1:34 pm

#1621091

microsoft

Lowell SSC Guru Points: 323518 More actions · Answer 3

oops yes i see that now on this page:

http://msdn.microsoft.com/en-us/library/cc645993.aspx

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Michael Valentine Jones SSC Guru Points: 64818 More actions · Answer 4

64 GB is the limit for SQL Server 2012 Standard Edition

Memory Supported by the Editions of SQL Server

http://msdn.microsoft.com/en-us/library/ms143685(v=sql.105).aspx

timscronin SSCertifiable Points: 6851 More actions · Answer 5

that sucks but it looks like I could setup multiple instances using sql standard edition, which would give me 2 active passive clusters

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 6

That's not a new limit. SQL 2008 R2 standard edition only supported 64GB of 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

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

HowardW One Orange Chip Points: 29109 More actions · Answer 7

GilaMonster (6/4/2013)
That's not a new limit. SQL 2008 R2 standard edition only supported 64GB of memory.

It was new to R2, though, I believe? 2008 allowed the OS limit in standard edition.

Evgeny Garaev SSCertifiable Points: 7428 More actions · Answer 8

HowardW (6/5/2013)
GilaMonster (6/4/2013)
That's not a new limit. SQL 2008 R2 standard edition only supported 64GB of memory.
It was new to R2, though, I believe? 2008 allowed the OS limit in standard edition.

Same limit was for SQL Server 2005.