August 10, 2005 at 9:09 am
Hi Guys,
What kind of Hardware make/model/CPU and memory you gusy uses for your OLTP applications. This is going to be a very mission critical application and perforemance is very important. I needs to get your suggestion about a choosing right Hardware for my application.Do you have any specific make and model in your mind?. Thanks
August 11, 2005 at 1:48 am
Lots of RAM (8GB)
CPUs (watch me get flamed) - AMD Opterons. Point to point bus, not shared like Intel.
That's why Intel have huge L2 and L3 caches to compensate for shared bus contention.
Disks (or on SAN): RAID 1+0, lots of spindles.
And don't put rubbish like antivirus software on your box and make it dedicated to SQL Server
Dell RAID stuff:
http://support.dell.com/support/edocs/storage/romb26/fast-ug/index.htm
General SQL HW:
http://www.webpronews.com/it/database/wpn-20-20041210SQLServerHardwarePerformanceChecklist.html
Cheers
Shawn
August 11, 2005 at 11:24 am
Software
OS - Win2K3 Enterprise - SP1 (Enterprise so you can cluster later is it's that 'mission critical'
SQL 2K Enterprise - So you can take advantage of 'extra' RAM (/3GB or /AWE or /PAE in the boot.ini)
Hardware
HP DL-580 - w/quad Xeon 3.0+ Gh CPU (Xeons & hyperthreading make it look like 8 CPUs)
6-8 Gb RAM
Dual Teamed NICs
SAN disk (RAID whatever, I prefer 5)
1 LUN for database data files (.mdf/.ndf)
1 LUN for database transaction log files (.ldf)
1 LUN for database backups full and transaction (.bak/.trn)
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
August 12, 2005 at 1:00 am
Why RAID 5 over RAID 1+0?
Why Intel over AMD?
August 12, 2005 at 9:04 am
RAID 5 is optimized for read. Also, RAID5 or 1+0 0n a SAN does not make a huge difference unless your SAN is overworked and has insufficient cache.
Intel over AMD because we are an HP/Compaq/IBM shop. Also, I've never been in a shop that is non-Intel unless you count Sun-Solaris.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
August 12, 2005 at 9:14 am
The poster said OLTP so RAID 1+0 and they never mentioned having a SAN.
He did say mission critical and performance is very important.
HP do a AMD based DL585, which are used in my shop along with 2 intel based HP boxes.
For AMD vs Intel CPU with DBMS, see these http://www.anandtech.com/it/
As I posted, watch me get flamed for mentioning AMD...
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply