ࡱ> pro7  bjbjUU 7|7|l 4;&2LLLLLKKK%%%%%%%$m' )%KKKK%/LLe%///K.LL%/K%/J/y> L@ Z.YyF > | &0;& ,*p*> /DB Customer Ticket Analysis Joe Kuefler, 24-June-2004 Nagging Questions What caused the spike in escalated DB tickets several weeks ago: was it a fluke, or was it the beginning of Armageddon? [see graph below] As we continue to push 4.8 and 5.0 customers to upgrade to 5.6.x, are we uncovering Oracle bugs that have been lingering since 5.5? How does DB SWAT activity related to 5.6.x compare to prior releases? What patterns or root causes are revealed in the recent rash of customer DB tickets? The graph below would suggest a momentary bubble in SWAT activity, with a current downward slope (for the month of June, which is completed).  Comparisons to Prior Releases Each new release is typified by a peak in customer tickets. The graphs below suggest that we may not have peaked yet for eHealth 5.6 customer tickets for the DB team. Ingres v. Oracle Consolidation Collapsing 4.x and 5.0 into Ingres and 5.5+ into Oracle, the picture looks about the same. It is not yet clear whether we are at the peak of the Oracle tickets or still on the upward slope.   Patterns/Root Cause Analysis (WIP) PTCreatedBrief DescriptionAssessment36389 xxx36692 36702 36707 36793 36826 37181 37259 37472 37679 37721 38089 38457 38549 38563 38813 38868 38910 38932 39008 39229 39409 39936 40059  :;<=o           & ' ( , 2 3 4 8 > ? @ D J K L P V W X \ b c d h n o p CJaJ5CJOJQJ\^JaJ jUjCJUmHnHu5\U67IYTUVuv9:?@cdg $$Ifa$$ & F$a$$a$ gobW $$IfK$a$$$Ifl\ d(#X 0#64 la$If$If $$Ifa$$If2$K$L$If'64anc0' $$Ifa$2$K$L$If'64a $$IfK$a$$$Ifl\ d(#X 0#64 la_T $$IfK$a$$$Ifl\ d(#X 0#64 la$If $$Ifa$$If $$Ifa$2$K$L$If'64anc0' $$Ifa$2$K$L$If'64a $$IfK$a$$$Ifl\ d(#X 0#64 la_T $$IfK$a$$$Ifl\ d(#X 0#64 la$If $$Ifa$$If $$Ifa$2$K$L$If'64anc0' $$Ifa$2$K$L$If'64a $$IfK$a$$$Ifl\ d(#X 0#64 la_T $$IfK$a$$$Ifl\ d(#X 0#64 la$If $$Ifa$$If $$Ifa$2$K$L$If'64anc0' $$Ifa$2$K$L$If'64a $$IfK$a$$$Ifl\ d(#X 0#64 la_T $$IfK$a$$$Ifl\ d(#X 0#64 la$If $$Ifa$$If $$Ifa$2$K$L$If'64a   nc0' $$Ifa$2$K$L$If'64a $$IfK$a$$$Ifl\ d(#X 0#64 la      _T $$IfK$a$$$Ifl\ d(#X 0#64 la$If $$Ifa$      $If $$Ifa$2$K$L$If'64a     nc0' $$Ifa$2$K$L$If'64a $$IfK$a$$$Ifl\ d(#X 0#64 la    & _T $$IfK$a$$$Ifl\ d(#X 0#64 la$If $$Ifa$& ' ( ) * + $If $$Ifa$2$K$L$If'64a+ , 2 3 4 nc0' $$Ifa$2$K$L$If'64a $$IfK$a$$$Ifl\ d(#X 0#64 la4 5 6 7 8 > _T $$IfK$a$$$Ifl\ d(#X 0#64 la$If $$Ifa$> ? @ A B C $If $$Ifa$2$K$L$If'64aC D J K L nc0' $$Ifa$2$K$L$If'64a $$IfK$a$$$Ifl\ d(#X 0#64 laL M N O P V _T $$IfK$a$$$Ifl\ d(#X 0#64 la$If $$Ifa$V W X Y Z [ $If $$Ifa$2$K$L$If'64a[ \ b c d nc0' $$Ifa$2$K$L$If'64a $$IfK$a$$$Ifl\ d(#X 0#64 lad e f g h n _T $$IfK$a$$$Ifl\ d(#X 0#64 la$If $$Ifa$n o p q r s $If $$Ifa$2$K$L$If'64as t z { | nc0' $$Ifa$2$K$L$If'64a $$IfK$a$$$Ifl\ d(#X 0#64 lap t z { | CJaJ5CJOJQJ\^JaJ| } ~  _T $$IfK$a$$$Ifl\ d(#X 0#64 la$If $$Ifa$ $If $$Ifa$2$K$L$If'64a nc0' $$Ifa$2$K$L$If'64a $$IfK$a$$$Ifl\ d(#X 0#64 la _T $$IfK$a$$$Ifl\ d(#X 0#64 la$If $$Ifa$ $If $$Ifa$2$K$L$If'64a nc0' $$Ifa$2$K$L$If'64a $$IfK$a$$$Ifl\ d(#X 0#64 la _]$$Ifl\ d(#X 0#64 la$If $$Ifa$ 1h/ =!8"8#$%@= M+x$䱆ƀ:2iQ x[ol{ƍIkИB!8R;8jskA Aqq|uBmJQTM+ڊ퇪- /H6H(LjEB }o=n|w>_;3߼͛Yݘ[-l;p/@MK[ R ćn )tQjCg|9Us~nnnL8OnŴWtx0:fff{QίEwu#P/ݏٍͬGu[0U1F`eW mreGeύV~՟ (܎x##l  :>t\pڲ/m7+ޫtw+a' SX?u[!'!gFgpþhc9|.>'Fy}%ό}0rӣ\,t} c*?w۴Rz'so:et~8q.\ǹlw0]Ŋ^QzC2#`?mNL>@H|m9~ym6Zf"%n6Oڍx؝|v_L/dEks[~sWgshgm6䗄O 7)a_ B~I'|Rt9M O 鿷UzψƳa7?ۮ(3bo"OվpαUW:x(}q}KݯV“-j=wzUΧw| jpeve|TY'jRq4=#N=3bψ<8q)-V\JlUtcJgvJ7kvP|\5m*3snѹفs? ~cみ`H;$։ dg\ e. Zyj=>o9/otG~h2fgwc~n1}k0 AF*C8Qϑ+8]I)6J\iM<+\X}|ΤJx K %wDg&|o^.ggV~Ͽg}wepԊe,1!'Ę@l'F.8$Ex Vs 2 rrmXq^;OOzc~=~G#znpcw2O6q9>k\k3¾_™*' ~r=S]vyw2S0|".y'EL!/]DY{r7f{_`W4'P`! |RQ2)]>)61<4]`Z x՛ g{gvf{f Bx;cQ(@ ^9KD >BB!P(^,  ʣP c!xvn+mm{|}\_D5-1;l"A#H'K^{D#_MR< #)ik\F[rB.NW#J3%AF\qp1?I"2b\>$mFn<ٶ@yq9yNnq 5gٲD XjPÓi7y9GLm;F;Sl9){枏5k]|zz:Gs!zdʅ5 pU:iN3YD>г#ƽ QZW<-ۨoz:_".D6?A]mmV;Ƨt3jP6:֊!VTk].h5OAm1U 5[c0AyB *jaGɂV- ZjPYoz<]ՂV^gAyB j)h5OA}w犧='Ԡƺzw<_a2$\:3љ"VTE]1yRjP:1ez!.D6?Aӓl~C 5Fg6#h5OAƮd AyB jW&!6AjPec#9VTkvv<Ug-aO[OZjPFAyB *N7S 5 /h5OAUwM줠<揲/sV}_C8C8VXjPW6-q ZMwH|]_MyB j@b+Ha<MΎ'~%h5ύ{:K<Uۥ : ^R 5|RȚ $X01O10w0 01210Z0j{dDNл'Z&oe {m;GESą5UN},C 5kѬQ-h5OA0ZVԂn:1v"V B7LSh?0yB jb=m!VT;;E݅"V6{/AyB K'Ԡ09RXjP{l[*h5OA-i5"Vw'Y'g3C 5OMmg<{w&HjP_7qjP$Fp-Q-h5OAmOlZjPWVT^*qyB HSRq:>p~{O * q4Bq8a:+ tY>#mR7dyAjp7q>-Pr֚|}Gn"IӝG=~#{4eC_O-IV[|^^J5fPQœNЬ^MPED]ݷIoNwرwk_ODgpgt]V;HZ{d̜Q~BmUӪTiӼG7m6Lۿa=Ωj=X{uDՃ4o_<¾o=[mރG]{P|?ܿX^{3޼['ݩ_Ņ_WG3A%oH^;4?|` K`! Ӯ9l$eΛL/<4]`Z xZ ݙ}*\EDH"#  ܩ!ID|`RGHeD#R"Ds{LE+]]_wci?iӆhioo-#H.yv߾B (&F c:=?B^[ysOi~{69-eboѴ*?gW2zqq~(qS7n^sfZOV1_EUf5_vK'E"QE b &W?~hf?'q-LO7ֆ?zq g3腣J>A206=#ƨe7b/fi`ZOG:L䬳2y>O0VSd[n"{سde[wXM^üM1~'{gTRJ]+eD;=5[<"\B*(?gaT+*dDJ~5XXY.VµZCaj՗\vg q~mʖGƱe2d#3طd,-^Ge#`9;^-lfmly6۔UʃGw<ZlyϲPi{B<ߵIU呱,--xW<)}e#]Nk-u宔-l$)ly~җrCT-Kse#';KX:%Vn@w[gjMV8kG)hr=RW 2RUhYRSJ Uj!/hTJK:Z;ɩL@S)9/hQPE\.JTJKY TN伔G,qcJyC^VyޝɩtKz*xn{6uz5_4>Ofn.ƵWAgvQՀiw0S񝂭 4X?Ol&l5M5wr`i ͏ii3j@llՃVrvتl5MzʮdC[Mh&!l`i V]> 4XeW0`i X[MhsW &`u} 4XzV,|r &`mL>V'7 &`N-cR;dN|-]=~f>i%9Nأm7eT% #{"`/+'Z9L0mӦk٠ѿO&:x.?J_ 4X?? &`HV`i ־Dۙ8M4)ly`i V5yV`i ֟I2Vvd_'j@UA2.l5MJ`_ &`aSx67`+inọWK\6`iޝiJ&ɩK͑kMj@e;`*Iai ֓Cte:Ʉ 4XWgK3: 4X'g?`e ;M꙽k8ܧ"7x,NÞAQ*Aw7Rde ˆVc&Q)gdZ."}/=8BF.?zHF[Mh{g &`gwl5MZ&.l5MfNf&`56V"vu`i `i n{U4V˼| 6kɈs"8G۰oP˨J*"~MFj3 η׿I})ЗW#v1f Ut.j@o[Mh[Msi17sfO˰`i >eaV{< VtՏnl5MiN?l5;s5h;!]&`qg =ȟ4k3tZl5M&[MhNNd 4Xo%G邭 4XKSV1aVtse<&`d͙~쎓qd{b xtK"8'[ Wty24[|Z7}*5*<[{B߯W`<_yV|ۍ>7 w~O!|7@o~7v,Z' gvgؽ!b}-C~;3Κ1}eCTuS s*LzeCsS%s+.jhlԠMM5/5=z[?`_$p/}qӊzN[8*搥0^e_ſ](rFgmՖ*Whos]叮ԺS y~5"GWDbsߓںdJb*qvrv/2~檬g@FE=ժmKu`&Dp#}Kϴj糧F_&եGa^?k>Zp;>}M`X:42`!,aƾaT#<4]`ZxZ}sg̽3c`k*~"lє( P@hv*%).m6[H@EM)j1VcRwZv~3w޼<,o39sν3ݧu0G'/ݿ,I  $Mq*TH6m3QN-ŃB{y!O|4' ]k::_^ِMY{ i 8f(~?O=δxQYbPzMWHןhp[!Vz0LKh/|j:F.bo*1Nvbmu4>HCM^Rܭӻ zA}:z(7VGY8VR|Es=:W±*bAJ쭅oFEuh]`lgh}P,ZuѪkψgյ(ZnrWԪ**SrYOҸGI r{8 Ah9Nxewڎ ]@:Oh7P:k_U;]U=l . o>38Grlo7_5q7]#- jS5{u =Blg{``'ՍuUzFeP-;2\ 'OAt' 1lg~!a.y/0{1蕐@P[9t9Nx5WçjK':}~e' vZgFٌZ. o3exȄ. o6ˠq#l&. oZ58 Av=L]@u _Ƨrr~>lqW~gk=he,:n:Ơq~g9t9Nxu*=r7P/vrd8 TOڼ@7P_.9zqO]ԗ o"$➺s4aOŎ v XXXXuX?X iT' AQ&#V5tg,9KޥϽdsO:Ӆo3!eIc2|e쩆ݯ=˨Y=Occ -6F๼ɷD'B[[l;^ؚK>R$ҧk:5LQ$x@`~A5`^m+::;6ٰtz,[|XxeU?#BGXj/ʯu!' ( k/g{Y#s iϩ`μW`x5՘WY[+V0h_̜Ug M}BWR=,$KU鯄nPH6InHH6>D'BQzJ '.aJ6.]xJ6jl-XWRHc,1WCH6^_əe ƃlY՝ʔlgvAyA.Ӯt%2nl||V-ёVy,wnJ+ݹR#TGK]mS-WzȒgbgiˢ&˂iڒڸ,Z8D..΂>g#lJ,BY8K].C^h8| gYf|y1Y6t%v^,K go2|yI1%v^2,oK6R7X,?e>K؟sI0}y) g5ySgpɋKRҒmgq,;/Yv',2!duV4!/,/'`~~xFiш'v|mI2^>O] kzo@?$eL]Ey$x' ]Jv4Nԗ%tJb*GGo@+QMO&nh Թ_GGo@-זZ;GGo@eq7^ ހzC[8:'x6$ 9:'xch{J{Ki4/C8HIݐNiS4hGo@ȼUfpt4Nޭ;rфΗIkmY3h{ȁ5E8grd9_pk*j  C Q=kJd1¸ad0pF:#G] ObH#߯o@퐏65[Kʕg8:'xꜲh{j?W{Ov4N&}P>C;'x 9:'x ހz)ƹTQ8PyY=L 8P/ƓSoGnrHHj-A8P7'Tz&v4Nԥt y7]8P|J~)Ў ހV|h f16zE! 9ۚjB;.,psjXNL0nPuVX PPPPkP5&" Ya$0"F;ܻ+q5;yp^8*??%_=*F忮lFoFWS$x۰+?u{kG֭^YfC -wۜ?}4;+ۚ_s\FZ2r\Vň0Ҋl{/~EF=ϔ=wĎ 57t'[YQPijEcMT`MtjG2.q ,qb!gt}b}5;+3ݩ#hUjt wunkjiXOqNkI_ m'HE|55/{ i8@8 NormalCJ_HaJmH sH tH R@R Heading 1$<@&5CJ KH OJQJ\^JaJ 0`0 Heading 2$@&CJ02`2 Heading 3$@&6]2`2 Heading 4$@&5\8`8 Heading 5$$@&a$5\<A@< Default Paragraph Font ^ 67IYTUVuv9:?@cdgo &'()*+,2345678>?@ABCDJKLMNOPVWXYZ[\bcdefghnopqrstz{|}~0*00 0 07 0 0 00000 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000p 'g    & + 4 > C L V [ d n s |   !"#$%&()*+,-. t  4"$M+x$䱆 "^2$96A{$7Ut 2$|RQ2)]>) g2$Ӯ9l$eΛL s2$8xU6ŮѤg= 2$,aƾa2$%Q+sCdT @ ~(  6   A <  # A<  # A<   # A<   # AB S  ?:<WD%Jt!04P!`4 (t"8/4 !4&-V\33333\b\dhot{ Joe&Joannie"U:\jkuefler\doc\TicketAnalysis.doc Joe&Joannie"U:\jkuefler\doc\TicketAnalysis.doc Joe&JoanniemC:\Documents and Settings\Joe&Joannie\Application Data\Microsoft\Word\AutoRecovery save of TicketAnalysis.asd Joe&Joannie"U:\jkuefler\doc\TicketAnalysis.doc Joe&Joannie#U:\jkuefler\doc\TicketAnalysis2.doc Joe&Joannie"U:\jkuefler\doc\TicketAnalysis.doc Joe&Joannie"U:\jkuefler\doc\TicketAnalysis.doc Joe&Joannie"U:\jkuefler\doc\TicketAnalysis.doc Joe&Joannie"U:\jkuefler\doc\TicketAnalysis.doc Joe&Joannie"U:\jkuefler\doc\TicketAnalysis.doc|oTnh hh^h`OJQJo(h 88^8`OJQJo(oh ^`OJQJo(h   ^ `OJQJo(h   ^ `OJQJo(oh xx^x`OJQJo(h HH^H`OJQJo(h ^`OJQJo(oh ^`OJQJo(|oT         dgo &'()*+,2345678>?@ABCDJKLMNOPVWXYZ[\bcdefghnopqrstz{|}~@A## @UnknownGz Times New Roman5Symbol3& z Arial?5 z Courier New;Wingdings"qhE†U† !820 2QDB Customer Ticket Analysis Joe&Joannie Joe&JoannieOh+'0 ( D P \hpxDB Customer Ticket AnalysisB C Joe&Joannieoe&oe& Normal.dot Joe&Joannie8e&Microsoft Word 9.0A@q@Y@F:Y՜.+,0 hp|  s  DB Customer Ticket Analysis Title  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHJKLMNOPQRSTUVWXYZ[\]^`abcdefhijklmnqRoot Entry FZ.Ys1TableI*WordDocumentSummaryInformation(_DocumentSummaryInformation8gCompObjjObjectPoolZ.YZ.Y  FMicrosoft Word Document MSWordDocWord.Document.89q