UPDATE: Maximum Capacity Specification for SQL Server in BOL from CTP 6

There are some items to validate on the Maximum Capacity Specification for SQL Server in BOL from CTP 6.

1) Database size: 1,048,516 terabytes?

If you can only have 32,767 files and each data file can only be 16 TB, then wouldn’t this equate to 524,272 TB for database size? Or has the number of files changed? Or has the size of a data file changed. Current BOL for SQL Server 2005 on http://msdn.microsoft.com show 524,272 TB

2) Instances per computer: —–32-bit: 50 instances on a stand-alone server for all SQL Server editions except for Workgroup Edition. Workgroup Edition supports a maximum of 16 instances per computer. —–64-bit: 50 instances on a stand-alone server.

Current BOL for SQL Server 2005 on msdn.microsoft.com show the same. However, I was under the impression that 50 is only available for Enterprise Edition whether 32-bit or 64-bit. What is correct?

Go to http://connect.microsoft.com and add your comments to this feedback. Otherwise, I’ll let you know the results later.

If you have not signed up for Connect, this would be a great time.  I really like how they are enhancing the site.

Update:

Last week I received status back from Microsoft that my observations are correct and the next version of BOL with RC0 will include the changes.

Update 2 Update:

Before I even finish this, I find out there has been an announcement around a new release of BOL for RC0.  see an upcoming Post.

2 thoughts on “UPDATE: Maximum Capacity Specification for SQL Server in BOL from CTP 6”

Leave a Reply

Your email address will not be published. Required fields are marked *


*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>