&#(B7$.7(),$-#($#(H'.,%'"(A$%$#'/(H0(#7'(#7*,2=7)2#(N<OM(O"$-=(+&"#'*(,*(%,*'(N<O"(B,2A/(7&8'( $-.*'&"'/(#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<O(*'",2*.'"M(5#$AAE(F;:(&.7$'8'"(#7'("&%'(9:(I<5(&"(F?(2-/'*(#7'(7$=7'"#(A,&/( .,-/$#$,-"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