I have been doing some benchmarks on a couple of different systems for LIO's. I have been using Kevin Closson's great SLOB toolkit. You can find more information about it on his blog here.
I have been looking at 2 different systems, and here are my results
These 2 systems are both HP.
The first is an AMD 6276 server. 2 socket x 16 cores. (465 G7)
./runit.sh 0 40
The awr is posted.
Here is the summary of throughput.
I have been looking at 2 different systems, and here are my results
These 2 systems are both HP.
The first is an AMD 6276 server. 2 socket x 16 cores. (465 G7)
./runit.sh 0 40
The awr is posted.
Here is the summary of throughput.
oad Profile Per Second Per Transaction Per Load Profile Per Second Per Transaction Per Exec Per Call
~~~~~~~~~~~~ --------------- --------------- ---------- ----------
DB Time(s): 37.9 46.6 0.00 5.96
DB CPU(s): 30.3 37.2 0.00 4.76
Redo size: 15,791.3 19,408.2
Logical reads: 10,119,426.4 12,437,215.0
Block changes: 83.4 102.5
Physical reads: 0.4 0.6
Physical writes: 11.5 14.1
User calls: 6.4 7.8
Parses: 3.0 3.7
Hard parses: 0.1 0.1
W/A MB processed: 0.2 0.2
Logons: 0.1 0.1
Executes: 39,333.0 48,342.0
Rollbacks: 0.0 0.0
I then looked at the new Intel E7 2870 I got. 2 socket 10 core, dual threaded (BL620 E7)
./runit.sh 0 43
the awr is here
Load Profile Per Second Per Transaction Per Load Profile Per Second Per Transaction Per Exec Per Call
~~~~~~~~~~~~ --------------- --------------- ---------- ----------
DB Time(s): 40.9 108.6 0.00 6.93
DB CPU(s): 37.8 100.4 0.00 6.41
Redo size: 10,053.3 26,674.3
Logical reads: 13,203,419.8 35,032,516.8
Block changes: 36.9 97.9
Physical reads: 0.0 0.0
Physical writes: 9.6 25.4
User calls: 5.9 15.7
Parses: 4.0 10.7
Hard parses: 0.0 0.0
W/A MB processed: 0.2 0.6
Logons: 0.3 0.7
Executes: 51,300.2 136,114.4
Rollbacks: 0.0 0.1
Transactions: 0.4
Look at that throughput.. the 43 process count looks to be the best throughput of over 13 Million LIOS/second
WOW the new AMD Bulldozer has great numbers, but the intel really Rocks !
No comments:
Post a Comment