AMD vs. Intel Processors

Question

AMD vs. Intel Processors

Terry B-214928

Say Hey Kid

Points: 696
More actions
September 2, 2009 at 7:43 am

#135297

Hi,
We are currently running SQL 2005 Ent. on a HP server with AMD Opteron processors. I am going to order a new server today and am looking at a server with Intel processors.
Is there any reason I should not move from AMD to Intel?
Regards,
Terry
A great day starts with a great attitude

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

GSquared SSC Guru Points: 260824 More actions · Answer 1

They're both good.

There was a long period of time where AMD was ahead of Intel on performance vs price, but not so much any more. Now they're so close it takes sophisticated tests to tell the difference.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Steve Jones - SSC Editor SSC Guru Points: 736254 More actions · Answer 2

I'd agree that right now I don't see much difference. I have SS2K8 Dev on both here, can't really tell the difference.

Silverfox SSC-Insane Points: 23150 More actions · Answer 3

Normally Intel processers are more expensive, if you have web farms and if you want to virtualise at any time, you might be better off sticking with one type of processor and not mixing and matching, as there have been reported performance and high availability issues with mixing processor types.

--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

Terry B-214928 Say Hey Kid Points: 696 More actions · Answer 4

Good point since I intend to use the current server as our backup server (either log shipping or replication).

Thanks

A great day starts with a great attitude

GSquared SSC Guru Points: 260824 More actions · Answer 5

That should work fine for log shipping. Just not for clustered virtualization.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Silverfox SSC-Insane Points: 23150 More actions · Answer 6

yep sounds good. let us know what you end up doing 😀

--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

Terry B-214928 Say Hey Kid Points: 696 More actions · Answer 7

Ordering the following before I go home today

* HP DL585, Quad Opteron quad core processors (16 total)

* 32-GB RAM

* 72-GB 15K 6-gb transfer rate for OS

* SAN connectivity via redundant 4Gb fiber channel HBA's

Now I just need to find out if the accounting system we use will run on 64-bit OS and SQL.

Thanks everyone for the feedback!

Terry

A great day starts with a great attitude

rajdba Ten Centuries Points: 1362 More actions · Answer 8

Terry B

I had a BioTech client, they had purchased AMD and the some value was mismatching from Intel to AMD, check that if not that the case with you for some scientific calculations.

Thanks

Raj

Silverfox SSC-Insane Points: 23150 More actions · Answer 9

Terry B (9/2/2009)
Ordering the following before I go home today
* HP DL585, Quad Opteron quad core processors (16 total)
* 32-GB RAM
* 72-GB 15K 6-gb transfer rate for OS
* SAN connectivity via redundant 4Gb fiber channel HBA's
Now I just need to find out if the accounting system we use will run on 64-bit OS and SQL.
Thanks everyone for the feedback!
Terry

Sounds like nice bit of kit, good luck

--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]