January 24, 2011 at 9:36 am
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
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
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
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:
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.
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