Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

My First Sandy Bridge Desktop System

I was standing in line at the Denver Micro Center at 11AM this morning (despite the beginnings of a small blizzard), so I could get my hands on a 32nm Intel “Sandy Bridge” Core i7 2600K processor. It is a good thing I was there early, since they only had five 2600K processors available for sale, and they had a number of disappointed people.  The K suffix means that the multiplier is unlocked, which is the only way to substantially overclock the Sandy Bridge.

I ended up buying all of the parts needed to build a complete desktop system, including all this:

Intel Core i7 2600K processor

ASUS P8P67 Deluxe motherboard

VisionTek Radeon HD6850 1GB video card

(2) Corsair 8GB 1600MHz DDR3 kits (16GB of total RAM)

Crucial 128GB RealSSD C300 SSD

Western Digital 1.0TB Black 6Gbps hard drive

Thermaltake V9 BlacX Edition ATX case

SeaSonic X660 660 watt modular power supply

OEM 22X SATA DVD Recorder

The ASUS motherboard has four 6 Gbps SATA III ports (two Intel and two Marvel) and four USB 3.0 ports. Three of those USB 3.0 ports are on the front of the case. The Thermaltake case has two SATA II docking stations on the top, where you can just plug in a bare SATA drive. This system gets a 7.7 Windows Experience Index (WEI) score, due to the relatively weak video card, while the processor (at stock speed) comes in at 7.8. The memory score is 7.9 and the hard disk score is also 7.9, courtesy of the Crucial RealSSD.

 

clip_image002[5]

 

Here is CPU-Z. I am still messing around with the BIOS settings. BTW, the ASUS motherboard has an EFI BIOS, which has a very nice GUI, and lets you use a mouse to navigate the BIOS setup screens. ASUS bumps the Bus Speed up to 103.0 Mhz by default.

 

clip_image001

 

Geekbench comes in at 12544, which is very impressive. That is about 50% better than a Core i7 950 system, and in the ballpark for a two socket, Xeon X5550 system.  I think the upcoming Sandy Bridge EP processors are going to be wicked fast for SQL Server workloads when they become available later this year.

 

clip_image002

 

Here is how the 128GB Crucial RealSSD C300 SSD does on Crystal DiskMark, plugged into one of the Intel 6 Gbps SATA III ports on the motherboard.  The 256GB Crucial RealSSD C300 was even better write performance than this. There were also several upcoming consumer SSDs announced at CES that will have substantially better performance than this.

 

clip_image001[5]

 

 

Here is how the 1.0TB Western Digital Black 6Gbps drive does on Crystal DiskMark, plugged into one the other Intel 6 Gbps SATA III ports on the motherboard. This is the newer WD Black, with a 64MB cache.

 

clip_image001[7]

 

This single socket desktop system has more CPU horsepower than most four socket database servers. 


Comments

Posted by BrainMan on 16 January 2011

VERY nice. What was the grand total?

Posted by TheSQLGuru on 16 January 2011

I am actually starting to get excited about my next laptop purchase (I do one every 3-4 years since it takes me so long to install/configure/migrate)!!  Ultrafast SSDs, wicked CPUs, USB3.0, gobs of memory - YEAH!!

Leave a Comment

Please register or log in to leave a comment.