Throughput-Delay Plots Benchmarking Paradox
Fusion-io Benchmark
!"#$%'()'*+,*%&-.'(&-/(.&)&.$#0(*'12$*'%'-#"(+,*(3456(5'&*.7(5'*8'*(9:;:(+,*(57&*'<,$-#( (
@$#7($/A'(.,-#'-#(.*&BA"(C",A$/(A$-'"DE(F?(&.7$'8'"(&*,2-/(9G(1)"E(H'+,*'(/'=*&/$-=(#,(&*,2-/(9:(
I<5(2-/'*(,8'*A,&/(.,-/$#$,-"E(B$#7(JK(H'.,%$-=(#7'(H,##A'-'.LM(F;:($"(&HA'(#,(/'A$8'*(G:(I<5E(
(B7$.7(),$-#($#(H'.,%'"(A$%$#'/(H0(#7'(#7*,2=7)2#(N$-.*'&"'/(#7$"(H'-'+$#('8'-(%,*'(#7&-(#7'(%'&"2*'/(G:P(=&$-M(
Q2*$-=(.,-#'-#(.*&BA$-=M(F?(7&"(-,("$=-$+$.&-#(.7&-='"($-(12'*0()'*+,*%&-.'(.,%)&*'/(#,($/A'M(
J#($"(&.7$'8$-=(.*&BA(&-/(12'*0(A,&/("')&*$,-(H0(2"$-=(&-(&//$#$,-&A("'#(,+("'*8'*"($-(&(
/'/$.'/("'&*.7(*,BM(F;:(='#"(",%'(/'=*&/$,-E(&"(.,-#'-#()*,.'""$-=(&-/(12'*$'"(.,%)'#'(
+,*(#7'("&%'(N.,-/$#$,-"M(4A",(-,#'(#7&-(#7'(.,-#'-#(.*&BA$-=(*'(,-(F;:($"(9:P(7$=7'*(#7&-(,-(F?(/2*$-=(
#7$"(#'"#E(&"(#7'($-.*'&"'/(JK()'*+,*%&-.'(&AA,B"(+,*(H'##'*(7&-/A$-=(,+(#7'(.,-.2**'-#(
,)'*$,-"M(
"#$%!&$'()!
R(
*+,)-!,#$%!&$'()!
67'(#&HA'(H'A,B("7,B"(#7'(.,%H$-'/($-.*'&"'($-(/$"L(2"&='(,-(&AA(-,/'"(&+#'*(#7'(8&*$,2"(
.,-#'-#(",2*.'"(7&8'(H''-($-/'S'/M(
Actual data (with and without FIO)
5 10 15 20 25 30
X
0.0
0.5
1.0
1.5
R
Extracted data
SQL Server RDBMS: Measure X in QPS and R in s at each load (N)
Two curves: before (red) and after (blue) application of FIO device
Manually extracted pertinent data points
c 2012 Performance Dynamics Little’s Law in 3D and Storage Performance August 7, 2012 15 / 34