Home > Intel Communities > Open Port IT Community > The Server Room > Blog > Tags > database

The Server Room Blog

4 Posts tagged with the database tag
0

Nehalem-EX has been in the news quite a bit over the past several months. 

First, in May, Intel described how Nehalem-EX will be at the heart of the next generation of intelligent and expandable high-end Intel server platforms, delivering a number of new technical advancements (Intel Nehalem Architecture, Quick Path Interconnects, 16 threads, 24MB cache, new RAS features like MCA-Recovery, 16 DIMM slots per socket, 128 threads on 8 Socket systems) and boost enterprise computing performance (the greatest gain in generational performance ever seen at Intel.)

Next at IDF in September Intel described how Nehalem-EX would deliver a bigger generational performance improvement than that delivered by the Intel Xeon 5500 processor (including a 3X Nehalem-EX gain in database performance); a large shift in Xeon scalability with over 15 >8S systems anticipated and expandability for the most data demanding enterprise applications, the addition of about 20 RAS capabilities traditionally found in the Intel® Itanium processor family – along with a demonstration of MCA-Recovery. IBM announced their upcoming BladeCenter products that will support 4S Nehalem-EX blades and Super-Micro announced a 1U box, specifically targeted at HPC.  Staying on the HPC theme, Mark Seager from the Lawrence Livermore National Laboratory was also quoted with stating that “Nehalem-EX allows us to invest in science, not the computer science of porting and adapting software to new architectures, but real science.  Nehalem EX is an innovative SMP on a chip solution that provides us access to a “super node” … The result is an astonishing new level of performance.”

And Oracle Open World on October 13th, the drumbeat for Nehalem-EX continued.  Michael Dell in his Oracle Open World Keynote today discussed how Nehalem-EX will provide a true leap in performance, with up to 9x the memory bandwidth and 3x the database performance vs. prior generation.  And he mentioned that Dell’s unique implementation of the memory architecture will allow the most cost effective scaling, with 4S systems up to 1TB of DRAM (64 Dimms x 16GB Memory sticks) enabling customers to run their entire database in system memory.  He also mentioned that standard based systems are driving new efficiencies with applications like Oracle, where Dell’s data shows Oracle apps run better on x86 vs. proprietary architectures, up to 200% better.  Check out this short video from the keynote and watch what Michael Dell had to say. 

Keep your eyes on the Server Room for more Nehalem-EX news as it comes between now and launch.  And visit the Intel booth at South Moscone Booth #1621 to learn more.

Bryce

0 Comments Permalink
2

I wrote a few weeks ago about the end of the mini generation.  This time I thought I would dig out some data to support my case.  My personal anecdotal evidence is what I am hearing from my customers.  They are looking at replacing hundreds of legacy Unix servers with new high performance Xeon boxes.  I am not talking about a one-for-one replacement, but using virtualization to replace 5 to 25 of these older unix boxes with each Xeon 5500 server.  The economic incentives here are pretty staggering.

 

Why now?

 

I see multiple reasons

1)  Ecosystem maturity.  Enterprise class tools for virtualization, Linux, high availability from VMware, KVM, Xen, RedHat, Suse and others

2)  Performance.  The performance of 200-2005 vintage sparc and ultra-sparc boxes is easily replaced by Xeon – saving power, space, and potentially licensing.

3)  Applications readiness.  Applications like Oracle are now “made for linux” and do great on X-86 platforms

4)  Staff.  You have the expertise in Linux on Xeon, this is a growing area, capitalize on it.

5)  Economics.  There is real savings to be had in licensing, power, space, staff, sanity( sanity savings is subjective).

 

 

I hopped out to tpc.org to look at some benchmarks.  Benchmarks are notoriously awful as measures of actual performance, but they do work – mostly – as a comparison of relative performance.

 

There isn’t a lot of Sparc data, and much of it is old, but if you are looking at replacing some aging 4+ year old Unix hardware, that may be just what you need.  (with respects to Bryce’s cash for clunkers blog).

 

For TPC-C the most recent Sparc result I found was from 2003. Running Oracle Database 10g EE on Sun Solaris 8 on 64 single cores of Fujitsu SPARC64 - 1.3 GHz processors, they delivered 595702 tpmC at $12.43/tpmC (tpc.org)

 

So if “this old machine" is setting in your landscape, gulping power and support costs, you could replace it today by running Oracle Database 11g SE1 on Oracle Linux 2 quad core Intel Xeon Processors X5570 2.93GHz  delivering 631766 tpmC at $1.08/tpmC (tpc.org)

 

The ROI on this must be about 10 minutes! Ok maybe that is a bit quick, but this is a data base! Export, Import, ta-da!  What are you going to do with all that extra rack space and power?

 

Replace a 64 socket platform with a 2 socket platform.  Amazing.  this could be 1U, or even a blade.  You could put it under your desk.  There have got to be some examples of older sparc and power boxes sitting in the landscape. Let me know what you have.

 

-Ken

 

 

2 Comments Permalink
2

A MONSTER CHIP IS COMING. The next generation of MP processor is targeted for production later this year, and by all accounts it is going to be a monster. Nehalem-EX is part of the Nehalem family of processors, but compared to its siblings it has the highest cores/threads count, largest shared cache, highest CPU-to-CPU bandwidth, highest I/O bandwidth, highest memory capacity, highest memory bandwidth, greatest scalability, and highest level of Reliability/Availability/Serviceability. It’s expected to bring a gargantuan, unprecedented leap in capabilities and performance--the biggest leap in all of Xeon product history.

 

IT’S TARGETED AT “BIG BOXES”. Big box servers are multiprocessor systems using the most capable processors and platform components. These systems are targeted at applications and usages that require the largest memory footprints, the highest amounts of single-box processing power (for workloads that don’t decompose well into lots of independent threads) and/or advanced levels of RAS. Such systems are typically the best choice for large databases, ERP apps, Business Intelligence apps, large-scale server consolidation and business-critical virtualization, mission critical applications and large scale high performance computing.

 

IT USES THE SAME PROCESSING TECHNOLOGY AS THE SUCCESSFUL XEON 5500, BUT MORE OF IT. Just like with Xeon 5500, the Nehalem micro-architecture brings improved single-threaded performance via IPC (Instructions per Clock) enhancements and Intel’s Hi-k 45nm manufacturing process. Greater multi-threaded performance comes via Hyper-Threading and more cores. But while the Xeon 5500 has up to 4 cores/16threads per socket, the Nehalem-EX monster doubles that to 8 cores/16 threads.

 

HAS A BEEFIER MEMORY AND INTERCHIP COMMUNICATION SUBSYSTEMS. Monster thread processing capabilities require monster size feeding to bring out the best performance. Nehalem-EX’s raw processing potential is made viable by a heavy duty memory subsystem and inter-chip communication system.

Nehalem-EX has 24MB of shared level 3 cache--that’s 50% more than the current Xeon 7400 and 200% more than Xeon 5500. The memory channel bandwidth was increased to 9-times that of Xeon 7400. And it’s all attached to up to 16 DIMM slots per socket (that’s 64DIMMs slots for 4 sockets)—double the current generation of Xeon 7400.

In a multi-socket system, processors need to communicate with each other in order to most efficiently coordinate their shared workload. They also need lots of I/O bandwidth. Nehalem-EX has four QuickPath Interconnects on every socket--double that of Xeon 5500. The four QPI links enable Nehalem-EX processors to be directly connected to each other in a 4 socket system. This offers significant performance advantage over a so-called ring architecture wherein some processor-to-processor communication must go through an intermediary processor. The extra QPIs also mean that there’s plenty of CPU to I/O bandwidth.

 

EXPECTED TO BRING THE GREATEST LEAP FORWARD IN XEON PERFORMANCE EVER. On key server performance benchmarks (e.g. SPEC_int_rate, SPEC_floating point_rate, TPC-C, etc) Xeon 5500 using Nehalem technology brought gains of over 100-200% greater than prior generation. Generational gains of this magnitude come along just about once a decade. Nehalem-EX’s generation-to-generation performance gains are expected to be substantially higher than those of Xeon 5500. We’ve already seen measured memory bandwidth of 9X vs. prior generation. That’s an early indication of the level by which new performance records will be set when this monster chip comes to market.

Related Topics:

NHM-EX Press Fact Sheet

NHM-EX May 26th Press Briefing Video – condensed version

IBM 8Socket Demo Video

 

NHM-EX--A New Standard

2 Comments Permalink
1

Big Servers are Back!

Posted by Bryce Olson May 28, 2008

One trend that is really starting to take shape in the server industry is that big servers are back! That doesn't mean big servers ever disappeared off the map. Historically bigger servers with 4 or more processor sockets have been 7-8% of the server market from a volume perspective. And bigger servers have always been used for scalable, data-demanding enterprise applications which IT values for it's performance, headroom and reliability. What we're seeing now is a greater shift in popularity towards these servers as IT invests more and more in this direction.

 

So, why is that? Well, check out this video and then let me know if you agree or disagree. After you watch it I'd also be curious to learn more about what you value as the most important buying criteria when you go big.

 

 

1 Comments Permalink

Filter Blog

By author: By date: By tag: