AMD vs. Intel: Data Warehouse Servers and Consolidated Database Servers …

Microsoft Windows
SQL Server
Hello everyone, Hope all is well ... Any help, opinions, direction to whitepapers, benchmarch reports, overkill/underkill comments, and the like would be greatly appreciated: We are in the process of spec'ing out hardware needs for our targeted new data warehouse and new consolidated database servers. We would like any comparative views regarding AMD vs. Intel processors -- particular for the HP DL series servers (585 vs. 580). Data Warehouse Basic Profile: * Custom developed solution * No industry leading DWH platform * Heavy workload, processing, DTS, multiple joins, aggregated calculations, history, versioning, etc. * Sizing requirements 1-2TB * SQL 2000 ENT (32-bit) for ODS * Windows 2003 ENT (32-bit) * 8-16GB RAM * SCSI & FC HD with SAN * 2-4 CPUs * 400 - 700 Users Consolidated Database Server Basic Profile * Multiple Database Files (50+) * Sizing Requirements: 400+ GB * Write-intensive * No applications installed (just DB files) * 4-8 GB RAM * SQL 2000 ENT (32-bit) * Windows 2003 ENT (32-bit) * SCSI & FC HD with SAN * Limited DTS, interfacing * 300 - 400 Users (sporatic) * 2 - 4 CPUs We are standardized on HP, but will entertain other vendors based on industry benchmarked compartive analysis -- if known, please provide link to related sites. Thanks in advance ...

Answer Wiki

Thanks. We'll let you know when a new response is added.

We manage several DBs of the size you are discussing. Although the intel based platforms are OK, for the size and performance you are mentioning for the DW, we run all of ours on Sun systems. We use V880s for this application. A V400 series might do the trick with only 200 to 400 users. The partitioned V880 we use handles both the DW and an OLTP system for about 500 concurrent users.

Discuss This Question: 1  Reply

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • DaveInAZ
    I haven't seen any convincing comparison of the two specific processors you mentioned. What I have seen is a lot of articles saying AMD has lost it's performance edge over Intel, and that they're now pretty much a toss-up.
    0 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.


Share this item with your network: