August 7, 2008 at 6:22 pm
Hi,
My understanding is that we only have X86 and IA64 editions, but no X64 edition for SQL 2000 Server. So for Windows 2003 X64 we can only use X86 edition. Is this correct?
Thanks.
August 7, 2008 at 9:50 pm
SQL2000 has 64-bit. http://msdn.microsoft.com/en-us/library/bb469739.aspx
"This release of Microsoft® SQL Server™ 2000 (64-bit) includes the SQL Server 2000 (64-bit) Enterprise Edition. To run this release of SQL Server 2000 (64-bit), you must use the 64-bit Microsoft Windows® operating system: the 64-bit versions of the Windows® Server 2003 family."
August 8, 2008 at 1:03 am
Vivien Xing (8/7/2008)
SQL2000 has 64-bit. http://msdn.microsoft.com/en-us/library/bb469739.aspx"This release of Microsoft® SQL Server™ 2000 (64-bit) includes the SQL Server 2000 (64-bit) Enterprise Edition. To run this release of SQL Server 2000 (64-bit), you must use the 64-bit Microsoft Windows® operating system: the 64-bit versions of the Windows® Server 2003 family."
Yes, it does, but according to the link, this is IA64 not X64:
Hardware and Software Requirements (64-bit)
This topic applies only to SQL Server 2000 (64-bit).
...
Hardware Minimum requirements
Computer Intel® Itanium™ and Itanium II processors with 64-bit CPU
So apparently SQL Server 2000 has only: x32 and IA64
SQL Server 2005 has all three: x32, x64 and IA64
August 8, 2008 at 7:11 am
http://www.microsoft.com/sql/editions/64bit/SQL64bitAdvantages.mspx has a few more details as well.
It would appear that it would be a better idea to start moving towards 64bit on x64.
We are currently running 32bit SQL on x64 and I'm trying to move that direction as well. We can definitely make better use of our 16GB of ram that way.
MCITP, Database Administrator
A hodgepodge of Information Technology and Life
LinkedIn Profile
My Twitter
August 11, 2008 at 12:33 am
Jason Crider (8/8/2008)
http://www.microsoft.com/sql/editions/64bit/SQL64bitAdvantages.mspx has a few more details as well.It would appear that it would be a better idea to start moving towards 64bit on x64.
We are currently running 32bit SQL on x64 and I'm trying to move that direction as well. We can definitely make better use of our 16GB of ram that way.
Yes, but once again, there is no support for x64 on SQL Server 2000, only for IA64. For x64 you would have to upgrade to SQL Server 2005 or 2008, which got released last week.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply