Post reply

Memory Spec for Enterprise says 2TB Max

  • January 24, 2011 at 9:36 am

    #230686

    Does that mean per instance on a server or total server? In other words if I have, as an example, 4TB on a server, can I have two instances each using 2TB?

    THanks!

  • January 24, 2011 at 10:34 am

    #1277344

    Scott,

    I don't have a solid answer for your question, I would say that it probably is 2TB per.

    However the number of installations that even remotely approach that size is infinitesimally small. So I'm thinking this is more theoretical than practical..

    CEWII

  • January 24, 2011 at 10:51 am

    #1277360

    The 2 TB limit applies only to SQL Server 2008 R2 Enterprise Edition.

    For SQL Server 2008 Enterprise Edition, the limit is Operating system maximum.

  • January 24, 2011 at 1:16 pm

    #1277441

    Just to wrap my head around the issue, are we discussing this 2TB issue:

    http://blogs.technet.com/b/askcore/archive/2010/02/18/understanding-the-2-tb-limit-in-windows-storage.aspx, which is storage related...

    or this one:

    http://www.techrepublic.com/blog/datacenter/sql-server-2008-r2-licensing-changes-and-feature-information/2715

    Which is RAM/Memory related?

    Most significantly, Microsoft has added a Datacenter edition to the SQL Server 2008 R2 line. With a maximum logical processor count of 256 and maximum RAM limited only by the limits of the underlying OS (2 TB for Windows Enterprise and Data Center), the Datacenter edition provides a clear upgrade path for organizations that are constrained by the much lower limits in the product’s Enterprise edition, which tops out at 8 CPUs and 2 TB of RAM. The Datacenter’s primary benefit centers around processing capabilities rather than RAM. In Microsoft’s literature, the Datacenter’s memory limit is “OS Maximum” which, for Windows Server 2008 R2 Data Center, is 2 TB, exactly the limit of SQL Server 2008 R2 Enterprise edition, so there’s not a lot of RAM benefit to be had. That said, the jump in supported CPU alone makes Datacenter a major move.

    So, unless you're running on a different OS than Microsoft, it's a moot point for your instances.

    However, assuming that the pattern from Standard limitations holds up through Enterprise, it would be a per instance issue.

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

Viewing 4 posts - 1 through 4 (of 4 total)

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