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

0 pts.
Tags:
Database
DB2
Desktops
Management
Microsoft Windows
Oracle
OS
Security
Servers
SQL
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 ...
ASKED: January 23, 2006  6:12 PM
UPDATED: January 25, 2006  10:57 AM

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • 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:
    report

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following