Euan Garden - Tour of SQL Server team (Part IV) | TheChannel9Team

TimMacrina.com

AWESOME!

EuanG

Here is a link to Jamie's site:

http://www.sqlserverdatamining.com/DMCommunity/

TimP

What's the estimated cost for the whole machine (Superdome + hard drives)?

EuanG

When we did the TPC benchmark with this machine it was $5.1 mill, you can get the disclosure doc here:

http://tpc.org/tpcc/results/tpcc_result_detail.asp?id=103082701

However this was 18 months ago, prices have come down for most stuff, but the box now handles 1TB of memory instead of 1/2 TB of memory. The procs are now 2GHz instead of 1.5Ghz but you get the idea

TimP

Thanks for the link! There's a lot of great info in the full disclosure report.

byron
strike1

The Channel 9 Team wrote:
Soner Terek takes us behind an HP SuperDome computer. A terabyte of RAM. 2,500 hard drives. 64 64-bit processors.

Then Jamie Maclannan talks about data mining and gives us a demo.

This is the fourth, and final, part of the SQL Server team tour. Here's the other three parts:

Part I
Part II
Part III

Video length: 00:15:31.

I lOve gigabits, lots of storage and terrabytes!

byron
strike1

TimP wrote:

What's the estimated cost for the whole machine (Superdome + hard drives)?

It costs, but its needed!

rasx
Programmer/Analyst III, Emperor of String.Empty

I get it: data mining is better distinguished from OLAP where I'm standing. AI... AI...

pdrg
Who Was Prouder?

with a 2500 disk array, how often do you have to swap drives out? I heard archive.org have aprox 6%pa disk failure and wondered if you'd found that consistent?

thx Smiley