Sql 2000 and Six Core Processor


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 :)
more ▼

asked Oct 06, 2010 at 09:42 PM in Default

Maripili gravatar image

394 32 33 35

(comments are locked)
10|1200 characters needed characters left

4 answers: sort voted first

it depends on the SQL Server edition and the OS. See [Maximum Capacity Specifications for SQL 2000][1]

[1]: http://msdn.microsoft.com/en-us/library/aa933149%28SQL.80%29.aspx
more ▼

answered Oct 06, 2010 at 09:49 PM

Squirrel gravatar image

2.5k 1 2 4

(comments are locked)
10|1200 characters needed characters left
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.
more ▼

answered Oct 06, 2010 at 10:32 PM

WilliamD gravatar image

25.9k 17 19 41

(comments are locked)
10|1200 characters needed characters left

"It depends".

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.

Google throws up some links, including a couple of Microsoft blogs & [KB articles][4]

[4]: http://support.microsoft.com/default.aspx?scid=kb;EN-US;954835
more ▼

answered Oct 07, 2010 at 12:03 AM

ThomasRushton gravatar image

ThomasRushton ♦
34.2k 18 20 44

(comments are locked)
10|1200 characters needed characters left
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...
more ▼

answered Oct 07, 2010 at 01:13 AM

Fatherjack gravatar image

Fatherjack ♦♦
42.8k 75 79 108

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Oct 06, 2010 at 09:42 PM

Seen: 1633 times

Last Updated: Oct 06, 2010 at 09:42 PM