Now I have a new question.
The people of the company where I work, want to buy a new Database Server to replace one older.
They asked me today if it will support SQL 2000 Server (they don't want to improve the version of the SQL because, in a cupple of months, they will adquire SAP,so they don't want to expent more time and money in the changes this would require.)
So they want to buy a Six Core Processor Server, and I'm not sure if this will work with SQL 2000 Server. I red a page here on a FORUM, and I understood that there's impossible to get something like that. So could you confirm this? Or someone could install and use SQL 2000 Server in a six core processor server?
Thanks a lot for your help!Regards :)
asked Oct 06, 2010 at 09:42 PM in Default
it depends on the SQL Server edition and the OS. See [Maximum Capacity Specifications for SQL 2000]: http://msdn.microsoft.com/en-us/library/aa933149%28SQL.80%29.aspx
answered Oct 06, 2010 at 09:49 PM
You can install SQL Server on a system with as many or as few processors as you want, that is not really important. As Squirrel points out, the Edition of SQL Server and Windows plays a role in how many of the processors can be used by SQL Server. At worst you have a 6 core machine and only use one core for SQL Server.
answered Oct 06, 2010 at 10:32 PM
Check the "Maximum Capacity Specifications" for your edition of SQL Server - that'll have its own limitations, when combined with the operating system version. You'll want to check the second table on that page, although note that it doesn't refer to Windows 2003 Server.
There are some issues with installing some editions of SQL Server on servers that have an odd number of cores, or a number of CPUs that's not a power of two.http://support.microsoft.com/default.aspx?scid=kb;EN-US;954835
Is it possible, as this is a transitional need, to simple put a virtual box on the new hardware and host that until you new system is implemented? Just thinking this will be easier to remove after the upgrade as there wont be any conflicts or concerns over unistalling SQL Server, all you have to do is remove the image...
answered Oct 07, 2010 at 01:13 AM