Maximum Capacity supported by SQL Server 2000 Enterprise under Windows Server 2003 Enterprise

Hello

Does anyone know what is the maximum capacity supported by SQL Server 2000 Enterprise Edition running under Windows Server 2003 Enterprise Edition in terms of number of CPU and amount of RAM.?

For CPU : Windows Server 2003 EE supported up to 8 CPU so I assume SQL 2000 Enterprise can also support up to 8 CPU

For memory: Windows Server 2003 EE (32 bits) can support up to 32 GB of RAM so I am wondering whether SQL 2000 EE can also support up to 32 GB ? Under BOL it said it could support up to 8 GB of RAM under Windows 2000 Advance server but it does not mention Windows Server 2003 EE?

Hi Kay. SQL Server support for memory and CPU generally follows the same supported limits for the OS it is running on. Which means for memory, SQL Server supports the use of up to 32gb of RAM on Windows 2003 Enterprise, and up to 64gb of RAM with Windows 2003 Datacenter. For CPU, Windows Server 2003 Enterprise pushes up to at least 16 CPUs I believe, possibly 32 now...perhaps someone else can verify this for sure, but I believe those are the correct numbers.

HTH

|||

Hi Chad.

I found a reference at the Microsoft Web site on Windows Server 2003 comparions. It seems to indicate that Enterprise Edition only supports up to 8-way (for both SP1 and R2) for processor. For memory it can support up to 64 GB in RAM and 1 TB for x64 and Itanium versions.

http://www.microsoft.com/windowsserver2003/evaluation/features/comparefeatures.mspx#Hardware%20Specifications

Thanks for your answer on the questions regarding the memory supported by SQL. I am planning to upgrade our server to max CPU & RAM and I want to make sure that SQL can take the advantage of the additional hardware.

Maximum Capacity Specifications for SQL Server 2000 on Windows 200

Maximum Capacity Specifications for SQL Server 2000 on Windows server 2003.
The information I am finding is information on Windows server 2000. That is
old and outdated information; I need information for SS 2000 editions on 200
3
editions of windows.
Please direct me to an article or table if one exists.
Thank you in advance.
MikeWhat do you want -"maximum capacity' doesn't mean too much?
Maximum database size?
Maximum number of user/connections?
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Mike Mullane" <MikeMullane@.discussions.microsoft.com> wrote in message
news:C05C8D7D-23C0-4834-99D5-5803AD9ACE66@.microsoft.com...
> Maximum Capacity Specifications for SQL Server 2000 on Windows server
> 2003.
> The information I am finding is information on Windows server 2000. That
> is
> old and outdated information; I need information for SS 2000 editions on
> 2003
> editions of windows.
> Please direct me to an article or table if one exists.
> Thank you in advance.
> Mike
>

Maximum Capacity Specifications for SQL Server 2000 on Windows 200

Maximum Capacity Specifications for SQL Server 2000 on Windows server 2003.
The information I am finding is information on Windows server 2000. That is
old and outdated information; I need information for SS 2000 editions on 2003
editions of windows.
Please direct me to an article or table if one exists.
Thank you in advance.
MikeWhat do you want -"maximum capacity' doesn't mean too much?
Maximum database size?
Maximum number of user/connections?
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Mike Mullane" <MikeMullane@.discussions.microsoft.com> wrote in message
news:C05C8D7D-23C0-4834-99D5-5803AD9ACE66@.microsoft.com...
> Maximum Capacity Specifications for SQL Server 2000 on Windows server
> 2003.
> The information I am finding is information on Windows server 2000. That
> is
> old and outdated information; I need information for SS 2000 editions on
> 2003
> editions of windows.
> Please direct me to an article or table if one exists.
> Thank you in advance.
> Mike
>

maximum capacity for SQL 2005

Hello,
Are there published maximum capacity specifications for SQL 2005? I
searched the KB, but could not find anything...
Thanks!
Victoria Yudin
GP MVP
BOL:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/13e95046-0e76-4604-b561-d1a74dd824d7.htm
Web:
http://msdn2.microsoft.com/en-us/library/ms143432.aspx
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Victoria [MVP]" <victoria@.flex-solutions.com> wrote in message
news:%23tRPlum%23FHA.2464@.TK2MSFTNGP15.phx.gbl...
> Hello,
> Are there published maximum capacity specifications for SQL 2005? I
> searched the KB, but could not find anything...
> Thanks!
> --
> Victoria Yudin
> GP MVP
>
>
|||Mike - thanks for the amazingly fast answer!
Have a great day,
Victoria Yudin
GP MVP
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:OUdnjxm%23FHA.740@.TK2MSFTNGP12.phx.gbl...
> BOL:
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/13e95046-0e76-4604-b561-d1a74dd824d7.htm
> Web:
> http://msdn2.microsoft.com/en-us/library/ms143432.aspx
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Victoria [MVP]" <victoria@.flex-solutions.com> wrote in message
> news:%23tRPlum%23FHA.2464@.TK2MSFTNGP15.phx.gbl...
>

maximum capacity for SQL 2005

Hello,
Are there published maximum capacity specifications for SQL 2005? I
searched the KB, but could not find anything...
Thanks!
Victoria Yudin
GP MVPBOL:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/13e95046-0e76-4604-b561-
d1a74dd824d7.htm
Web:
http://msdn2.microsoft.com/en-us/library/ms143432.aspx
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Victoria [MVP]" <victoria@.flex-solutions.com> wrote in message
news:%23tRPlum%23FHA.2464@.TK2MSFTNGP15.phx.gbl...
> Hello,
> Are there published maximum capacity specifications for SQL 2005? I
> searched the KB, but could not find anything...
> Thanks!
> --
> Victoria Yudin
> GP MVP
>
>|||Mike - thanks for the amazingly fast answer!
Have a great day,
Victoria Yudin
GP MVP
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:OUdnjxm%23FHA.740@.TK2MSFTNGP12.phx.gbl...
> BOL:
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/13e95046-0e76-4604-b56
1-d1a74dd824d7.htm
> Web:
> http://msdn2.microsoft.com/en-us/library/ms143432.aspx
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Victoria [MVP]" <victoria@.flex-solutions.com> wrote in message
> news:%23tRPlum%23FHA.2464@.TK2MSFTNGP15.phx.gbl...
>

maximum capacity for SQL 2005

Hello,
Are there published maximum capacity specifications for SQL 2005? I
searched the KB, but could not find anything...
Thanks!
--
Victoria Yudin
GP MVPBOL:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/13e95046-0e76-4604-b561-d1a74dd824d7.htm
Web:
http://msdn2.microsoft.com/en-us/library/ms143432.aspx
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Victoria [MVP]" <victoria@.flex-solutions.com> wrote in message
news:%23tRPlum%23FHA.2464@.TK2MSFTNGP15.phx.gbl...
> Hello,
> Are there published maximum capacity specifications for SQL 2005? I
> searched the KB, but could not find anything...
> Thanks!
> --
> Victoria Yudin
> GP MVP
>
>|||Mike - thanks for the amazingly fast answer!
Have a great day,
--
Victoria Yudin
GP MVP
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:OUdnjxm%23FHA.740@.TK2MSFTNGP12.phx.gbl...
> BOL:
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/13e95046-0e76-4604-b561-d1a74dd824d7.htm
> Web:
> http://msdn2.microsoft.com/en-us/library/ms143432.aspx
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Victoria [MVP]" <victoria@.flex-solutions.com> wrote in message
> news:%23tRPlum%23FHA.2464@.TK2MSFTNGP15.phx.gbl...
>> Hello,
>> Are there published maximum capacity specifications for SQL 2005? I
>> searched the KB, but could not find anything...
>> Thanks!
>> --
>> Victoria Yudin
>> GP MVP
>>
>