SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 Is standard edition memory limit a hard limit?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

ferrethouse
Constraint Violating Yak Guru

327 Posts

Posted - 04/26/2013 :  11:57:39  Show Profile  Reply with Quote
I didn't realize that standard edition had a 64 gig memory limit. I expanded to 96 gigs and allocated 90 gigs to SQL Server. It seemed to gobble it all up (in process explorer). Does it appear to use all 90 gigs but actually only use 64 gigs? Or does it actually use 90 and I'm just violating the license agreement?

thanks.

Edited by - ferrethouse on 04/26/2013 11:58:01

chadmat
The Chadinator

USA
1974 Posts

Posted - 04/26/2013 :  23:19:07  Show Profile  Visit chadmat's Homepage  Reply with Quote
How are you determining that it is all being used? It should limit you to 64GB AFAIK.

-Chad
Go to Top of Page

ferrethouse
Constraint Violating Yak Guru

327 Posts

Posted - 04/27/2013 :  10:20:38  Show Profile  Reply with Quote
quote:
Originally posted by chadmat

How are you determining that it is all being used? It should limit you to 64GB AFAIK.

-Chad



Task manager was showing that the sql server process was using over 64 gigs (90). So I don't know if it was actually "using" it or just grabbing onto it.

Edited by - ferrethouse on 04/27/2013 10:21:09
Go to Top of Page

chadmat
The Chadinator

USA
1974 Posts

Posted - 04/27/2013 :  15:53:57  Show Profile  Visit chadmat's Homepage  Reply with Quote
Interesting. Check Total and Target server memory in perfmon, and you might use some of the memory DMVs to see what are the actual sizes of the various memory pools.

-Chad
Go to Top of Page

ferrethouse
Constraint Violating Yak Guru

327 Posts

Posted - 05/08/2013 :  18:40:09  Show Profile  Reply with Quote
It does in fact appear to be a hard limit. While SQL Server will grab as much memory as you allow it to (we set a 100 gig max) it appears to only actually use 64 gigs.

At least according to this query...

select sum(pages_kb)+ sum(virtual_memory_committed_kb)
from sys.dm_os_memory_clerks

Which does not appear to go above 64 gigs and change.
Go to Top of Page

russell
Pyro-ma-ni-yak

USA
5071 Posts

Posted - 05/08/2013 :  23:12:24  Show Profile  Visit russell's Homepage  Reply with Quote
It is a hard limit
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000