MZ@ !L!This program cannot be run in DOS mode. $PEL+I Pΰ @  +|O0`   H.textԐ  `.rsrc0@@@.reloc @BHܣ$  P Jde =5$i#vԻkm!Ђ5UOݪQKt/g"MpluRw¼u0{fz̸)Yjۍb*jsyVsFd E"x5xP"}*{*}rp{!( }*{*{*:( }*0 {-~ {o rp +!~ {rCp( o rMp ,^o t"}rgpo % o {~ ( o -%{~ '( }&(*{ *{ *{ *{ *f,} } } *zrp} rp} (*0Zrp} rp} (} { rp( - ( } *( rp( } *0@~ {rp( o ,!rpo t" ,( o * **{*&(* 0@s }{( o {o }  &} { * $/ n{ ,{o } *rp*{*&~*"(*"(*"(*Z( }P}*^rpo( (***0   o +|o Xo /Xo b`bXcXa 1OXo Xo /Xo b`bXcXa Y Xo ?w eX]ZX * @ @b*%9( *r#p*j({t}*0T({o,}{o}*}%{`}%{ `}*n{,}{o*0{-*('(({ r-po ( (%{`}%{`}E o (o! (rp(%{`}%{`}o*( 6/ ME0 0  {o" r3po# o$ (% -((  {xo{o" rOpo# o$ (% -,rap( ((& (' {yo{o" rpo# o$ (% -)(rp(( ,+ {|o{o" rpo# o$ (% -)(rp(( ,+ {|o{o" rpo# o$ (% -)(rp(( ,+ {}o{o" r[po# o$ (% -)(rp(( ,+ {}o{o" rpo# o$ (% -(& () rpr p6(* (#Y@0+#Y@#0A[Xm { o{o" rpo# o$ (% -(& () rKpr p6(* (#Y@0+#Y@#0A[Xm { o{o" r}po# o$ (% -|(& ()   rp  r p 6 (* (#Y@0+#Y@#0A[Xm {o{o" rpo# o$ (% -0((& (+ (, ({~o{o" r%po# o$ (% -,(rp(( ,+ { o{o- o. { o{o/ o0  += o1 t;o2 =(3 3X +?(3 3 X  o4 - u@  , o5 { o{ o*|J0{o6 o. { o{o6 o0 8-o1 to7 j[m o8 o9 o: o. o; o. o< o.     o< o0 +oo1 tGo= 3Xo> o9 E" +& X + X + X + X +Xo4 -u@,o5  o? o0 +Ao1 t;o2 =(3 3X+?(3 3 X o4 -u@,o5 ()X(*X(+X5+{ *  o{ *    oo4 :u@,o5 *AL|)RN4@t0   o@ o. o@ o0  8x o1 tJ  oA o. X  oB 3X  oC , X  oD oE ,X oF o. X oF o0 +,o1 tN  oG o. X  oH -Xo4 -u@,o5  oI o. X oI o0 +{o1 tQ  oJ o. X  oK o0 +.o1 tS  oL o. X  oM ,X+ o4 -u@,o5 o4 :yu@,o5  o4 :| u@,o5 { * o*Ad98;s .0        oN o. oN o0 +8+o1 tVoO o. X oP o. X oP o0 ,+,o1 tXoQ o. X ,o4 -,u@--,-o5 oR o0 .+".o1 tZ  oS oA o. X .o4 -.u@//,/o5 oT o. X oT o0 0+0o1 t\!!oU o. X 0o4 -0u@11,1o5 oV o. XoV o0 2+A2o1 t^""o2 ##_(3 3X+#`(3 3X2o4 -2u@33,3o5 oW o. XoW o0 484o1 tb$$oX oY 5+>5o1 te%-%oZ o d1%oZ r[po[ , X 5o4 -5u@66,6o5 ,X4o4 :k4u@77,7o5  o\ o. X o\ o0 88_8o1 tg&&o] o. X  &o^ o. X &o^ o0 989o1 ti''o_ oA o. X 'o2 ((j(3 3 X +@(k(3 3 X +*(l(3 3X+(m(3 3X9o4 :s9u@::,:o5 &o` o. X&o` o0 ;+e;o1 to))oa o. X )ob <RxMfK0o % 9~<-mss %r.p(t %r#.p(t %r1.p(t %r=.p(t %rG.p(t %rQ.p(t %re.p(t %r.p(t <~<(u ,0E+ + + *0D  s        s r.po &r.po &r.po &r.po &r.po &r_/po &r/po &r/po &rO0po &r0po &r0po &r1po &r:1po &o {s s o &o o 8o1 to t"  o  (E;,+o %o &o %  5+ o  o -+o t"(% - o (% -+ o  o  o  o { o (J(L(I(H(K(M(N--, (O<oz 3o (o! (%{@`}{#*    oo4 :u@,o5 *A4)t<.0  s     s   r.po & r.po & r/po & r1po & ri2po & r2po & rL3po & r3po & r:1po & o {sx o{ 8o| (% - o o & (E;o| (% - o (% -+o o| (% - o (% -+o  o~  o~  { *           oo :o *0r\4pr4p( {sx p(A%r>p(A&r>pr>p( (A%{** o*0t r-?prs?p( {sx o{ +;o| (  o~ {-* oo -o *%Gl0    ,Br?pr?p( (A% oz .(R(S9"r?pr!@pr@p( (A% oz ."  r@p  r0Ap  r@p ( (A% oz .(P(Q,2r@pr Bp( (A% oz .5 55 60{?*        o*4 *UBB30  s rYBpo &rBpo &rZCpo &rCpo &rDDpo &rDpo &r Epo &rEpo &rJFpo &rFpo &rlGpo &r Hpo &rHpo &r'Ipo &rIpo &rJpo &rJpo &rJpo &r4Kpo &rKpo &r$Lpr0Lp( o &o {sx o{ 8f +o~ 3 _b`X 1 +!o -+ 3 _b`X 1 +o~ 1 _b`X 1o o o o o o  o~  o~   o~  !o~  "o~ #o~ {@* o{A*    oo :o *AEx0! s rfLpo &rLpo &rVMpo &rMpo &raNpo &rNpo &rROpo &rOpo &rGPpo &rPpo &r(Qpo &rnQpo &rQpo &r{Rpo &rRpo &r$Lpr#Sp( o &o {sx o{ 8| +o~ 3 _b`X 1 +!o -+ 3 _b`X  1 +o~ 1 _b`X 1o o o o o o~  o~  o~  o~  o~  o~ o n_m dm{B*o{C*     oo :yo *A0 " s   rQSpo & rZCpo & rCpo & rDDpo & rDpo & rSpo & r6Tpo & rTpo & rMUpo & rUpo & rUpo & rEVpo & rVpo & rJpo & r Wpo & r$Lpr~Wp( o & o {sx o{ 8 +o~ 3 _b`X 1 +!o -+ 3 _b`X 1o o o o~ o~  o~  o~  o~  {D *    oo : o *0}# s   rWpo & r Xpo & rXpo & rYpo & rvYpo & rYpo & rNZpo & rZpo & rRpo & r$LprZp( o & o {sx o{ 8 +o~ 3 _b`X 1o -+ 3@`o o  o  o   n_m  dm {E*         oo :Ho *u0]rZp{sx o{ +1o o~ {"* oo -o *=U0$     s r.po &r{[po &r[po &r[po &r[po &o {sx o{ +Co~ o o { * oo -o *rO0%##### # # r\p{sx o{ 8o| o o %9~=:ss %ra]p(t %r}]p(t %r]p(t %r]p(t %r]p(t %r]p(t %r]p(t %r^p(t %r/^p(t %rA^p (t %r]^p (t %r{^p (t %r^p (t %r^p (t %r^p(t =~=(u 9E"/<MT^ov8 ( #@ ( 8 ( 8#@Zm+m+x ( +n#@Zm+]m+V (  +L#@Zm+;m+4#@@Zm+##@@Zm+ (  + (  o :o #3*[#חAZm [#חAZm [#חAZm [#חAZm [#חAZm [#חAZm{0 o{1 o{2o{3o{4o{5o{6o{7o{8o{9o{:o{;o{<o{=o*A},0?& r_p(A%  oz .0+ {>o*06' r_p(A%  oz .{Fo*0.( r&`p(A% {Go(Z([*0j)r`p{sx o{ o &o~ o ds ( ( {H o{Ioo *Jb0]rdp{sx o{ +1o~ o~ {J* oo -o *=U(]*0f*rdp{sx o{ +:o| o~ (  {K* oo -o *F^0K+(` s +  sn of o Xi2o } *0:,s {  +  (a o X i2o *0?-~ rmfpo  o i"  +' , (( - o t" X i2o s s ~ rfpo o  8    o ,z r1gp( o   r?gpo   -Q rggpo t"  o   rgp(   ( -rgp ( s z o  X  i?`o o *(CU)|/07.s ~  oj:(s(o -'(  .r7hp%( s z~ ( ,)(q -( ruhp%( s z oi39(s(b(p -( rhp%( s z oh(xs o  N,3(s(p  -(  rhp %( s z~ ( ,(r& *8N0/~ ~ ok(xom(xol(x(t -( rhp %( s z(u-( rip%( s z&~ ( ,(r&~ ( ,(r&* y ( *( *0"0s ( o o * 01s (e(g*0O2o o o 8 o1 t o %9rWip( -Fr_ip( -lr}ip( :rip( :rip( :8o }3{3,{3rp( 9rips zo  (3 (  ( ( &}4+7o }6+)o }8{8,}5+ o }7 o4 : u@,o5 *A4)):{3*{4*{5*{6*{7*{8*( *( *( *0.3( (  ,i-~ *( o *>( }I*04( i?o} % 9rjp( -)rjp( -6rjp( -)r7jp( -6+N^_`^+@^_`^+&^_`^+ rGjpsyz~^,1~](rkjp(  + ( X i2o 0 o 1 rjpsyzo} }To} }P{T%,Gr$p( -r#p( -rp( -+}S+.}S+%}S+rjp{Trkp( syz({*05{S YE+(|{Q- r kpsyz{Qo- r9kpsyzs}R{Ro{Rrkp}{Ro*0~6rkp{T( ~ rfpo - rlpsyzo - rlpsyz o 8  o t" {P(( :}O{Po ( {S  YE(+7{Os}Q+${Os}Q+{Os.}Q{QrYlp{P( }{Qo{Qo{Qto{Qo}Urlp{U( (+Xi? o o *0L7 {S YE ++{Qs> +{Qs# + {Qs2 *08 s {So {Uo(}oooo o{Rsoooo o__` o(* 0( o t(&*0Q9( ~]o o ~^, o +  o o ~^,o (*0:i/*( s o ( s  ' s &sz o~R o (C o o (o (o! (rp((( rlp(*;J;YCJrlp(( *0Q( (3 o to s \rmp~\rmp( ]_`*( *r7mp*&(*(*0;s s s o o +o t ( . o - ,o5 o (o! (*')P H^ 0$<r?mp(((( r-po ( (%{`}%{`}o rkmpo ,%{ `}ݦ r-po ( (%{`}%{`}p r-po ( (%{`}%{`}: r-p o ( (%{`}%{ `}*4 "[ }6/ 60 :0-=rmp( (rmp rmp( (*0E> ~ rmpo ,rnpo ,% ,o5 {o*- 0[r5np(r_np(rnp (rnp({k(% -rnp{krkp( (*:rop (*0?  ..YE 99&990+7(+E(+<(+3(+*( + (+r1op*( (*0@rwopo t" ropo t" ropo * ropo ropo  j\ms ( rppo t" (% -o 1o }k{ o o{ o o{ o o{ o{o{ o{o*0GAr)ppo * rOppo   j\m {o{o*0B    rwppo o2 з(3 3  +* &%{`}.,3$rppo * rppo   {o{o *4</0jCrp rppo t" &%{`}(% - rppo ,*rqpo   j\m { o*/0SDrqpo  rqpo   j\m  j\m {o{ o*0ZE % ,Or#qp( -6r;qp( --roqp( - rqp( -rqp( - +  +  + + *0BF     rrpo t" r/rpo t"o} r9rpo *rMrpo t" rarpo t"rurpo t"rrpo ,jo 1o $3   8*rpo -  8rrpo -  8rrpo 9 e8rrpo ,   8rrpo -  8rspo ,   8r%spo , o 1{o $3p +kr7spo -  +VrCspo ,  o  1: o $3. +)r]spo ,   +respo - 9&5+ (  ( (  41{Y(o3{Y(o{*    or}sprsprsprsp*rsp  rsp  rsp (*   (6o o rspo ( (o! (*A 6{m*"}m*&{l**{l*R(  *}l*{n*{o*N( s }o*jo}n{oo &*2{oo *{p*{q*{r*{s*( }p}q{q({3 s}s*( }p}q{q({3 s}s*0cG{q({ E8YE/+&}r*%{rX}r*%{r`}r*}r*0:Hi  1*s  +oX 2o{so*{t*"}t*{u*~rp}t( s }u*0\I({,N{u"o 1{uo to*s o{u"o *0OI{u"o 1{uo to*s o{u"o *02J{u"o 1{uo too*z}}}}*( *F~!q!*F~!q!*0_K ! !rsp s!!rsp0s!!rsp s!!rsp s!!rtp s!!rOtps!!rgtps!!rytp4s!!rtps! !rtp5s! !rtps! !rtps! !rtps! !rup1s!!r/up6s!!rop2s!!rCup3s!!r_up %s!!rup7s!!rupus!!rupvs!!rupxs!!rupys!!r)vpGs!!rIvpHs!!rivpIs!!rvp8s!!rvp9s!!rvp=s!!rvp>s!!rvp s!!rwp:s! !r1wp;s!!!rGwp<s!"!rYwp?s!#!rwp@s!$!rwpAs!%!rwpBs!&!rwpCs!'!rxpDs!(!r=xpEs!)!r[xpFs!*!rwxp &s!+!rxp 's!,!rxp (s!-!rxp )s!.!rxp *s!/!r%yp +s!0!r[ypgs!1!ryphs!2!rypis!3!rypjs!4!rypks!5!rzpls!6!r+zpms!7!rSzpns!8!r{zpos!9!rzpps!:!rzpqs!;!rzprs!!rm{p~s!?!r{ps!@!r{p s!A!r{p s!B!r{p s!C!r%|p s!D!rU|p s!E!r{|p s!F!r|pws!G!r|pzs!H!r|p{s!I!r}p|s!J!r7}p}s!K!ra}p s!L!r}pJs!M!r}pKs!N!r}pLs!O!r}pMs!P!r}pNs!Q!r~pOs!R!r1~pPs!S!rI~pRs!T!ro~pSs!U!r~pTs!V!r~pUs!W!r~pXs!X!r~pVs!Y!r~pWs!Z!rp s![!r7p s!\!rMp s!]!rep s!^!r}p s!_!rp s!`!rp s!a!rp s!b!rp s!c!rp s!d!rp s!e!rp s!f!r%p s!g!r;p s!h!rMp s!i!rap s!j!rp s!k!rp s!l!rp s!m!rp s!n!r/p s!o!rSp s!p!rsp s!q!rp s!r!rp s!s!rp s!t!r p s!u!r+p s!v!rMp s!w!rqp s!x!rpYs!y!rpZs!z!rÂp[s!{!rp\s!|!r#p]s!}!rUp^s!~!rp_s!!rp`s! !rpas! !rpbs! !r?pfs! !rop s! !rp s! !rp s! !rp s! !r߄p s! !rp s! !r7p s! !rQp s! !ryp s! !rp s! !rp s! !r݅p s! !rp s! !r1p s! !r[p s!*{*"}*&(*0Lrp( ( ({-"rp( rp( s }{ov -{o rɆp(+rp( r!p( (}  } rp({ *?Gn{ ,} {ow *0#MrGp( rYp( ( ( *0N r]poz %rupo rpo (* (o o +|o1 t o oz .bo o ( ,O r]p o % rup o  rp o (* (o4 :yu@,o5 *[Frp( (*( *"(*0Orp ~^-* E  "*29@+Drsp +5 v L5Y5 a5l5 |55 5(5 (5*5. . 1 4 69. 9 >V8 F$K)V,b k s/    ) 9)u/ 9)'kru[VVVQ `VK~VS~V_VgSk Sy S} S S S S S S SK S SF   ~    Sy /S V V V/ VA VX Vn V V V V V V  V VV V  b    $$ ) V /V /V V /V V 6 %6  ) )% )/V0 )V5 )V= )VR )Vi )V} )V )V )V )  /d tVVVVVVVVV /F)VVVVV4VMVYVbVlVxVVVVVVVVVVVV V0VEVUVeVuVVVVVVVVVVVV%V7VNV]VkV{VVVVVVVVV"V3VEVYVmVVVVVVVVVV*VBVZVmVVVVVVVVVVV*V8VHVTVgVuVVVVVVVVVVVVVV)V1V;VBVMVVV`VuVVVVVVVVV#V5VEVVVhVzVVVVVVVV+V>VOVgVsVVVVVVVVVVV.VHV]|V$V$V$V$VVVVVVVVV2Q9 QK QY s//VV/VV/V'/V:VE ) P* * %, 2 7 ;!@ !D!H$!O!D"&D"D7"RD"b_2"HT"d"qO#~7 #O #y#_ #~7 |#O # D # #1 #5_ #5 #5 ##BO#GO#OO$U$ %D%4%BO%OO%GO&xO+O.18;;;_;~7x<O<D<<OO< <BOH=GO>O?#O$B1OB:OCFO@FMOGHDNHdHBOHOOH HGOJa KfONvOO @SO U V"V$`W&X(X*xY,Z.[4^6a8c*:He;O<eGO<fWO<jcO<0kqO<kvO<k|O<HlO<lO<lO<PmB_<me=mk=do%q>p7x?qO@qO@q^@q _Br eCs DDs1 kDsD pDsW DDsp DDs DDsOD D H J J  K  K QsOTsOTs T*tUCAHM R$W(\,a0f4k8p<u@zDHLPTXdhl p| -,          .S..K. .#.+.3.;.CC{cd io@1 A 5 j |   % M r 2Qr6PGOXk.3;FRXekrw(}   % SW[[[S[~[`[[[ [u) z8 [M [b [[V^[    "-,1=hi!j#k%l'm)+--//13579;==?AA .d.3 "HgD D D D D F F  444n4q4444444444444444444 55"5&5E5I5M5Q5U5_5c5g5k5o5s5w5{555555$9  lX X. l/    +*,*-*.*/*10SqlSqm.exeAssemblyVersionInfoSqmInstanceMicrosoft.SqlServerSqm.SharedNamedInstanceOlapInstanceMicrosoft.SqlServerSqm.CollectorCollector_baseCollector_ASRsInstanceCollector_RSCollector_SQLDatabaseTypeReportingServicesConnectionSqmSupportCatalogConnectionTypeCatalogConnectionAuthRSConfigConstsRsConfigNativeSECURITY_IMPERSONATION_LEVELDataProtectionLocalSqlSqmErrorMicrosoft.SqlServerSqm.ApplicationSqlSqmExceptionSqmExitCodeSqlSqmLauncherConstantsCollectorDiagCollector_WMIDataStreamEntryDataStreamDataContainerEntryDataContainerDataPointTypest_DataPointDPIndexDataPointsSqmInstanceTypeSqlInstanceStatusEventTypeLogUploadExceptionSqmmerSqmWrapperUploadFlagsSaveFlagsSessionFlagsFlagsUploadCallBackmscorlibSystemObjectEnumExceptionValueTypeMulticastDelegateVersionStringTypebInstOptInsqm_inst_idinst_keydumpDirSqmSessionIdSqmSessionNameset_InstOptInget_InstOptInset_InstIdget_InstIdget_DumpDir.ctorGetOptInInstOptInInstIdDumpDirconn_nameinst_nameclusteredvirt_nameget_Nameget_ConnectionNamebConnectedget_Clusteredget_VirtualNameSetVirtualNameCheckClusterConnectCloseConnectionNameConnectionNameClusteredVirtualNameMicrosoft.AnalysisServicesServerm_serverget_ConnectionConnectionm_diagm_dcm_sqmiget_DiagBitMapbit_arrayBitChangeStatusInitCollectCloseHashStringDiagBitMapm_Olapm_svrc_Serverc_databasesDatabasecs_Dimensionscs_Cubescs_DataMiningSystem.DataSystem.Data.SqlClientSqlConnectionm_connectionset_Connectionm_RSExecuteScalarc_countsc_rendformatsc_configc_executionc_perfc_datasourcesm_Sqlc_ADc_instance_infoGetDbTypec_dbm_databasescs_objectscs_assembliescs_misccs_columnscs_FullTextcs_dbinfocs_securitycs_Replicationcss_MergePublicationscss_MergeArticlescss_TranPublicationscss_TranArticlesc_endpointsc_dbm_endpointsc_optimizerc_Replicationc_NSc_Dtscs_DtsFolderStatscs_DtsPackageTypesc_Agentcs_AgentJobStepsSubsystemsvalue__SYSTEMSAMPLEUSERRegSqlServerRootKeyNamem_configsOpenRsConnectionsGetConfigFilePathOpenSqlConnectionGetCatalogUserTokenDefaultImpersonateWindowsSqlConfigurationDSNConnectionStringConnectionTypeCatalogUserCatalogDomainCatalogCredKeyValueUserNameSystem.XmlXmlDocumentSafeOpenXmlDocumentFileReadConfigFileParseConfigget_EncryptedDsnget_ConnectionTypeget_ConnectionAuthget_EncryptedCatalogUserget_EncryptedCatalogCredget_EncryptedCatalogDomainm_encryptedDSNm_connectionTypem_connectionAuthm_encryptedCatalogUserm_encryptedCatalogCredm_encryptedCatalogDomainEncryptedDsnConnectionAuthEncryptedCatalogUserEncryptedCatalogCredEncryptedCatalogDomainTOKEN_IMPERSONATEERROR_NO_TOKENLOGON32_LOGON_INTERACTIVELOGON32_PROVIDER_DEFAULTOpenThreadTokenSetThreadTokenRevertToSelfCloseHandleGetCurrentThreadLogonUserDuplicateTokenSecurityAnonymousSecurityIdentificationSecurityImpersonationSecurityDelegationLocalUnprotectDataUnknownServiceTypeArgTooBigUnknownParameterInstanceNotFoundInstanceOptOutRegKeyNotFoundErrorOKUnhandledExceptionSuicidesqmigenitypeikeydump_dirRegisterRegisterInstanceCreateCollectorRunUnhandledExceptionEventArgsUnhandledFilterDumpExceptionMainSuicideTimerMaxFilesToKeepMaxFileLengthMaxLifeTimespanMegaByteConnectionTimeoutErrorInvalidObjectErrorVersionverDebugUploadUploadToMSFailTimeoutInvalidCastExceptionNullReferenceExceptionManagementExceptionManagementNotFoundSqlExceptionConnectionFailureComExceptionSystemDrivecollect_WMIcollectWmiClassuc_MsftInternaluc_OS_CSuc_ServicesSystem.ManagementManagementObjectstore_WMIst_OSst_CSst_Processorst_DiskDrivest_LogicalDiskServiceStartNameCodest_Servicestreamlengthget_Lengthset_Lengthget_Itemset_ItemLengthItemSystem.CollectionsArrayListget_StreamAddCloseStreamStreamdpindexindexvalueget_dpIndexget_Indexget_ValueSetDataSetDataStreamdpIndexIndexpathSortedListlistget_Pathset_Pathget_ListSetStreamDataPathListNUMBERNUMBER64INCREMENTAVERAGEMAXMINBOOLBITMAPSTREAMIdEnabledIsInternalMSFTSessionTypeSessionStateSessionGenCollectorDiagSessionSpecCollectorDiagNumberOfCpuCpuSpeedCpuFamilyTotalMemoryTotalDiskMBOSVersionMajorOSVersionMinorOSVersionBuildOSVersionSPOSEditionOSLanguageOSProcessSizeNumberOfNumaNodesOSServiceStreamGenServiceMapGenServiceOnMapSystemDriveSizeSystemDriveFreeSpaceSqlVersionMajorSqlVersionMinorSqlVersionBuildSqlClusteredSqlIntSecSqlFTinstalledSqlLicenseTypeSqlNumLicensesSqlADregisteredSqlEditionSqlLevelSqlEndpointProtocolStreamSqlDbStreamSqlDbMiscStreamSqlDbColumnStreamSqlDbObjectStreamSqlDbAssmPermSetStreamSqlDbClrStreamSqlDbFtStreamSqlDbInfoStreamSqlConfigStreamSqlRanuCountSqlDbSecurityStreamSqlInstSecurityStreamSqlMemoryUtilizationStreamSqlQOFracTrivPlanSqlQOFracSearch0SqlQOFracSearch1SqlQOFracSearch2SqlQOFracTimeoutSqlQOFracMemLimitSqlQOAvgSearch0timeSqlQOAvgSearch1timeSqlQOAvgSearch2timeSqlQOAvgSearch0tasksSqlQOAvgSearch1tasksSqlQOAvgSearch2tasksSqlQOAvgStage1gainSqlQOAvgStage2gainReplOraclePubReplGenStreamReplMergePubStream1ReplMergePubStream2ReplMergeArticleStream1ReplMergeArticleStream2ReplTranPubStream1ReplTranArticleStream1NSNumInstancesDtsPackageFoldersDtsFoldersMaxDepthDtsFoldersAvgDepthDtsPackageTypeStreamAgentJobStepSubsystemStreamRsUsersRsCatalogReportsRsServersRsSecRolesRsRendFormatsRsSubscriptionsRsFormsAuthRsExecSourceStreamRsExecReportsRsExecSuccessRsExecErrorRsExecInteractRsExecUnattendRsExecPerfStreamRsDSEmbeddedRsDSSharedRsDSCredWinRsDSCredSqlRsDSImpersonateRsDSModelRsDSPromptRsDSIntSecRsDSNoCredRsDSSqlRsDSOledbRsDSASRsDSOracleRsDSOdbcRsDSOtherRsCfgEnableMyReportsRsCfgSnapshotCompressionRsCfgUseSessionCookiesRsCfgEnableIntSecRsRendFormatCsvRsRendFormatImageRsRendFormatXmlRsRendFormatHtml32RsRendFormatHtml40RsRendFormatHtmlowcRsRendFormatMhtmlRsRendFormatPdfRsRendFormatRgdiRsRendFormatExcelRsRendFormatOtherAsCollationAsLanguageAsFilesEnableBinaryXMLAsFilesEnableCompressionAsNetworkEnableBinaryXMLAsNetworkEnableCompressionAsCoordinatorExecutionModeAsProcessBufferMemoryLimitAsTotalMemoryLimitAsLowMemoryLimitAsFlightRecorderEnabledAsNumTracesAsNumDatabasesAsDbStreamAsDimensionStreamAsDataMiningStreamAsMiningStructuresStreamAsCubeStreamAsMGDimensionStreamAsMeasureStreamAsPartitionStreamAsClrAssembliesAsComAssembliesAsImpersonationModeStreamSqlDbmEndPointStreamSqlDbmDatabaseStreamDataPointDataPoints_arrayGENERALSQLOLAPRSNOTHINGSTATUSINFOWARNINGERROREXCEPTIONDEBUGSTACK_TRACEDATAPOINTWriteSQLExceptionWriteDebugWriteStackerrorSystem.NetHttpStatusCodestatusTestSQMServerNameSQMServerNameSQMSecureServerNameOpenSqmSessionCloseSqmSessionUploadFileSqmifySqmifyEntrySqmifyStreamGetSessionSystem.Runtime.InteropServices.ComTypesFILETIME_GetSessionStartTimeDateTimeGetSessionStartTimeStartSessionEndSessionSetSet64SetBoolSetBitsSetIfMaxSetIfMinIncrementAddToAverageAddToStreamGetGet64SetEnabledGetEnabledSetAppVersionTimerStartTimerRecordTimerAccumulateTimerAddToAverageGuidSetMachineIdSetUserIdGetMachineIdGetUserIdReadSharedMachineIdReadSharedUserIdWriteSharedMachineIdWriteSharedUserIdCreateNewIdSetCurrentTimeAsUploadTimeGetStreamValuesIsSharedMemoryConsistentStartUploadAbortUploadUPLOAD_SINGLE_FILEUPLOAD_ALL_FILESOVERWRITE_ANY_FILEOVERWRITE_OLDEST_FILESESSION_CREATE_NEWFLAG_DEBUGFLAG_NEVER_THROTTLEInvokeIAsyncResultAsyncCallbackBeginInvokeEndInvokeSystem.ReflectionAssemblyDescriptionAttributeAssemblyFileVersionAttributeAssemblyVersionAttributeAssemblyTrademarkAttributeAssemblyCopyrightAttributeAssemblyProductAttributeAssemblyCompanyAttributeSystem.DiagnosticsDebuggableAttributeDebuggingModesSystem.Runtime.CompilerServicesCompilationRelaxationsAttributeRuntimeCompatibilityAttributeInt16StringConcata_typeMicrosoft.Win32RegistryRegistryKeyLocalMachineOpenSubKeyGetValueInt32System.IODirectorySeparatorCharCharToStringEndsWitha_namea_inst_nameStringComparisonCompareEnvironmentget_MachineNameget_ConnectedDisconnectidxa_msga_exa_sqmia_dchashNameget_Chars.cctorUInt32{7CC3D068-6DB1-478E-9F17-A62017E6E30A}CompilerGeneratedAttribute__StaticArrayInitTypeSize=64$$method0x60000fa-1RuntimeHelpersArrayRuntimeFieldHandleInitializeArrayget_Messageget_StackTraceServerPropertyCollectionget_ServerPropertiesServerPropertyIsNullOrEmptySystem.GlobalizationNumberFormatInfoget_InvariantInfoConvertIFormatProviderToUInt32ToDoubleDoubleToInt32TraceCollectionget_TracesModelComponentCollectionget_CountAssemblyCollectionget_AssembliesIEnumeratorGetEnumeratorget_CurrentAssemblyGetTypeClrAssemblyRuntimeTypeHandleGetTypeFromHandleComAssemblyMoveNextIDisposableDisposeDatabaseCollectionget_Databasesget_EstimatedSizeImpersonationInfoget_DataSourceImpersonationInfoImpersonationModeget_ImpersonationModeRoleCollectionget_RolesTranslationCollectionget_TranslationsDataSourceCollectionget_DataSourcesDataSourceDataSourceIsolationget_Isolationget_ImpersonationInfoa_dbDimensionCollectionget_DimensionsDimensionDimensionStorageModeget_StorageModeget_WriteEnabledProactiveCachingget_ProactiveCachingget_EnabledDimensionAttributeCollectionget_AttributesDimensionAttributeAttributeTranslationCollectionget_AttributeHierarchyEnabledHierarchyCollectionget_HierarchiesHierarchyLevelCollectionget_LevelsLevelHideIfValueget_HideMemberIfCubeCollectionget_CubesCubeKpiCollectionget_KpisKpiCubeDimensionCollectionCubeDimensionget_DimensionPerspectiveCollectionget_PerspectivesPerspectiveActionCollectionget_ActionsActionReportActionDrillThroughActionMdxScriptCollectionget_MdxScriptsMdxScriptCommandCollectionget_CommandsIEnumerableCommandget_TextContainsMeasureGroupCollectionget_MeasureGroupsMeasureGroupMeasureGroupDimensionCollectionMeasureGroupDimensionManyToManyMeasureGroupDimensionReferenceMeasureGroupDimensionDegenerateMeasureGroupDimensionDataMiningMeasureGroupDimensionMeasureCollectionget_MeasuresMeasureAggregationFunctionget_AggregateFunctionget_MeasureExpressionPartitionCollectionget_PartitionsPartitionStorageModePartitionTypeget_Typeget_RemoteDataSourceIDget_StorageLocationMathMaxMiningStructureCollectionget_MiningStructuresMiningStructureMiningModelCollectionget_MiningModelsMiningModelMiningModelColumnCollectionget_ColumnsMiningModelColumnget_AlgorithmSystem.Collections.GenericDictionary`2$$method0x600002a-1TryGetValueSystem.Data.CommonDbConnectionConnectionStateget_Statea_cmdSqlCommandDbCommandget_NumberSqlDataReaderExecuteReaderDbDataReaderGetStringToUpperInvariantGetInt32$$method0x6000037-1ReadGetByteGetInt64GetDoubleop_Equalityget_Majorget_Minorget_Builda_dbNameToLowerInvariant$$method0x6000044-1SqlCommandBuilderSystem.TextStringBuilderAppendSqlDataAdapterDataTableDbDataAdapterFillDataRowCollectionget_RowsInternalDataCollectionBaseDataRowDbCommandBuilderQuoteIdentifierByteBooleanTrimChangeDatabasea_dbIdset_CommandTimeouta_dbida_dbNameQa_publisheda_merge_publisheda_subscribedGetBooleanGetInt16$$method0x6000055-1DecimalGetDecimalop_MultiplyoptionalInstanceNameList`1ToArrayGetValueNamesIEnumerable`1GetSubKeyNamesFileExistsconfigIntPtrZeroSystem.Runtime.InteropServicesMarshalGetLastWin32Errorop_InequalityOpendocpathToXmlFileFileStreamFileModeFileAccessFileShareXmlReaderCreateLoadpathToConfigXmlElementget_DocumentElementXmlNodeXmlNodeListget_ChildNodesget_InnerTextParseCultureInfoget_InvariantCultureArgumentExceptionDllImportAttributeadvapi32.dllthreadHandleInAttributeDesiredAccessOpenAsSelfTokenHandleOutAttributekernel32.dllhDeviceuserNamedomainpassworddwLogonTypedwLogonProviderphTokenhTokenimpersonationLevelhNewTokendataFromBase64StringSystem.SecuritySystem.Security.CryptographyProtectedDataDataProtectionScopeUnprotectEmptyEncodingget_Unicodea_errorargsSubstringToInt16senderset_ExitCodeget_ExceptionObjectexMicrosoft.SqlServer.MgdSqlDumperMicrosoft.SqlServer.SqlDumperDumpClientDumperGetDumperSetTitleNameSetExceptionDumperFlagsSetFlagsDumpGetDumpResultTextSTAThreadAttributeAppDomainget_CurrentDomainUnhandledExceptionEventHandleradd_UnhandledExceptionInitializeSystem.ThreadingTimerCallbackTimerstateExitGetCallingAssemblyGetCustomAttributesget_VersionFlagsAttributea_scopea_queryManagementScopeObjectQueryManagementObjectSearcherManagementObjectCollectionManagementObjectEnumeratorManagementBaseObjectStartsWithCOMExceptiona_classa_moUInt16UInt64CompareToDefaultMemberAttributea_dseTrimToSizea_valuea_dataSerializableAttributea_idxa_valIndexOfKeyGetByIndexParamArrayAttributeStructLayoutAttributeLayoutKinda_ida_enableda_inputget_NowConsoleWriteLinesqlexget_ClassSqlErrorCollectionget_ErrorsSqlErrora_statusget_Revisiona_pathDirectoryGetFilesGetFileNameIsDigitDeleteIOExceptionurlWebRequestset_Methodset_ContentLengthGetRequestStreamMinWebResponseGetResponseHttpWebResponseget_StatusCodeIListGetValueLista_dcea_dpIda_dscustsat.dll#2sessionIdentifiermaxSessionSizeflags#26hSessiondwHighDateTimedwLowDateTimeAddMilliseconds#3#4pszDirOrFilePathdwMaxFilesToQueuedwFlags#5dwIddwVal#27qwVal#6#7dwOrBits#8#9#10dwInc#11#12nArgsp1p2p3p4p5p6p7p8p9#15pdwVal#28pqwVal#16fEnabled#17#22dwVersionHighdwVersionLow#23#24#25#45#18pGuid#19#20#21#29#30#31#32#33#48pszSqmFileName#40idrgStreampcVals#41#46szPatternszUrlszSecureUrlpfnCallback#47dwTimeoutMillisecondsobjectmethodhrfilePathMarshalAsAttributeUnmanagedTypedwHttpResponsecallbackresultSqlSqmInstance#ErrorReportingDir \CPEErrorDumpDir!CustomerFeedbackMSSQLSERVER\\ClusterClusterNamebase collector3 Initializing collector: OLAP CollationNameLanguage#Server Language: ANetwork\Requests\EnableBinaryXML trueCNetwork\Responses\EnableBinaryXMLENetwork\Requests\EnableCompressionGNetwork\Responses\EnableCompression/Memory\TotalMemoryLimit5TotalMemoryLimit string: '' double: +Memory\LowMemoryLimit1LowMemoryLimit string: '=OLAP\Process\BufferMemoryLimit7BufferMemoryLimit string: '1CoordinatorExecutionMode5Log\FlightRecorder\Enabled CACHE7Microsoft_Association_Rules)Microsoft_Clustering1Microsoft_Decision_Trees+Microsoft_Naive_Bayes1Microsoft_Neural_Network;Microsoft_Sequence_Clustering+Microsoft_Time_SeriesConnecting to 3Connection attempt failedRS1Running RS collector on yselect count(*) as TotalUniqueUsers from Users with (nolock)yselect count(Type) from Catalog with (nolock) where Type = 2Oselect count(*) from Keys with (nolock)Qselect count(*) from Roles with (nolock)select count(distinct Format) from ExecutionLog with (nolock) where Format is not NULLaselect count(*) from Subscriptions with (nolock)wselect count(*) from Users with (nolock) where authtype = 3select Format, count(*) from ExecutionLog with (nolock) where Format is not NULL GROUP BY Format CSV IMAGEXMLHTML4.0 MHTMLPDF RGDIHTMLOWC EXCELHTML3.2Select UPPER(Cast (Value As nvarchar(256))) From ConfigurationInfo where Name = 'EnableMyReports' Select UPPER(Cast (Value As nvarchar(256))) From ConfigurationInfo where Name = 'SnapshotCompression' Select UPPER(Cast (Value As nvarchar(256))) From ConfigurationInfo where Name = 'UseSessionCookies' Select UPPER(Cast (Value As nvarchar(256))) From ConfigurationInfo where Name = 'EnableIntegratedSecurity' select source, count(*) from ExecutionLog with (nolock) where DATEDIFF(d, GETDATE(), TimeStart) =-1 group by sourceselect count(*) from ExecutionLog with (nolock) where DATEDIFF(d, GETDATE(), TimeStart) =-1 and Status = 'rsSuccess'select count(*) from ExecutionLog with (nolock) where DATEDIFF(d, GETDATE(), TimeStart) =-1 and Status <> 'rsSuccess'select count(*) from ExecutionLog with (nolock) where DATEDIFF(d, GETDATE(), TimeStart) =-1 and RequestType = 0select count(*) from ExecutionLog with (nolock) where DATEDIFF(d, GETDATE(), TimeStart) =-1 and RequestType = 1select IsNULL(MIN([RowCount]),0), IsNULL(MAX([RowCount]),0), IsNULL(AVG([RowCount]),0), IsNULL(STDEV([RowCount]),0.0) from ExecutionLog with (nolock) where DATEDIFF(d, GETDATE(), TimeStart) =-1 and [RowCount] > 0select IsNULL(MIN(TimeDataRetrieval),0), IsNULL(MAX(TimeDataRetrieval),0), IsNULL(AVG(TimeDataRetrieval),0), IsNULL(STDEV(TimeDataRetrieval),0.0) from ExecutionLog with (nolock) where DATEDIFF(d, GETDATE(), TimeStart) =-1 and TimeDataRetrieval > 0select IsNULL(MIN(TimeProcessing),0), IsNULL(MAX(TimeProcessing),0), IsNULL(AVG(TimeProcessing),0), IsNULL(STDEV(TimeProcessing),0.0) from ExecutionLog with (nolock) where DATEDIFF(d, GETDATE(), TimeStart) =-1 and TimeProcessing > 0select IsNULL(MIN(TimeRendering),0), IsNULL(MAX(TimeRendering),0), IsNULL(AVG(TimeRendering),0), IsNULL(STDEV(TimeRendering),0.0) from ExecutionLog with (nolock) where DATEDIFF(d, GETDATE(), TimeStart) =-1 and TimeRendering > 0Select count(*) From Datasource d WITH (nolock) join Catalog c on (d.ItemID = c.ItemID) Where d.Link Is NULL Select count(*) From Datasource d WITH (nolock) join Catalog c on (d.ItemID = c.ItemID) Where d.Link Is Not NULL Select count(*) From Datasource WITH (nolock) Where (Flags & 8)=8 And Link Is NULL Select count(*) From Datasource WITH (nolock) Where (Flags & 8)=0 And Link Is NULL Select count(*) From Datasource WITH (nolock) Where (Flags & 4)=4 And Link Is NULL Select count(*) From Datasource WITH (nolock) Where (Flags & 16)=16 Select count(*) From Datasource WITH (nolock) Where CredentialRetrieval=1 And Link Is NULL Select count(*) From Datasource WITH (nolock) Where CredentialRetrieval=3 And Link Is NULL Select count(*) From Datasource WITH (nolock) Where CredentialRetrieval=4 And Link Is NULL Select count(*) From Datasource WITH (nolock) Where Extension Is Not NULL And Link Is NULL Select count(*) From Datasource WITH (nolock) Where Extension='SQL' And Link Is NULL Select count(*) From Datasource WITH (nolock) Where Extension='OLEDB' And Link Is NULL Select count(*) From Datasource WITH (nolock) Where (Extension='ADOMD-MD' OR Extension = 'OLEDB-MD') And Link Is NULLSelect count(*) From Datasource WITH (nolock) Where Extension='Oracle' And Link Is NULL Select count(*) From Datasource WITH (nolock) Where Extension='ODBC' And Link Is NULL SQL3Running SQL collector on \SQLServerSCPobjectGUIDselect SERVERPROPERTY('Collation'), SERVERPROPERTY('EngineEdition'), SERVERPROPERTY('IsClustered'), SERVERPROPERTY('IsFullTextInstalled'), SERVERPROPERTY('IsIntegratedSecurityOnly'), SERVERPROPERTY('IsSingleUser'), SERVERPROPERTY('LicenseType'), IsNULL(SERVERPROPERTY('NumLicenses'),0) [NumLicenses], SERVERPROPERTY('EDITION'), SERVERPROPERTY('PRODUCTLEVEL'), SERVERPROPERTY('PRODUCTVERSION'), COUNT(distinct parent_node_id) from sys.dm_os_schedulers where scheduler_id < 255PER_SEATPER_PROCESSORDISABLEDselect configuration_id, cast(value_in_use as int), cast(value as int) from sys.configurations]select count(*) from sys.dm_os_child_instancesselect type, count(*)[count] from sys.server_principals group by typeqselect cast(record as xml).value('(/Record/MemoryRecord/MemoryUtilization)[1]', 'int'), cast(record as xml).value('(/Record/MemoryRecord/TotalPhysicalMemory)[1]', 'int'), cast(record as xml).value('(/Record/MemoryRecord/AvailablePhysicalMemory)[1]', 'int'), cast(record as xml).value('(/Record/MemoryRecord/AvailablePageFile)[1]', 'int') from sys.dm_os_ring_buffers where ring_buffer_type = 'RING_BUFFER_RESOURCE_MONITOR' order by timestamp master tempdb model msdb pubsnorthwindadventureworks!adventureworksdwSELECT name, d.database_id, state, kIsNULL (source_database_id, 0) [source_database_id], 5snapshot_isolation_state, ?is_read_committed_snapshot_on, yIsNULL (m.mirroring_state_desc, '') [mirroring_state_desc], IsNULL (m.mirroring_safety_level, 255) [mirroring_safety_level], is_published, )is_merge_published, is_subscribed FROM sys.databases d JOIN sys.database_mirroring m ON (d.database_id = m.database_id) IsNULL (m.mirroring_safety_level, 0) [mirroring_safety_level], IsNULL (m.mirroring_witness_name, '') [mirroring_witness_name], _IsNULL (m.mirroring_role, 0) [mirroring_role], IsNULL (m.mirroring_role_sequence, 0) [mirroring_role_sequence], IsNULL (m.mirroring_safety_sequence, 0) [mirroring_safety_sequence] Gselect type, count(*) [Count] from i.sys.objects o where is_ms_shipped=0 group by type +Select count(*) from %.sys.views v join W.sys.indexes i on (v.object_id=i.object_id)Kselect permission_set, count(*) from Q.sys.assemblies group by permission_set ).sys.assembly_types 1.sys.database_principals1.sys.dm_qn_subscriptions+select count(*) from .sys.columns_.sys.columns where system_type_id in (34,35,99).sys.columns where system_type_id in (165,167,231) and max_length=-1K.sys.columns where system_type_id=241OSelect COUNT(fulltext_catalog_id) From -.sys.fulltext_catalogsQSelect COUNT(distinct t.object_id) From ;.sys.fulltext_indexes f join .sys.tables t on (f.object_id=t.object_id) WHERE f.is_enabled=1create table #dbinfo ( ParentObject varchar (100), Object varchar (100), Field varchar (100), Val varchar (100));insert into #dbinfo exec ('dbcc dbinfo (-) with tableresults');Select cast(Val as int) from #dbinfo where Field = 'dbi_RebuildLogs'select datediff(dd, Val, GetDate()) from #dbinfo where Field = 'dbi_dbccLastKnownGood'Select cast(Val as int) from #dbinfo where Field='dbi_dbccFlags'Select cast(Val as int) from #dbinfo where Field = 'dbi_createVersion'Select cast(Val as int) from #dbinfo where Field = 'dbi_version'%drop table #dbinfo+SELECT count(*) FROM O.sys.key_encryptions WHERE key_id = 101Eselect type, count(*)[count] from O.sys.database_principals group by type 3Select COUNT(pubid) From ).dbo.syspublications.dbo.sysmergepublications Where UPPER(publisher) = UPPER(@@servername) and UPPER(publisher_db) = UPPER('') 3Select COUNT(subid) From .dbo.sysmergesubscriptions Where UPPER(subscriber_server) <> UPPER(@@servername) Or UPPER(db_name) <> UPPER('K.dbo.syssubscriptions Where srvid<>-1Select case when validate_subscriber_info is null then 0 else 1 end, scase when alt_snapshot_folder is null then 0 else 1 end, scase when pre_snapshot_script is null then 0 else 1 end, ucase when post_snapshot_script is null then 0 else 1 end, ccase when ftp_address is null then 0 else 1 end, ccase when ad_guidname is null then 0 else 1 end, case when upper(distributor) <> upper(@@servername) then 1 else 0 end, enabled_for_internet, dynamic_filters, snapshot_in_defaultfolder, compress_snapshot, allow_subscriber_initiated_snapshot, automatic_reinitialization_policy, isnull(allow_subscription_copy, 0), isnull(allow_synctoalternate, 0), isnull(allow_web_synchronization, 0), isnull(allow_partition_realignment, 0), isnull(allow_push, 0), isnull(allow_pull, 0), isnull(allow_anonymous, 0), isnull(centralized_conflicts, 0), isnull(keep_before_values, 0), gisnull(decentralized_conflicts, 0), replicate_ddl, isnull(publication_type, 0), isnull(sync_mode, 0), isnull(status, 0), eisnull(snapshot_ready, 0), retention_period_unit, Cisnull(use_partition_groups, 0), kisnull(retention, 0), isnull(conflict_retention, 0), isnull(generation_leveling_threshold, 0), backward_comp_level, omax_concurrent_merge, max_concurrent_dynamic_snapshots From 5.dbo.sysmergepublications {Select case when article_resolver is null then 0 else 1 end, scase when subset_filterclause is null then 0 else 1 end, case when destination_object = object_name(objid) then 0 else 1 end, }case when upper(destination_owner) = 'DBO' then 0 else 1 end, mallow_interactive_resolver, fast_multicol_updateproc, published_in_tran_pub, lightweight, isnull(delete_tracking, 0), compensate_for_errors, stream_blob_columns, preserve_rowguidcol, ocolumn_tracking, vertical_partition, identity_support, Misnull(verify_resolver_signature, 0), isnull(type, 0), isnull(view_type, 0), isnull(pre_creation_command, 0), Eisnull(status, 0), upload_options,isnull(missing_col_count, 0), excluded_col_count, check_permissions, maxversion_at_cleanup, processing_order, isnull(threshold, 0), Qisnull(pub_range, 0), isnull(range, 0), Uconvert(bigint, isnull(schema_option, 0)) -.dbo.sysmergearticles Select case when alt_snapshot_folder is null then 0 else 1 end, acase when queue_type is null then 0 else 1 end, allow_push, allow_pull, allow_anonymous, immediate_sync_ready, allow_sync_tran, sindependent_agent, immediate_sync, enabled_for_internet, Oautogen_sync_procs, allow_queued_tran, ]snapshot_in_defaultfolder, compress_snapshot, Iallow_dts, allow_subscription_copy, isnull(centralized_conflicts, 0), allow_initialize_from_backup, Arepl_freq, status, sync_method, sisnull(conflict_policy, 0), backward_comp_level, options +.dbo.syspublications uSelect case when filter_clause is null then 0 else 1 end, qcase when ins_scripting_proc is null then 0 else 1 end, qcase when del_scripting_proc is null then 0 else 1 end, qcase when upd_scripting_proc is null then 0 else 1 end, gcase when custom_script is null then 0 else 1 end, ocase when upper(dest_owner) = 'DBO' then 0 else 1 end, 7fire_triggers_on_snapshot, Apre_creation_cmd, status, type, #.dbo.sysarticles Select protocol, count(*) from master.sys.endpoints group by protocol t.port, 3e.is_encryption_enabled, /e.encryption_algorithm FROM sys.database_mirroring_endpoints e JOIN sys.tcp_endpoints t ON (e.endpoint_id = t.endpoint_id) select counter, occurrence, IsNULL(value,0) from sys.dm_exec_query_optimizer_infooptimizationstrivial plansearch 0search 0 timesearch 0 taskssearch 1search 1 timesearch 1 taskssearch 2search 2 timesearch 2 tasks/gain stage 0 to stage 1/gain stage 1 to stage 2timeout+memory limit exceededSelect count(*) From msdb.dbo.MSdistpublishers Where UPPER(publisher_type) like 'ORACLE%' WSelect count(*) from msdb.NS90.NSInstances ySelect count(folderid) From msdb.dbo.sysdtspackagefolders90 aWITH folders (folderid, parentfolderid, level) AS (Select folderid, parentfolderid, 0 as level From msdb.dbo.sysdtspackagefolders90 f Where parentfolderid is null Union ALL Select s.folderid, s.parentfolderid, level+1 From msdb.dbo.sysdtspackagefolders90 s join folders f on (s.parentfolderid=f.folderid) )Select MAX(level), AVG(level*1.0) from folders l Where NOT Exists (select * from folders n where l.folderid=n.parentfolderid) Select packagetype, count(*) From msdb.dbo.sysdtspackages90 Group BY packagetype Select UPPER(subsystem collate SQL_Latin1_General_CP1_CS_AS), count(*) From msdb.dbo.sysjobsteps s join msdb.dbo.sysjobs j on (s.job_id=j.job_id and j.enabled=1) Group by UPPER(subsystem collate SQL_Latin1_General_CP1_CS_AS) sSOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\RSOSOFTWARE\Microsoft\Microsoft SQL Server \Setup'RSVirtualRootServerSqlProgramDirm\Reporting Services\ReportServer\RSReportServer.configECould not find RS config file at: =OpenThreadToken: Win32 error: 7RevertToSelf: Win32 error: ;SetThreadToken: Win32 error: 1LogonUser: Win32 error: ;DuplicateToken: Win32 error: DsnConnectionTypeLogonUserLogonDomainLogonCredINo DSN present in configuration file TEST UPLOADTEST_UPLOADSHOWLOG#Unknown parameterParameters: QSupplied arguments exceed allowed length-Unknown Service Type ''/InstanceID wasn't foundQInstance Opt-in property is set to FALSEUSOFTWARE\Microsoft\Microsoft SQL Server\90Instance Names\WCan't find SQL Server specific Registry keyQSOFTWARE\Microsoft\Microsoft SQL Server\DumpDir: Good bye!/Suicide timer triggeredSqlSqm ver. 5/17/05 9:55WMI+Running WMI collectorNot found Collecting root\cimv2SELECT * FROM KSOFTWARE\Policies\Microsoft\SQMClientMSFTInternal)Win32_ComputerSystem+Win32_OperatingSystemWin32_ProcessorWin32_DiskDriveIWin32_LogicalDisk WHERE DeviceID = 'Win32_ServiceECollector_WMI: unknown store type CaptionVersionOSLanguage/ServicePackMajorVersion)MaxProcessMemorySize!WindowsDirectory%NumberOfProcessors'TotalPhysicalMemoryProcessorType#CurrentClockSpeed FamilyMediaType+Fixed hard disk media SizeFreeSpaceLocalSystem3NT AUTHORITY\LocalService5NT AUTHORITY\LOCAL SERVICE7NT AUTHORITY\NetworkService9NT AUTHORITY\NETWORK SERVICEDisplayName NameProcessIdStartModeStartName State MSSQL-MSSQLSERVEROLAPSERVICE'MSSQLSERVERADHELPERMSOLAP$SQLSERVERAGENTSQLAGENT$MSFTESQL MSDTCREPORTSERVERNS$MsDtsServerService:  : IsInternalMSFTSessionTypeSessionState/SessionGenCollectorDiag1SessionSpecCollectorDiagNumberOfCpuCpuSpeedCpuFamilyTotalMemoryTotalDiskMBOSVersionMajorOSVersionMinorOSVersionBuildOSVersionSPOSEditionOSProcessSize#NumberOfNumaNodesOSServiceStreamGenServiceMapGenServiceOnMapSystemDriveSize)SystemDriveFreeSpaceSqlVersionMajorSqlVersionMinorSqlVersionBuildSqlClusteredSqlIntSecSqlFTinstalledSqlLicenseTypeSqlNumLicensesSqlADregisteredSqlEditionSqlLevel5SqlEndPointsProtocolStreamSqlDbStreamSqlDbMiscStream#SqlDbColumnStream#SqlDbObjectStream-SqlDbAssmPermSetStreamSqlDbClrStreamSqlDbFtStreamSqlDbInfoStreamSqlConfigStreamSqlRanuCount'SqlDbSecurityStream+SqlInstSecurityStream5SqlMemoryUtilizationStream#SqlQOFracTrivPlan!SqlQOFracSearch0!SqlQOFracSearch1!SqlQOFracSearch2!SqlQOFracTimeout#SqlQOFracMemLimit'SqlQOAvgSearch0time'SqlQOAvgSearch1time'SqlQOAvgSearch2time)SqlQOAvgSearch0tasks)SqlQOAvgSearch1tasks)SqlQOAvgSearch2tasks%SqlQOAvgStage1gain%SqlQOAvgStage2gainReplOraclePubReplGenStream'ReplMergePubStream1'ReplMergePubStream2/ReplMergeArticleStream1/ReplMergeArticleStream2%ReplTranPubStream1-ReplTranArticleStream1NSNumInstances#DtsPackageFolders%DtsFoldersMaxDepth%DtsFoldersAvgDepth)DtsPackageTypeStream7AgentJobStepSubsystemStreamRsUsers!RsCatalogReportsRsServersRsSecRolesRsRendFormatsRsSubscriptionsRsFormsAuth%RsExecSourceStreamRsExecReportsRsExecSuccessRsExecErrorRsExecInteractRsExecUnattend!RsExecPerfStreamRsDSEmbeddedRsDSSharedRsDSCredWinRsDSCredSqlRsDSImpersonateRsDSModelRsDSPromptRsDSIntSecRsDSNoCredRsDSSqlRsDSOledb RsDSASRsDSOracleRsDSOdbcRsDSOther)RsCfgEnableMyReports1RsCfgSnapshotCompression-RsCfgUseSessionCookies#RsCfgEnableIntSecRsRendFormatCsv#RsRendFormatImageRsRendFormatXml%RsRendFormatHtml32%RsRendFormatHtml40'RsRendFormatHtmlowc#RsRendFormatMhtmlRsRendFormatPdf!RsRendFormatRgdi#RsRendFormatExcel#RsRendFormatOtherAsCollationAsLanguage-AsFilesEnableBinaryXML1AsFilesEnableCompression1AsNetworkEnableBinaryXML5AsNetworkEnableCompression5AsCoordinatorExecutionMode5AsProcessBufferMemoryLimit%AsTotalMemoryLimit!AsLowMemoryLimit/AsFlightRecorderEnabledAsNumTracesAsNumDatabasesAsDbStream#AsDimensionStream%AsDataMiningStream1AsMiningStructuresStreamAsCubeStream'AsMGDimensionStreamAsMeasureStream#AsPartitionStreamAsClrAssembliesAsComAssemblies3AsImpersonationModeStream)SqlDbmEndPointStream)SqlDbmDatabaseStreamserver=3;Trusted_Connection=true;9Connection attempt succeededConnection to % is currently Open{0} {1}GSQLERROR: sev   DEBUG: Status: ERROR: EXCEPTION: INFO: WARNING: DATAPOINT: SqlSqmSessionsqlsqm%02d.sqmIhttp://sqlreli/sqmtest/sqmserver.dllihttp://sqm.microsoft.com/sqm/SQLServer/sqmserver.dll)Upload destination: sqlsqm??.sqmiFile name doesn't qualify for upload. Skipping file mFile number is ouside of allowed range. Skipping file Uploading Deleting 9 exceeds allowed file length POST9Upload failed; HttpResponse=Entering UploadUpload finishedh|mG  z\V49.00.242.00        (((  ]̀̑ (|         | (   ! ! !(!  ,    ,NSOFTWARE\Microsoft\Microsoft SQL Server@ !  !@ @48ConfigurationDsn ConnectionStringConnectionTypeLogonUserLogonDomainLogonCredKey ValueDefaultUserNameType% % 4 8(4(8  HHP PX  |)  P' -h @    ?_ :  1 1 1      (( 5 5 p(5t  t     ((t9 9    (9      !"#$%&'()*+,-./0123456789:;<=>?ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~= A A Hhttp://sqlreli/sqmtest/sqmserver.dllhhttp://sqm.microsoft.com/sqm/SQLServer/sqmserver.dll|x t  E I                         MM         Q  U  Q y$$RSA1''6n_1:fl/y2}/R4H<=\]Ǽ(k,Q\$+Au2IRmRo{l؂O1 ˢ#V{-Pb왹J|};(                          !5     % - 1 5 = A I Q1 )9EM  U ] e ) m u          > Yaiqy      .     0!= ! =                        '-    ,   !  ,   ,)=                     ====                 "  = =  9 999 9 9   =@  =@@=!=!@!@ = A #== !! UY]ae aQa% i qu m4      |l    \T      1     -          Item p x =I I    MM    QUY]    e     A ee   x  p  I E II !Sql Server SQM Module 9.00.4035.00xsMicrosoft® is a registered trademark of Microsoft Corporation. Windows(TM) is a trademark of Microsoft Corporation,'© Microsoft Corp. All rights reserved.Microsoft SQL ServerMicrosoft CorporationTWrapNonExceptionThrows+I#RSDSȄJvHLSqlSqm.pdb _CorExeMainmscoree.dll% @0p0eH`x         `H(ph(hZ  SQL Sqm 4VS_VERSION_INFOZ ?DVarFileInfo$Translation StringFileInfo040904E4(PlatformWindowsLCompanyNameMicrosoft CorporationLFileDescriptionMicrosoft SQL SQMBFileVersion2005.090.4035.00.InternalNameSQLSQMr'LegalCopyright Microsoft Corp. All rights reserved.sLegalTrademarksMicrosoft is a registered trademark of Microsoft Corporation. Windows(TM) is a trademark of Microsoft Corporation> OriginalFilenameSQLSQM.EXEJProductNameMicrosoft SQL Server> ProductVersion9.00.4035.00(CommentsWindows( @'"r6#cb6'sscbr6#xw&w3''6(zx#v:rc/zw3xpcrx{'7s87&sxwscw8wxzr8w7xrx8rw7jzz1ssss5373s9sq7757w117w;Wws53w1x{xwp{yy3{x8{wys77swsys8{{{wy79wwxp;s7878wp8pxxp;p{{w?( '#"ssb60s67 s  s0 zzzps31{yq7x0y139ws17{03sp( @3333f33f33fff3fffff333ffffff3f3ff̙3ff̙            "      """    ""   "#" # ! #  #  #        ##   ##  ##               ?(  Pc*r% }*1!l0/e<3b?(t6*t8K!T&T'Z)Z^|cH+(2GWdwuQ^^{gTNfzz^^^^^^r^( @ 333f33f33f33f33f33f33f33f33f33f33f33f33f33f33f333ffff3f3f3f3333333333333333333f333ffff3f3f3ffff3f3f333f333f333f333f̙ff3f33f33fff333f333f33333f333f̙3f33f3ff3ffff3f33f3f333f3ff̙3f3333333f333f333f33fff̙f̙333f333f33f3fff3f̙f̙ff3fff333f3f3fffff̙̙f̙ffff3f333f3fffffff̙̙ff3ffffff3f3f3fffff̙̙f̙ffff3f3f3ffffff̙̙f̙ffff3f3f3ffff̙̙̙̙̙̙̙̙̙̙̙ffff3f3fffffff3f3ffffffffffffffffffff33ff33ff333333fff3ff3f3f3ff3f3ff3f3f3f3f3f33ff3ff3f3ff3f3ff3f3f3ff3f3f3f33ff3ff3f3f3f3f3f3f3fff3f3f33ff3fffff3ff3f3ff3ff3fff33ffff3f3f33fffff3f3f3fff33fffffff3f3fff3f33ffffffff3f3fffffffffffffff3f3f3f3f3fffffffffffffffffff3f3f3f3f3f3f3f3fffffffffffffffff33f3f3f3f3f3f3f3fffffffffffffffff3f3f3f3f3f3fffffffffffffff3333f3f3ffffffffffffffff333ffffffffffffffffffffffffffffffffffffffffff?(  @Rj8E+~8n-!n0f']! P5zRjax5vE3b?751r%KK@RjYn3b?/e<-v@EW -KMRjݐYn3b?| }*FQRjYnYn5UyeVRjzό׬%?[xRjZk]adhdhdhdhdhdhdh?HKloK \Ao"rYU/g&TaofEUBuxxxxxx{x ( h   h 0`0N *H ?0;1 0 +0h +7Z0X03 +70% <<<Obsolete>>>0!0 +PοNj,G*00<<>c@0  *H 0p1+0)U "Copyright (c) 1997 Microsoft Corp.10U Microsoft Corporation1!0UMicrosoft Root Authority0 970110070000Z 201231070000Z0p1+0)U "Copyright (c) 1997 Microsoft Corp.10U Microsoft Corporation1!0UMicrosoft Root Authority0"0  *H 0 p;N(x^0ꢩ%_L >|Q`2kBdyvT뜆fkzb#<Ŀ-fh&:, X&F >8,(9IBlUa|`-wL陴d;P1$+=c`Xe7RӿUE:TNzmtN̖ (!W`i7Kc@0  *H  5$w\`2 >:!W,Gb;;Z6Ti$m?̪|1=pjOiCZ Ob{+7%-e%cT!RnC2gl QRǽ0 1 )M[WeIRT(~ū7,zwvj?6A5jj5EZ38nM b T?FUp:uҠ0`0L .P\0 +0p1+0)U "Copyright (c) 1997 Microsoft Corp.10U Microsoft Corporation1!0UMicrosoft Root Authority0 070822223102Z 120825070000Z0y1 0 UUS10U Washington10URedmond10U Microsoft Corporation1#0!UMicrosoft Code Signing PCA0"0  *H 0 y}]E941%5IwEqFԌkLRbMIl/$>e# HuEP%+ #A$bEJͳ/"J-|o;99ݽ)f;-2'Hlc\򸔣8P'N0==l9.4. }bxfs Oc,2EJ;PSfQyV>Pn5{$Rf=N+~3nGўJnS00U% 0 +0U0[pir#Q~Mˡr0p1+0)U "Copyright (c) 1997 Microsoft Corp.10U Microsoft Corporation1!0UMicrosoft Root Authority<<>c@0U00Uvp[NQD.Dc0 U0 +{~J&μNtX't*uLxMi|CʇSŸVocDDȚ  )}s9=j8m҈#i 4|.)Bk(q8 ]hͽAkf4|zB{ p֒O8|-=4 b7j#\cZ9`U3; _,˫ 0  *RA^0(ip΀Brv0j0R axM0  *H 0y1 0 UUS10U Washington10URedmond10U Microsoft Corporation1#0!UMicrosoft Code Signing PCA0 070823002313Z 090223003313Z0t1 0 UUS10U Washington10URedmond10U Microsoft Corporation10UMicrosoft Corporation0"0  *H 0  Iͪ:4#Ykl!"ꮿ&2],6V+ n(L?A@F فWDv\t3ta~E>հ^ { `j(ub]:![sE㕉w`w73/bɮOg 90qgF PtA/$j!kIIJ9Bm\J׎>x Gؤ#{fJt&AKa`N0Ȃ p|UMwUv00U0U!@|QTKj4.&0U% 0 +0U#0vp[NQD.Dc0DU=0;09753http://crl.microsoft.com/pki/crl/products/CSPCA.crl0H+<0:08+0,http://www.microsoft.com/pki/certs/CSPCA.crt0  *H @WoSg 4K<؁ ytwOGi~bg()UיP^ oY Ӌ> EG&`W K̺MnH(5!r_i$4 ~no R*LI2,]&<[ 5OEGYxWN򭜚A\$>4GN{ɜcS׿Ϡz+,lڿ8\ʀݐ#簡L>&x,kǏ<00 aI|0  *H 0y1 0 UUS10U Washington10URedmond10U Microsoft Corporation1#0!UMicrosoft Timestamping PCA0 060916015522Z 110916020522Z01 0 UUS10U Washington10URedmond10U Microsoft Corporation1'0%U nCipher DSE ESN:10D8-5847-CBF81'0%UMicrosoft Timestamping Service0"0  *H 0 cyD>L$9v 2JXx+٥=&|}~2=97;4Ԓ4hrLฅ3 vs5L]J}xBFq'WуO;?aK0U#0oN?4K;AC0DU=0;09753http://crl.microsoft.com/pki/crl/products/tspca.crl0H+<0:08+0,http://www.microsoft.com/pki/certs/tspca.crt0U% 0 +0U0  *H iz F.4z'(A*!_S^)TJ} Mn(E,92o7Z#RT?d86C:> q(f1\]RR\듐i LvL4 j|D+[TE$%ĊF%i)",F^+w>#odb ->IZt9ΣּȭV<*D?}fͲ c @=e2|=&HN"n000j O%EXzg0  *H 0p1+0)U "Copyright (c) 1997 Microsoft Corp.10U Microsoft Corporation1!0UMicrosoft Root Authority0 060916010447Z 190915070000Z0y1 0 UUS10U Washington10URedmond10U Microsoft Corporation1#0!UMicrosoft Timestamping PCA0"0  *H 0 7nBJqH>S,2ORȃ>3I1(dPKuǨծipfx'f趷 Y")/@VvmdmJT޿ǀL7VhGv\/}%V[jc|<%M9wt]\؆7,u9 |vlnz>q_*Ob`2҃N+"\hE/Pl%ׅvs6ƕz`3[AXn,HoCj&k(0$0U% 0 +0U0[pir#Q~Mˡr0p1+0)U "Copyright (c) 1997 Microsoft Corp.10U Microsoft Corporation1!0UMicrosoft Root Authority<<>c@0 +70UoN?4K;AC0 +7  SubCA0 U0U00  *H M1|PapEsT? -QS9V ތ;ɷQ!oi~k"Flm|"Fӄ6~p]Eݎ*|ɮ2Շc6!v;s!شTeJ(&`;exHϭ:ObX099!dcC/{FeJtn ̝(a|H!8Ŗ2@S=f7"̰wTQ:rD#1000y1 0 UUS10U Washington10URedmond10U Microsoft Corporation1#0!UMicrosoft Code Signing PCA axM0 +0 *H  1  +70 +7 10  +70# *H  1z׼_!|StMt u0Z +7 1L0J*(Microsoft SQL Serverhttp://www.microsoft.com/ 0  *H o$Ğ|POoV=dCdåc >E\z0Ѧ#M*\)+X.K@wy iNILШ9=#ft=D 0 ;WG { g4=O3^FU%8( >_\,Cl3kiAP~lDoYh }sm$V5Rz[FW '~8)Edh؍Y򲢭a YKױڧ/4GJ\-0 *H  1 000y1 0 UUS10U Washington10URedmond10U Microsoft Corporation1#0!UMicrosoft Timestamping PCA aI|0+]0 *H  1  *H 0 *H  1 081125062354Z0# *H  1y 5>'.Q 0  *H  wflզ`j0S$ 7Pu|R <)\7ݺUȻ^"sLBtd&DDQ3T_.k,(@sryߟ-3,`aͺto<LFo-,^KSR@t^œt-?|IyYŀr#{^՞Qt$fc:i