THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | Join | Help
in Search

Joe Chang

Barcelona SAP SD 2-tier

Initial Barcelona performance results are out. The benchmark is SAP 2-tier, which is not surprising. I do not know this benchmark well, but from what I have seen of SAP installations, it is network round-trip intensive. Not that the network bandwidth is high, but SQL Server can only handle so many RPC stored proc calls for single row index seeks/sec. On a 4-way Xeon (NetBurst) 2.7GHz without network tuning (interrupt handling, port affinity alignment), that was something like 27,000/sec. I do not have more recent numbers based on Core 2 architecture. Opteron was very good at this because of the low memory latency (23K for 2 cores?), and TCP/IP packet handling requires this.  

http://www.sap.com/solutions/benchmark/sd.epx

HP ProLiant BL685c G5, 4x2.3GHz QC Opteron 8356                    3,524

HP ProLiant DL385G5, 2x2.3GHz Quad-Core Opteron 2356          2,102

Xeon

HP ProLiant DL580G5, 4x2.93GHz QC Xeon 7340                         3,705

HP ProLiant DL380G5, 2x3.16GHz QC Xeon 5460                         2,436

 

The 4-way QC Opteron is closer to Xeon than the 2-way, in part because the X7340 is 65nm like Opteron, but also because the 4-way Xeon only has 4-wide memory, while the 4x Opteron is 8-wide, two per socket. I think Opteron would have matched Xeon at 2.4-2.6GHz.

I expect the 2-way TPC-C will still favor Xeon by a wider margin. I am not happy with the 4-way Xeon TPC-C of 407K on SQL, Opteron 2.3 should match this. Intel can put out higher clock, but not without blowing the 130W TDP. Several years ago, no tier 1 vendor believed the Intel estimates for power, and always allowed headroom for higher clock, but I do not know if this is still the case. The fan noise is really annoying now. Intel does have Dunnington coming out soon with 6 cores and the big L3, which also helps high call volume apps, but I am concerned the 7300 chipset does not have the memory transaction rate, ie, channels, to realize the full potential of 24 cores.

Well there is now a 4-way TPC-C for quad-core Opteron 2.3GHz of 403K. This is actually very good compared to the 4-way Xeon 7340 2.93GHz result. I do not expect Intel to push the 65nm Core 2 architecture any further, and there is reason to believe AMD should be able to push Barcelona higher at 65nm. My expectation is Intel will base their strategy around the 45nm Dunnington 6-core. I am curious as to whether Intel might push the 45nm X5460 higher, as the dual core variant runs at 3.33GHz, and thats not the top it can do, or would Intel just sit until Nehalem is out.  


Published Monday, March 31, 2008 1:08 AM by jchang
Filed under:

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Linchi Shea said:

Joe;

I think the two numbers for Opteron should the ther other way around. In addition, shouldn't the benchmark results be measured in SAPS instead of the number of users you seem to be quoting?

May 24, 2008 11:50 PM
 

jchang said:

you are right, I switched it. I did not quote units

July 7, 2008 4:39 PM

Leave a Comment

(required) 
(optional)
(required) 
Submit

About jchang

Database architecture, SQL Server engine, Performance modeling and prediction, Reverse engineering the SQL Server 2000, 2005 and 2008 Cost Based Optimizer, Microprocessors, Storage performance, NUMA system performance characteristics, mucking with the data distribution statistics histogram
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement