Sparc M7 vs Intel and P8


08.02.2016
by Kamil Stawiarski

I had a pleasure to work with my colleagues from Oracle – Radosław Kut and Krzysztof Marciniak – at comparing the performance of In-Memory queries between Sparc M7, Intel® Xeon® X5670 and Intel® Xeon® E5-2699.

You can find results of our findings in this presentation: https://www.oracle.com/webfolder/s/delivery_production/docs/FY16h1/doc17/DB12c-on-SPARC-M7.pdf

Following their methodology I’d like to present appropriate results from P8 tests.
(Please get familiar with the presentation first)

This chart represents response times and throughput for first tests:
p8_10_100_before

Well, it looks a little bit messy and unstable, but things got better after setting this parameter:

export LDR_CNTRL=DATAPSIZE=64K@TEXTPSIZE=64K@STACKPSIZE=64K oracle

(Many thanks to Radoslaw Mankowski from IBM for this hint)

p8_100

The last step which you can see on this chart is for 100 users.

Make your own conclusions 😉

P.S.
Special thanks to Adam Boliński for helping to setup the AIX environment and Sławomir Wolak for making P8 tests possible.


Contact us

Database Whisperers sp. z o. o. sp. k.
al. Jerozolimskie 200, 3rd floor, room 342
02-486 Warszawa
NIP: 5272744987
REGON:362524978
+48 508 943 051
+48 661 966 009
info@ora-600.pl

Newsletter Sign up to be updated