| Server IP : 209.209.40.120 / Your IP : 216.73.217.112 Web Server : Microsoft-IIS/10.0 System : Windows NT NEWWWW 10.0 build 17763 (Windows Server 2019) i586 User : NEWWWW$ ( 0) PHP Version : 8.3.30 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/Program Files/Microsoft SQL Server/MSSQL15.MSSQLSERVER/MSSQL/Binn/ |
Upload File : |
MZ� �� � @ � � � �!�L�!This program cannot be run in DOS mode.
$ PE L �i � " 0 n @ ` �� `� O 8 0 (( @ � H .text t� `.rsrc 8 @ @.reloc @ @ B P H T� 8 O d� # d � {4
* {5
* {6
* {7
* {8
* {9
* {:
* {;
* {<
* {=
* {>
* {?
* {@
* {A
* {B
* {C
* {D
* {E
* {F
* {G
*0 � (H
}4
}5
}6
}7
}8
}9
}:
};
}<
}=
}>
}?
}@
}A
}B
}C
}D
}E
}F
}G
*0 u
9 (I
{4
{4
oJ
9� (K
{5
{5
oL
9� (M
{6
{6
oN
9� (O
{7
{7
oP
9� (Q
{8
{8
oR
9� (S
{9
{9
oT
9g (U
{:
{:
oV
9L (W
{;
{;
oX
91 (Y
{<
{<
oZ
9 ([
{=
{=
o\
9� (]
{>
{>
o^
9� (_
{?
{?
o`
9� (a
{@
{@
ob
9� (c
{A
{A
od
9� (e
{B
{B
of
,w(g
{C
{C
oh
,_(i
{D
{D
oj
,G(k
{E
{E
ol
,/(m
{F
{F
on
,(o
{G
{G
op
**0 � s �� )UU�Z(I
{4
oq
X )UU�Z(K
{5
or
X )UU�Z(M
{6
os
X )UU�Z(O
{7
ot
X )UU�Z(Q
{8
ou
X )UU�Z(S
{9
ov
X )UU�Z(U
{:
ow
X )UU�Z(W
{;
ox
X )UU�Z(Y
{<
oy
X )UU�Z([
{=
oz
X )UU�Z(]
{>
o{
X )UU�Z(_
{?
o|
X )UU�Z(a
{@
o}
X )UU�Z(c
{A
o~
X )UU�Z(e
{B
o
X )UU�Z(g
{C
o�
X )UU�Z(i
{D
o�
X )UU�Z(k
{E
o�
X )UU�Z(m
{F
o�
X )UU�Z(o
{G
o�
X* 0 r p � %{4
� � -q � -&+ � o�
�%{5
� � -q
� -&+ � o�
�%{6
� � -q � -&+ � o�
�%{7
� � -q � -&+ � o�
�%{8
� � -q � -&+ � o�
�%{9
� � -q � -&+ � o�
�% {:
�
� -q
� -&+ � o�
�% {;
�! �! -q! �! -&+ �! o�
�% {<
�" �" -q" �" -&+ �" o�
�% {=
�# �# -q# �# -&+ �# o�
�%
{>
�$ �$ -q$ �$ -&+ �$ o�
�% {?
�% �% -q% �% -&+ �% o�
�% {@
�& �& -q& �& -&+ �& o�
�%
{A
�' �' -q' �' -&+ �' o�
�% {B
�( �( -q( �( -&+ �( o�
�% {C
�) �) -q) �) -&+ �) o�
�% {D
!�* !�* -q* !!!�* -&+ �* o�
�% {E
""#�+ #�+ -q+ ###�+ -&+ �+ o�
�% {F
$$%�, %�, -q, %%%�, -&+ �, o�
�% {G
&&'�- '�- -q- '''�- -&+ �- o�
�(�
* {�
* {�
* {�
* {�
* {�
* {�
* {�
* {�
* {�
* {�
* {�
* {�
* {�
* {�
* {�
* {�
* {�
* 0 � (H
}�
}�
}�
}�
}�
}�
}�
}�
}�
}�
}�
}�
}�
}�
}�
}�
}�
*0 � u.
9� (I
{�
{�
oJ
9� (K
{�
{�
oL
9� (M
{�
{�
oN
9g (O
{�
{�
oP
9L (Q
{�
{�
oR
91 (S
{�
{�
oT
9 (U
{�
{�
oV
9� (W
{�
{�
oX
9� (Y
{�
{�
oZ
9� ([
{�
{�
o\
9� (]
{�
{�
o^
9� (_
{�
{�
o`
,w(a
{�
{�
ob
,_(c
{�
{�
od
,G(e
{�
{�
of
,/(g
{�
{�
oh
,(i
{�
{�
oj
** 0 � : P )UU�Z(I
{�
oq
X )UU�Z(K
{�
or
X )UU�Z(M
{�
os
X )UU�Z(O
{�
ot
X )UU�Z(Q
{�
ou
X )UU�Z(S
{�
ov
X )UU�Z(U
{�
ow
X )UU�Z(W
{�
ox
X )UU�Z(Y
{�
oy
X )UU�Z([
{�
oz
X )UU�Z(]
{�
o{
X )UU�Z(_
{�
o|
X )UU�Z(a
{�
o}
X )UU�Z(c
{�
o~
X )UU�Z(e
{�
o
X )UU�Z(g
{�
o�
X )UU�Z(i
{�
o�
X* 0 B r< p � %{�
� � -q � -&+ � o�
�%{�
� � -q
� -&+ � o�
�%{�
� � -q � -&+ � o�
�%{�
� � -q � -&+ � o�
�%{�
� � -q � -&+ � o�
�%{�
� � -q � -&+ � o�
�% {�
�
� -q
� -&+ � o�
�% {�
�! �! -q! �! -&+ �! o�
�% {�
�" �" -q" �" -&+ �" o�
�% {�
�# �# -q# �# -&+ �# o�
�%
{�
�$ �$ -q$ �$ -&+ �$ o�
�% {�
�% �% -q% �% -&+ �% o�
�% {�
�& �& -q& �& -&+ �& o�
�%
{�
�' �' -q' �' -&+ �' o�
�% {�
�( �( -q( �( -&+ �( o�
�% {�
�) �) -q) �) -&+ �) o�
�% {�
!�* !�* -q* !!!�* -&+ �* o�
�(�
* {N *"}N * (H
*Z(H
}Q }R * {O *"}O * {P *"}P * {Q *"}Q * {R *"}R * {� *"}� * {� *"}� * {� *"}� * {� *"}� * {� *"}� * {� *"}� * {� *"}� * {� *"}� * {� *"}� * {� *"}� * {� *"}� *V(H
}� }� * {� *"}� * {� *"}� * {� *"}� *6~� o�
*.~� o�
*�s�
%s�
%o�
o�
%jo�
(^ * 0 @ (�
o�
o�
r� p(�
(�
o�
%-r� p(�
sa z(^ *0 � � (�
s�
o�
t �
r' p o�
o�
(�
sa zs�
o. +H�o6 o�
-
s�
o�
o�
o2 o4 o�
X�i2�* ! + 0 f ~� o�
, ~� o�
*(�
o�
o�
r� p(�
(�
o�
s�
o�
�,o'
�,o'
� * G P
@ Z
.s�
�� *"(�
*s�
** {� *"}� * {� *"}� *� � }� (d (f (h *&(k * 0 s�
r} p{� ( }� (e s�
o�
r� ps�
o�
&�
,o'
��8
o�
H .
o�
&H 3 zr� p o�
�� (�
sa z(�
-'o�
� r po�
�� (�
sa z s�
(g o�
o�
8� s�
8z o�
o�
~�
3 ~�
o�
8! o�
�2 (�
(�
,* o�
�2
(�
(�
o�
8� o�
�3 (�
(�
,* o�
�3 (�
(�
o�
8� o�
�4 (�
(�
,' o�
�4 (�
(�
o�
+Xo�
Г (�
(�
,' o�
��
(�
(�
o�
+ o�
o�
o�
rW po�
, o�
(l o�
Xo�
?x���o�
o�
{� / o�
:G���o�
-�� ,o'
�� ,o'
��Ere po�
�� (�
sa z(�
-o�
3 r� po�
�,o'
�* A� ; D
) ' P 8 0 � � 0 � � � � � � � � 0 � " � ) � �
0 _ -~�
s�
s�
(�
o�
�io�
�
,o'
�o�
(�
�,o'
�o�
� * ( 3
:K
JU + Rs�
}� (i *^r� p(j ( +}� * 0 p s�
{� o�
+A(�
r� po�
(k o�
�
s�
%r� p o�
o�
o�
� (�
-���2 o'
�* & 6 N` 0 t s�
}� ~�
}� ~�
}� ~�
}� s�
}� (i r p(_ }� {� (w
o�
}� o�
}� *0 �
o�
o�
r< p(�
9� s�
rP p(j o�
1o�
ru po�
(s +s�
%r� pr� po�
o�
(r �)
s�
%r� pr� p o�
(�
o�
o�
� *(t * o w )+ 0 9 r� p
{� {� o�
-{�
(e (u {� }� * 0 ;
(�
r p(�
o�
o�
8 o�
%X
� 2� s�
r p(�
o�
o�
+Ho�
%r� p(�
o�
o�
o�
r p(�
o�
( +o�
o�
o(
-�� ,o'
�r* p(�
o�
o�
+Ho�
%r� p(�
o�
o�
o�
r p(�
o�
( +o�
o�
o(
-�� ,o'
�r� p(�
o�
o�
o�
r8 p(�
o�
o�
o�
r� p(�
{� o�
9� {� o�
oA
8r
�oN �i�� +.�~�
� o�
,
o�
�X�i2�oP oV ~�
o�
,
o�
oP oT sx %oz %o| %o~ %oG o� %�
o�
o� %oP oV o� {� o�
-ks� E / & +4s� ++s� +"s� +s� +s� +s� {� o�
{� o�
o�
X
�i?����o(
:��
,o'
�* AL W U � � U $ 0
0 J s�
{� o�
o�
8� (�
s�
rH poy o�
rR po o�
o rz p(�
, r� po� o�
r� po� o�
s�
+C r� p�� (�
o{ �o�
r� p�� o} �o�
&Xo{ �i2� r� po�
o�
r� p{� o�
o� o�
o�
(�
: �����9 o'
�{� o�
~�
}� (v * A 0 R s�
o�
r� ps�
o�
&�
,o'
�s�
o�
&�,o'
�,o'
�* ( "
4 =
@G
0 U r p{� ( }� {� (w
o�
}� o�
}� � r po�
(�
sa z* == + 0 l � (�
s�
s�
s�
%o�
o�
jo�
o�
t �&s�
� s�
rb ps�
o: 8� �oC o�
oE o�
r� p
(�
o
o? o= r� p
o�
& (�
-o
&r p o
& (�
- o
&r# p o�
o
&rM p( +o
&o
&o
&X�i?,���rQ po
&o
&o�
s�
** 2 A + {� *"}� * {� *"}� * {� *"}� * {� *"}� * {� *"}� * {� *"}� *2o�
o
* 0 H r p�� %(y �%(� �%( �%(� �%r p({ (
�(
*6u (� *^,o�
o�
(�
** {� *"}� * {� *"}� * {� *"}� * 0 ' (d s4
oA (� (� (� *f(� r po�
(� * 0 � s�
(� s
o
(�
-o
o�
r
po�
9� s�
o�
o
r p(�
-r0 p(�
-R8� s~
rH p ol o�
r^ p on o�
rn p op o�
r� p ot o�
+\s~
r� p or o�
r� p ov o�
r� p ox o�
r p oz o�
r& p o| o�
o�
�� s
(� o
o
o
s
o
o
Y��
o
o
+| o+
tE o
o
rN po
o
s
o
o�
o
o
o
~� o
o
,
o
o
Y� o(
:x���� uF ,o'
�o
o
>� 8� rd p8� 1rf p(�
,_
�-X �� %�%rr p�%o
o
o
�%rv p�%o
o�
(D �%r� p�(
+L � %�%rr p�%o
o
o
�%rv p�%o
�%r� p�(
Xo
o
Y?$���o
�,I�o
o
Y�o
o
Yo!
o�
("
jX(#
o$
8� o%
+@,%
�- o
o�
(D o$
+o
o$
Xo&
Y2�o&
Yo&
Yo
o$
o
o'
o(
:'���+:+Xo(
-�o%
�� o$
o
o'
o)
o*
o
o
+` o+
tE s�
+.o
o
o
o!
o�
o�
Xo
o
2�o�
o(
-��+ uF ,o'
�,o'
�,o'
�* Ad x � a m � / � � � �
0 @ (+
s,
%r� po-
&%r� po-
&%r� po-
&%r� po-
&�� *&(� * 0 � s�
r� p(� ( +o�
+v(�
r� po�
r� pr� pr� p(�
o.
(� r po�
(� o�
+(�
o�
(�
-���2 o'
�(�
-���2 o'
�* j � �� {� *"}� * 0 � r� p(/
}� s0
}� s1
}� s2
}� s2
}� s2
}� s3
}� s4
}� s4
}� s5
}� s2
}� s2
}� s6
}� s�
}� (d {� (7
(8
}� }� (� �� s9
(:
&# $@(;
(<
* 0 " r p{� �� (=
(>
�&� * + 0 �
{� (?
,5{� (@
~] %-&~\ �� sA
%�] ( +( +
� {� -oD
(� }� � 9j ( + � 2e(� ,]{�
(F
s�
rA prU po�
r p( +(7
o�
{� o�
�
,(G
�8� �sH
oI
�&ݹ ,oJ
� sK
oL
8a
oM
(� 9� ~�
�G ~�
~�
j oN
o-
8 o+
tK oO
(� ��;�5@ �mcL5 ��/.t �mcL; 8� ,�Ǭ;� ��;�;� 8� �;�5 D�;�.v �;�.W8z j�;�.3 ����;� a���;� 8T rA p(�
:� 8> r� p(�
:� 8( r� p(�
:� 8 r� p(�
:� 8� r� p(�
:� 8� r� p(�
:� 8� r� p(�
:� 8� r p(�
:� 8� r p(�
:� 8� oP
t� +~oP
��
+noP
�� +^oP
�� +NoP
�� +>oP
�G +.oP
t� + oP
t� +oP
�� o(
:��uF ,o'
� (� ��5C �fV�5 _�M;� �fV�;� 8� ���;� ��;� 8� +�o�5 ��;� +�o�.g8n �h�. ���.: 0���.s8N r/ p(�
:� 88 rO p(�
:� 8" rm p(�
:� 8 r� p(�
: 8� r� p(�
:0 8� r� p(�
:- 8� r� p(�
:z 8� r� p(�
:� 8� r# p(�
: 8� {�
( +8t {�
( +8_ {�
(F
{� oQ
,-{� oR
oS
-2{� oR
oT
&+{� sU
%oT
&oV
�� ,(G
�{� ( +{�
( +{� ( +8� {� ( +8� {�
(F
s�
rA p o�
rW po�
rk p
(7
o�
{� o�
�J ,(G
�{�
(F
s�
rA p o�
rk p
(7
o�
ry p(7
o�
r� p(7
o�
{� o�
�� ,(G
�{� (
+{� ( +{�
( +{� ( +8� {�
(F
sW
{� oX
,-{� oY
oS
-2{� oY
oT
&+{� sU
%oT
&oZ
� , (G
�{�
(F
s�
rA p o�
r p
(7
o�
{� o�
ݶ ,(G
�{� ( +{� ( +{� ( +{� ( +{� ( +{� (
+{� ( +{� ( +{� ( +{� ( +{� ( +{�
(F
{� o[
�
,(G
�
o(
:�����
,
o'
�� , o'
�(\
�&� X�i?���# $@(]
(<
8���AT D F + � J �
� L �
} � : e � � P E
X h �
p � � B �
p �
) t � � � � � + 0 @
(F
o^
, %o_
Xo`
�o`
�
,(G
�* 15
0 L
(F
oa
,ob
( +�&s2
oc
ob
od
�
,(G
�* =A
0
(F
oe
�
,(G
�*
0 �
{�
(F
{�
s�
}� � ,
(G
�{� (F
{� s6
}� � ,(G
� of
+](g
s�
rA pr� po�
r� p(h
o�
o�
r p(i
(7
o�
o�
(j
-���I o'
�{� (F
{� s2
}� � ,(G
� ok
+a(l
s�
rA pr� po�
r p(m
(7
o�
r p(n
(7
o�
o�
(o
-���K o'
�{� (F
{�
s2
}� � ,(G
�
ok
+a(l
s�
rA pr# po�
rk p(m
(7
o�
r p(n
(7
o�
o�
(o
-���K o'
�{� (F
{� s5
}� � ,(G
� op
8� (q
(r
ok
+}(l
s�
rA prU po�
rk p (s
(7
o�
r� p (m
(7
o�
r p (n
(7
o�
o�
(o
:w�����K o'
�(t
:B�����M o'
�{� (F
{� s1
}� � , (G
�ou
+] (v
!s�
""rA prm po�
"rW p!(w
o�
"r p!(x
oy
(7
o�
"o�
(z
-�� �O o'
�{� ##(F
{� s0
}� � ,#(G
�o{
$+i$(|
%s�
&&r� p%(}
o~
o�
&r� p%(}
o
o�
&r p%(�
oy
(7
o�
&o�
$(�
-��$�Q o'
�{� (F
{�
s2
}� � ,(G
� ok
+a(l
's�
((rA pr� po�
(r p'(m
(7
o�
(r p'(n
(7
o�
(o�
(o
-���K o'
�{� (F
{� s2
}� � ,(G
�ok
+a(l
)s�
**rA pr po�
*r p)(m
(7
o�
*r p)(n
(7
o�
*o�
(o
-���K o'
�{� (F
{� s2
}� � ,(G
�ok
+a(l
+s�
,,rA pr3 po�
,rk p+(m
(7
o�
,r p+(n
(7
o�
,o�
(o
-���K o'
�{� --(F
{� s3
}� � ,-(G
�o�
.+a.(�
/s�
00rA pr� po�
0r� p/(�
11(#
o�
0r p/(�
(7
o�
0o�
.(�
-��.�S o'
�{� 22(F
{� s4
}� � ,2(G
�o�
38� 3(�
44(�
ok
+t(l
5s�
66rA pr/ po�
6rW p4(�
o�
6rS p5(m
(7
o�
6r p5(n
(7
o�
6o�
(o
-���K o'
�3(�
:N����3�U o'
�{� 22(F
{� s4
}� � ,2(G
�o�
38� 3(�
77(�
ok
+t(l
8s�
99rA prO po�
9rW p7(�
o�
9rS p8(m
(7
o�
9r p8(n
(7
o�
9o�
(o
-���K o'
�3(�
:N����3�U o'
�*A� . K b � � j � 6 K n � � � n s � � � � h � � � � � � j 8 Q n � v � . B n � � � � n j � � � n $ = [ p n � � F � � * � � � K � � / � � (� *0 � s�
o�
o�
r] p(�
-%rw p(�
:� r� p(�
: 8: {� {� (� o�
s�
%o�
o�
o�
� rd pu� ,Ou� o�
o�
o�
+ o�
r� po�
(�
o(
-��,o'
�o�
s�
%o�
o�
݈ r� p r� p (�
o�
�&� (�
o�
�&� s�
%r� po�
o�
s�
%r� po�
o�
++~� (�
s�
% o�
o�
+ r! psa z*4 � +� F 9 �+
, 0 C rd p
(B -rw! p~�
(
+r�! p~�
(
r�! p(B o> * 0 I }b }` }a (�
}_ }^ {_ ( + |_ (�
* 0 I }i }h }g (�
}f }e {f ( + |f (�
* 0 � s�
%s� %r " po� %r-" po� o�
%s� %r�" po� %r�" po� o�
%s� %r
# po� %r# po� %s�
%r�# pr�# po�
%r�# pr�# po�
o� o�
%s� %r�# po� %r�# po� %s�
%r�$ pr�$ po�
o� o�
}� s�
%r�$ pr�$ po�
}� (d *.s4 �� * {� *"}� * {� *"}� * {� *"}� * {� *"}� * {� *"}� *0 � (H
s�
(� s�
(� r�$ po�
s�
}� {� jo�
{� jo�
{� jo�
{� !�������o�
s�
}� s�
}� {� r$% ps�
o�
{� r>% ps�
o�
{� rb% ps�
o�
(�
}� *�(� o�
,
(� o�
*r�% p(�
sa zZ �s� %}n %}p *v �s� %}v %}x %}} *
*Nr�% p(�
( * 0 8 o�
(�
,*(� r�% p(�
r�% p~�
r�% ps� *0 �
(� o�
o�
+](�
(�
,{� (\ o�
�
� {� o�
-%r�% p(�
{� (] o�
�
� (�
-���c o'
�,r�% po�
(�
sa z* ( ( < + Z o + j} 0 ` !
r$& p r8& p rZ& p(�
,D s�
o�
rZ& p(� 1" o�
(�
-r�& po�
,
*0 P " rd p
r$& p r�& p rZ& p(�
,0 s�
o�
rZ& p(� 1 o�
(�
* {� *"}� * {� *"}� * {� *"}� * {� *"}� * {� *"}� * 0 # �� %r�& p�%r ' p�%r@' p�}� (� r`' p(� (� rt' p(� }� (�
- (� r�' p(� (�
(� + r�' p(� (� (�
r�' pr( p(�
(� (�
si
(� r.( po�
(� �
o�
o� � (�
sm (� rN( po�
(�
sp (� rx( po�
* � � + 0 L o* o� o� (�
-o� +o. o� (� o� (� o� (� *0 a $ r�( p
ob o�
+2(�
r� po�
rA) po�
,r po�
( �(�
-���2 o'
�* ?R 0 p %
(� ,(� (�
-*r8& pru) p( r p(�
(B ,(�
+r8& po� ru) po�
,{� -o� +`**v �s� %}� %}� %}� *2r�% po� * 0 " ry) pr�) p(�
(�
-(D ** 0 8 &
,.+
+
3
r�) p(�
(� (�
�&� * # 4 + 0 7 rd p
(� (�
-(� *(B ,(�
+ r�& po�
*6r�) p(� * 0 ^ ry) pr^ p(�
(�
,*r�) prM p{� (
( �� % ,�o�
}� {� (�
( +* 0 A ' (�
(�
r!* p(�
(�
�(6 �
o�
o� � * -- + 0 , (� (�
-(� +r�' p
�r{* p(6 *0 � ( rd p
(� ,$(�
-r�* p(=
8� r + p
8� rZ& p(�
,q s�
rY+ pri+ pry+ po�
rZ& p(� &o�
ry+ p(�
,3o�
(�
,$1 �� /r�+ po�
(=
(�
(�
-r�+ p(�
+
* 0 S )
(� r�+ p (�
r�+ p(�
� (6 ru) po�
-+
�o�
o� � * =? + &(� * {� *"}� * {� *"}� * {� *"}� * {� *"}� * {� *"}� * 0 8 &
,.+
+
3
r�) p(�
(� (�
�&� * # 4 + 0 � * (� rO, p(� (� �( o�
(� (� (� (� ,(� (� (� +B~�
(� (�
-/(�
r�+ p(�
(� r�' p(� (�
(� (�
r�, pr( p(�
(� (�
s�
(� r�, po�
(�
s� (� r�, po�
*nr8& p(� ru) po�
-**2r�& p(� * 0 v )
r#- p (�
-+r�' p (�
rM- p(�
o�
o�
o�
�� (�
� (6 ru) po�
-+
�o�
o� � * `b + 0 _ + r�- p
(�
-+r�' p (�
r�- p(�
o�
o�
o�
�� (�
�(6
~�
(�
, **v �s� %}� %}� %}� *2r�% p(� * 0 f , (� (�
-(� +r�' p
�r`. p(6 (�
r�. p(�
�(6
�o�
o� ~�
� * LL + {� *"}� * {� *"}� * 0 e - (� (�
o�
o�
o�
(� r p(� �� (=
(� (� s� }� (� r8/ p{� o�
* 0 ^ . (�
rT/ p(� �� (�
~�
�r8& p(6 �
o�
o� � ru) po�
{� o� * ! 4 + 0 6 &
,.+
+
3
r�) p(�
(� (>
�&� * # 2 + 0 F / (�
rT/ p(� �� (�
~�
�r�& p(6 � o�
o� � * ! 4 + {� *"}� * {� *"}� * {� *"}� * {� *"}� * {� *"}� * {� *"}� * 0 � (H
(� (D (� r p(� r p( r�/ po�
-
r�/ po�
,ru) p(� ru) p( +#r�/ po�
,r p(� r�/ p( �� %o\ �%r p�%oZ �%r p�%(� �(
(� *
*> �s�
%}�
*~r�/ p}� ( s�
}� *V~� ! � o�
* 0 O 0 o� ( +o�
8! o�
{� o�
~�
o�
`� 1(�
�G o�
8� `� o�
Y(�
o�
{� (� (� o^ (� od (� o` (� ob o� o� o� r�/ p(�
o� ( o� (� (G (� (� s�
~� o� r�/ p(�
~� o + `� Xo�
?#���o(
:����
,o'
�* A 3 D
0 B 1 r0 ps� �� �b (�
! � (�
(�
�� *�(�
o�
rD0 po�
(�
o�
%~� �� s�
o�
&o�
* 0 4 ( s�
}� {� o�
jo�
{� o�
(�
rd po�
{� r�0 po�
{� o�
o�
(� o^ o�
{� o�
o�
(� (G o�
{� o�
o�
(� o�
{� o�
o�
(� od o�
{� o�
o�
(� o` o�
{� o�
o�
(� ob o�
{� o�
o�
( o�
s�
}� *0 � 2 o� ( +o�
8� o�
{� o�
{� o� s�
%r�0 pr�/ po�
%r 1 po� o�
%r,1 po�
(�
(�
o�
%rH1 po� (�
(�
o�
%rl1 po� �i o�
o�
%r�1 po�
o�
o(
:@����
,o'
�{� o�
* ��
{� *"}� *:(H
(
*�o�
(�
rd po�
( o�
*�~�
}� ~�
} ~�
} ( s�
} * 0 x 3 (
{ ( rM p s�
o�
-rr p + o�
jYo�
�
, o'
�r�1 p(�
(�
(�
�o�
} � * " !C
Rf + R{ }� } * 0 C 4 { (�
,*{ (
(�
�,o'
�
o�
} � * " &
0 + �{ {� (�
,~�
*{ * 0 % 5 (�
r�1 p(�
r�1 p(�
(8
* 0 � 6 (� (G (� (� r�/ p(�
r�1 p(�
(� o` o� o� (� o^ (� od (� ob ( o� o� o� o� o�
o� s�
{ o�
(�
(�
*�~�
� ~ o�
~
o�
� ~ o�
* 0 / -r�1 p+r�1 p(�
(
-*-*( * 0 U 7 (�
(�
(
(�
0r2 p(�
($ � �
rr2 p o�
(�
($ � * $8 + 0 ` 8 -r�2 p(�
($ �� rM p(
(
�� % ,�o�
� r�2 po�
(�
($ � * . B + 0 J o�
(" ~ o
,~ o
o�
*~ o
1rH3 p(�
($ *F(
o�
(�
*0 #
(
(
o
� o�
($ � * + 0 S ~
~� %-&~� �� s
%�� ~� %-&~� �� s
%�� ( +~
o�
*~ * � * 0 � 9 (
ti
~ ,o
rj3 p~ o
�' s
o
o
tj o
r�3 po
� o
s�
o�
� , o'
�,o'
�,o'
�*( i
s
b }
F A�
0 � : (�
~ (
(
# @4* r�3 ps�
r-4 p(: o�
rC4 pr( po�
rK4 p~ o�
rY4 pr_4 po�
ro4 pr�4 ps4 o= (�
o�
(# (�
%($ (! s�
o
tk r�4 po
tk � �#
r�4 p o�
(�
($ � (�
� �* $ �� + $ �� 0 ` ; r�4 ps�
o
+,(
r�4 p(
(
(
(
o�
&(
-���n o'
�o�
* 9K �~
o
2*~
j~� %-&~� � s
%�� o
&*�� r�4 p� ~�
� s
� s
�
* 0 B < �J }� ~
}� ~� }� o
s ( �*f,*,o!
-*(& * { *"} * { *"} * {
*"}
* { *"} * { *"} * { *"} * 0 Z (H
!�������() # @(]
(- r�4 p(/ (1 (B , r!5 p(+ *r55 p(+ * 0 " = (�
o"
j[ �
,o'
�*
0 , > (7
,* (7 ,*~�
*0 � ? (#
o$
-*o%
-*o&
o'
,-o&
o(
Ѕ (�
(�
,rI5 ptq (
*o&
o'
,-o&
o(
�� (�
(�
,rI5 ptr ( +*o�
* 0 * > (9
,* (9 ,*~�
* 0 � @ (#
o$
-*o*
8� �
o%
-*o&
o'
,/o&
o(
Ѕ (�
(�
,rI5 ptq (
*o&
o'
,/o&
o(
�� (�
(�
,rI5 ptr ( +*o�
*�i?a���~�
*V(�
o+
(,
o-
*V(�
o+
(,
o.
*0 " rM5 p(/
o0
o�
� &ra5 p
� * + 0 � A ~�
(2 (�
-(2 +r�' p ~�
~�
r�5 p(0 E ' I 8� �r{* p(6 r�. p(=
8� �r`. p(6 r�. p(=
8� (�
o�
o�
�rT/ po�
�� (=
r�5 p(6
,
~�
(�
,d �r{* p(8 ,~�
(�
,4 �r`. p(8 ,~�
(�
, �r�5 p(8 r�. p(=
,
~�
(�
, � (6
,~�
(�
-
r/6 po1
-o?
~�
(�
,r36 p
�� % {�% }�o2
* 0 r B ~�
(�
, �\ s�
s�
o +s�
o
8 (
(
o�
, (
o�
o@ o�
:� (
o�
r�6 pr�6 po.
\�� %�o�
s4
o5
>� rd p rd p
rd p o6
o�
o7
o5
Yo6
o�
o5
Yo7
r�6 p(8
(I oJ , (I
(6 o�
(
:����n o'
�o�
�& � * A4 1 " S k k + 0 9 C rd p
(B ,*r�6 p(�
, r�6 ps9
o:
�
,o'
�* $ -
0 D r�6 p
rd p rd p r�' po1
,F $
�� % �o�
s4
o5
.r�6 p*o6
o6
o6
(�
,&(�
, s9
o:
�k,o'
�(�
,K(�
-Cs9
+ o1
,o;
Xo
�?o:
%
-��,o'
�r-7 p(�
� re7 p o�
(�
� **( ~
� � /� f �� + 0 K E �� %r�7 p�%r�7 p�o<
+ �
o�
o<
,ru) p*X �i2�r p* 0 % F
� (H �n�� �& � * 0 � G @
�� � (H -U(
o
� o�
�� o2
� � o�
�� o2
r�7 p(�
� �&(=
o�
�
&r�7 p� * z �
jy + 0 l H (�
,~�
o�
o�
�� % .�o�
�(E s�
+ r� po
&�(E o
&X �i2�o�
*0 I (
o�
s>
o?
(F * 0 C J �is�
+% � /!r 8 p�� o
&X X
�i2�o�
* 0 \ K -~�
s�
(@
(�
o�
o�
o?
+ �
r+8 p(�
(A
o
&X �i2�o�
*0 � L r18 p(�
-CrK8 p(�
->rc8 p(�
-9r8 p(�
-4r�8 p(�
-/r�8 p(�
-*+0 �
+. �
+& �
+ �
+ �
+ �
+ �
*0 e M �.
�.*r�8 p�� % ;�(�
+1� o�
- r�6 p(�
oB
- o1
,*X �i2�*:(C
} * � * � * � *0 N (�
(D
(�
(E
(; ( (W
~ o� o1 ~ o� o3 o� ,(P +�w %sK �(F
ݥ s4 sj s�
s�
%r9 pr9 p(
o�
o�
s�
%r� po�
o�
o�
s�
%r9 poD
o�
o�
r)9 pjr)9 p~�
s�
%rd ps
o rd ps o � * Zn �+ 0 } O o� -~ o, (<
o� ,~ # >@(;
o- ~ -Ro� -~ s� � +8o� 3 ~ o* o� s� � +o� 3
s� � ~ sj �
~ :� sG
� ~ o� s
~ o� s o
~ oA ru) po�
,~ oH
~ oH
+ ,~ oH
+ ~ oH
o� ,
~ oI
~ o� s ~ oH
(�
oJ
ra9 p�� o� ~ o� �� (�
~ o� jr�9 psG
r�9 p( ~ (R s�
-(Q
o� ~ o� o,
+ o)
o� o(
-�� , o'
��+~ o� ~ o�
(S �
,
o'
�jX~ o( 1*~ o, (<
81��� ( � �S( + �rG 0 : P (�
oK
o�
r�9 po1
, @ oL
@ jsM
oN
* 0 R ,- r�9 psO
z-r�9 p
o�
ra: p(�
-rg: p(�
-+
+
� +
oI
oP
8� (Q
u" ,,nu! ,,bu$ ,Q~ o� (�
-Du$ o o -!o (�
-~ o� +oH
(R
:q�����u o'
�* b �� 0 U S -*s�
ro: po�
o�
o�
oD
%-&~�
o�
d1r9 po�
dYo
o�
r�: po�
u0 ,du0 r� poS
(�
(�
o�
r�: poT
(�
(U
o�
r�: po�
(�
(�
o�
+u ,r� po�
o�
~ od ru) po�
,6o�
oV
,(�
oV
o�
(�
r� po�
ro: p(�
ro: p~�
s� o� * 0 @ (W
(; ( �Y sX
sY
} { oZ
{ o[
*0 % T s
}� � sA
( +( +* 0 � U
rd p
~�
r�: p(+
( +,
r�: p(V r�: p(+
( +, r�: p(V r�: p(+
( +,Ls4
r�: po\
Xo5
/) X� Xo7
o]
r�: p(V r�: p(+
( +,r�: p(V r ; p(+
( +,r ; p(V ~� %-&~� �
sA
%�� ( +( + �i2C� r�' p(^
,rd p �i2%�( +&�i2�( �i2�-,
- s *V~�
� s4 � *2{ (P * { *"} * { *"} * { *"} * { *"} * {! *"}! * {" *"}" * {# *"}# * {$ *"}$ * 0 � V (H
o= ([ o<
(D (g oA (e (D
(] (: (_ (�
�G o�
(a o0 3 (B ,(C %-&(k (c *(k (c *0 j W r; ps`
(a
( +~� %-&~� �
sc
%�� ( +( +
-r_; p+o�
�&(=
o�
� &ro; p � * R
_ + QQ + {% *"}% * {& *"}& * {' *"}' * {( *"}( * {) *"}) * {* *"}* * {+ *"}+ * {, *"}, * {- *"}- * 0 X (H
se
of
sg
r�; pr�; poh
&r�; poi
sj
ok
ol
o
om
o!
o�
on
rH pr#< poo
op
oq
(m r^ por
op
oq
(o r� pr�< poo
op
oq
(q r= prG= poo
op
oq
(s r� por
op
oq
(u os
ot
su
r�= pr�< pov
%r�= p ow
,*r5> p ow
oq
(x
(y
(w %r_> p ow
,*r5> p ow
oq
(x
(y
(y %r�> p ow
,*r5> p ow
oq
(x
(y
({ r7? p ow
,*r5> p ow
oq
(x
(y
(} *0 I (H
(� (� (� (� o�
(� (� (� (� * {. *"}. * {/ *"}/ * {0 *"}0 * {1 *"}1 * {2 *"}2 * {3 *"}3 * {4 *"}4 * {5 *"}5 *Z }8 (H
}7 *0 F Y {7 oP
+
(Q
o (R
-�� �u o'
� � {8 [(z
* & br�? p{8 ( }8 * {9 *"}9 * {: *"}: * {; *"}; * {< *"}< * {= *"}= * {> *"}> * {? *"}? *0 H (H
(� (� (� (� (� (� ~@ %jX�@ (� *0 Z �i (� *fs�
%o�
(� * 0 s�
%o�
(� * 0 � s�
%r�? p(� o
o
&%r�? p(� �� o
o
&%r@ p(� o
o
&%r?@ p(� o
o
&%rU@ po{
&%ra@ p(� ~� %-&~� � s|
%�� ( +(8
o{
&o�
*: ~P (}
*6 ~P (~
*0 1 �b ! (�
* 0 1 �b ! @ (�
* 0 1 �b ! � (�
*r�� %re@ p�%ry@ p��P * 0 , [ ,' ŝ �
+o
a � Z
X o�
2�*r�@ p*B{Q jX}Q *F|Q (�
(�
* (� *"}R * {R *J~�
}R (� * 0 0 \ (x
{S (�
}S �&r�@ p(�
}T � * + �{T ,{T *|S (�
(�
*Z#�������}S (� *0 0 \ (x
{U (�
}U �&r�@ p(�
}V � * + �{V ,{V *|U (�
(�
*Z#�������}U (� *0 ; \ (x
{W X}W {X jX}X �&r�@ p(�
}Y � * && + 0 + \ {Y ,{Y *{W {X l[
(�
(�
* 0 , \ (x
{Z X}Z �&r�@ p(�
}[ � * + �{[ ,{[ *|Z (�
(�
*.s� �\ *�(�
rA po�
,(�
r7A po�
** 0 � ] {^
{b 9 ~�
}c {` o
+&(
(
(?
,(
}c + (
-��/
�n o'
�{c (�
9� s�
{a o�
++(�
o� o� o� (� o�
(�
-��/
�y o'
�( +o�
(�
-A%
}^
}d |_
( +ݎ {d
|d �{ %
}^
(�
+% � o�
, o�
}c + X �i2�{c � �}^ |_ (�
� �}^ |_ (�
*AL + 3 ^ � 8 � l z + 6|_ (�
* 0 / ^ {e
,hs�
{g ,Z{g (! +,M{g o
+"(
o�
(
(
o�
(
-��/
�n o'
� ,={h o�
o�
(�
->%
}e }j |f (" +�{{j |j �} %
}e (�
{i (�
�(# + �)&{i (# + � �}e |f (�
� �}e |f (�
* ( 1 /` s ~� X �+ 6|f (�
*f(H
}k (�
}m *0 0 _ {k
�Y63 �..� �(� �(� �* ! ( 0 � ` {k {n E � � U k �
ݥ }k o� -
ݏ {o � j]-m(� �A(� ro: p(�
{o ro: p~�
ro: prAA po�
(�
s� � , }l }k
� }k {o (�
, }l }k
�� }k {� o�
o�
}q �}k 8� |q (�
{o ]-w{� o�
{o o� o,
}r �}k ++{r o)
}l }k
�W �}k {r o(
-�(� }r |q (�
:a���(� |q � {� o�
{� r$% po�
{� o�
o�
{� r>% po�
{� o�
o�
{� rb% po�
{� o�
(�
o�
{o j]:� o�
,G(� r�) p(�
{o r�) p~�
r�) p
s� }l }k
�A }k s�
{� o�
o�
8� (�
{�
o�
s�
r�A p
o�
r�A po�
(�
(�
o�
r�A p(�
(�
(�
o�
r�A p(�
(�
(�
o�
r�A p(�
(�
(�
o�
o�
o�
(�
:3���� �� o'
�r�A p{o r�A p~�
s� }l }k
�}k
�(� �* AL [ c A + � � � � � f}k |q � o'
*r �}k {r , {r o'
* {l *s�
z 0 C a {k �3{m (�
3 }k
+s�
{n }n {p }o * (� *f(H
}s (�
}u * 0 0 _ {s
�Y63 �..� �(� �(� �* ! ( 0 ` b {s {v ,;�
�? }s r�A p 2( } }~ {� o�
o�
}� �}s 8� |� (�
}{ {� {{ o�
{w o�
9� {{ (� }y {y oc {w o�
}z {z o�
o�
}� �}s 8 |� (�
(�
(�
{y {z o�
ob (� {{ (�
{| {z o�
(�
(�
Ys�
s� �q {~
X}~ {~ { 02(� ro: p(�
{| ~�
r� p o�
s� +r B p{~ �� (�
sa z� ,}t }s
�l �}s |� (�
:���(� |� �� }y }z }{ |� (�
:"���(� |� ��
�(� �*A4 � q j q W W f}s |� �� o'
*j �}s |� �� o'
* {t * 0 O c {s �3{u (�
3 }s
+s�
{v }v {x }w {} }| * (� *f(H
}� (�
}� * 0 _ {�
�.3
�(� �* 0 � d {� {� , .j
ݐ }� {� {� (� o,
}� �}� +={� o)
o� o�
r< p(�
- }� }�
�- �}� {� o(
-�(� }�
�(� �* �� n}� {� , {� o'
* {� *0 O e {� �3{� (�
3 }�
+s�
{� }� {� }� {� }� * (� *f(H
}� (�
}� * 0 _ {�
�.3
�(� �* 0 � f {� {� ,.P
�y}� {� {� (� o,
}� �}� +&{� o)
}� }�
�- �}� {� o(
-�(� }�
�(� �* �� n}� {� , {� o'
* {� *0 O g {� �3{� (�
3 }�
+s�
{� }� {� }� {� }� * (� *f(H
}�
(�
}�
* 0 h {�
E + � *}�
{�
($ +- {�
}�
}�
*}�
*s�
j {�
o�
+$ o�
� o�
o�
Xj(�
o(
-��
, o'
� � j[i(�
}�
+>{�
{�
(% +}�
}�
*}�
{�
{�
(& +}�
{�
($ +-�* b 0�
{�
*0 7 i {�
�3{�
(�
3 }�
+s�
{�
}�
* (�
*.s� �� * s *.s� �� *"(�
*0 j (�
(�
(�
*jX* 0 + k �K ~� }� (�
( &{� *>(�
(�
*6{�
( *Vo�
{� o�
�*.s �� *>r/6 po�
�*.s �� *2rYB po�
*.s �� * (' +*V�J (�
(�
�� *V�K (�
(�
�� *BSJB v4.0.30319 l �i #~ j \X #Strings l� lB #US � #GUID � (3 #Blob W_� �3 � K � ~ � � � k � � ' � + ' a& U#.C �#.C �$.C {!5B NC �!�6 �#�6 �!C �$o0 P$�6 i$�6 �"�6 �$�6 h#�6 �#�6 �!�6 :#�6 �!�6 �"C' r6kG �#kG a!*X /!.C �Ko0 � 5B �!5B "#5B
J!�> �"5B
�$M, @"6 �$6 �$6 �0o0 #6 �"6 d"6 Q"6
z"M, �C )0� n?6 H9o0 E=� 5C �7�M y�M �8�M )=�M � o0
Lo0 �+o0 #0�
0�4� �A �o0 C �M�:� V7 � �A �=�Q +C �7tM ltM =tM �� �1� �@�G �R� �o0 � o0 �/�"
�:" �P�:" ��: �8�� �A �C �o0 �cF � o0 ".C �.C X o0 T .C .C& �M}:& *9}:
J5B "".C �C O1o0 ��G
� 5B f4o0* �?/6. =�&. =H�& �o02 �MpJ2 �@�W2 �Vc, �>� �P
4Q�K
�K To0
�14D { 4D
�I:X T\9 �<\9 3$\9 %*X } �C ;&� �R� �T�6 � �I k' $�B �"*X: �K�M �6tM �K� (N - > - � -. �B�&. E�&. �D�& �C d)o0 q=o0 ?� � �6 9:�6 �T�6 o0 R=� �7�9 b�9 �o0 =�9 -o0 �96 [o0 � �
E�4 !'�Q �Po0 ��: N�: ��: �>�: $!�: �So0 D7� � � G1o0 �6� �o0 �>o0 �C No0 �*� z6o0 �+cF
�)5B �V� B' �9�
� �I� � �+KQ p� �8o0 �., �9o0 �9o0 �<o0 � �6. �,�& 4*o02 �5�W2 �,c,2 �=�52 �RDJ2 ;G�52 @R�52 /R�52 "R�52 �R�52 |R�5 �o0 �C
8Q�K
�6�K
�6^
+:X
�K
X�K Bo0
)74D B%o0
:5B
�F�K
>W�K R0o0 �&�T v0�T J�T
�I5B �8o0 �8C �P': '>�M: 7�M �7tM �6� UQ - �M - � - o0. !E�&& +I�H& �H�H zo0 �8o0
C: rK�M> VGmC �+C u a Q a � %: a & . ]C a N . �U a O 1 ! � � S : ! � � X : �J a � : ~P a � = � a � N 5 a � S ! � � � Z ! � � � Z � ]=�Va � Z ?9�V� � a �@�Va � b �@�VD � e �@�VH � m >@�VH � p �>�Va � x d@�VD � � _@�VX � � �?�VD � � @�VD � � �/�Va � � { �V� � � � ��Va � � I�Vp � � ��Vp � � b�Vp � � � �+�Va � � �+�V� � �+�V� � �@�Va � �+�V� � � �>�Va � �@�Va & �,�Va ( � �V� K W�V�K �9�Va Z �9�Va %l `H�Va . �*�Va 6� W�Va 9� 4�V�A� ~ a Q� "5 a Q� �P � Q� )Q � R� �R � S� �1 � U� � � W� �0 � Z�! ? a \� 3 Q^� � Qe� [ a k� � a s� _ a �� . a �� � a ��! ? a ��! ? a ��� �B a � �1 �� �J � � O � � � a �! ? a �! ? a � ! ? a �
�> Q�
K Q�! � � ! [
� ! � ! �
� ! � � ! �
� ! G
� ! � � !
� ! j � ! 5 � ! 4
� ! �
� ! n
� ! O � ! �
� ! � � ! � !
! �
! � � !
� ! �
� ! �
� ! n
� ! � � ! � � ! 4
� ! � ! �
� ! �
� ! � ! G
� ! 5 � ! � � ! � � ! O � V��(8V�]3�V�j3�V��2�V��,�V��(8V� (8V��'8V� (8V�(8V�9(8V��'8V��(8V�kS8V��(8V�RS8V�e18V��=8V�b8V��8V�=V8V�@8V�S8V�,S8V�?S8V��28V�m%�"V�Q%�"V�+8V��&8V��'8V��28V�@8V� 8V�/8V��8V�q8V�38V��28V��28 �" � 8 .8 �" ?�"��V�� �"V�7%�"V�0B�"V��S�"��V�5 �"V�>1�"V�9L�"V�]'�"V��:�"V��:�"V� �"V�V�"V�.5�"V�*'�"V�h'�"V��I�"V��G�"V��"V�M�"V�nV�"V��V�"V���"V��1�"V��"V�O6�"V� �"V��W�"V��F�"V� �"V��"V��?�"V�+�"V��5�"V�|>�"V��+�"V���"V�u)�"V�&�"V���"V���"V�,�"V��G�"V���" �" � 8 �8 ��" � 8 � 8 f8 ?�" ��" ��" ��" ��" � 8 � �"��V���"V���"V���"V���"V���"V���"��V���"V���"V���" �D�"V�X8V��<�V��<� -8 �� �B� CQ�" uI�" T-8 V88 ?88 �G# �
8 }�" A�" �8 � 8 8 -8 �� �8
G#Q��8Q��8 wV8 Y3� ~�" �# �.# �I># "M># � ># �G# }&P# m&P# M_# � ># �P># N?n# �B�" ��" �,w#! �/|#! �E�"
8 �8 ��"��V�P:�#V��?�#V�8V��8Q�_V8Q�SV8Q� 8V�B�V�}S�V�l+�V��48 �
8 ��# �B�# ��# gI�# J�#Q��%8Q� 8Q�� 8V�98 -8 �
8 N8 h8 ��"Q��Q�Q��P� 1�" H�" -8 �
8 N8 � �" *8 N8 K� �?�#V�v28 �# 8 > 8 ` 8 /
8 �81 >�#1 v8�# |?�# LT8Q��T8 ��# |?�# ��# �=8 �=8 F8 |?�#V��8V��38Q�6K� �&8 �38 � ��# �H�# YS �8 ��# 8 ��# O
8V��E8��V���#V��#V�!�# �H$ �8 �,w# �9�# X $ �$ MF$ � 8 r8 �8 � 8 l8 �8 O8 " 8 �
8 �8 08 &8 �8 8 =8 �8 _8 �
�" ��# O
8 ��" �8 h8 ��" ��"Q��� MF$ �� �
8 8 8 $ l
*$ � S �-$ �*$V��5$V� 5$V�5$V��5$V�:$V�X1:$V��S:$V�T:$V��:$V��:$V��*:$V��*:$V��*:$V�Y?$V�L?$1 �J�" �PS .Q8 �RD$ �?8 �1D$ �?8 �0D$ �PS �?8 �0D$ �?86 qG$ � L$ � � �=U$ �E�" �F|# �E]$ [8 �a$ � � �=p$ XI�" �/8 � 8 �~$ � � P�$ �� �E$ �S �S F�$ �$ � � P�$ �� �E$ BT�" =T�" ��$ ��" 8 �S �S �� � F�$ �$ � � P�$ �� �E�$ BT�" =T�" �S �S F�$ � � P�$ �� �E�$ BT�" =T�" �S �S F�$ � � P� �� �+� �+� n�6 q�$6 q�$ � �$ :�$ �$�SV���$V�h�$��V�]5�$ X&86 q�$ � L$6 q�$ K %6 q % K % �&�" E�" ��6 �&�" �&�" �?�" �R�" �R�" �J %6 �&�"P ��TL X �=0 ` �\4$% h �� )% p ��.% x �b03% � ��8% � �-=% � �� B% � �SG% � �h>L% � ��Q% � ��2V% � � [% � �&F`% � ��3e% � ��j% � �Vo% � �)t% � �G y% � ��A� �! � �F~% �# � � �% � L)L �* �VL �* �)0 �* �G $% �* ��2)% �* � .% �* ��3% �* ��8% �* ��=% �* �\4B% �* �� G% + �b0L%
+ �$4Q% + ��V% + �h>[% "+ �-`% *+ ��Ue% 2+ �&Fj% <+ ��A[ �+ � �F~%' �- � �( D/ � L)L( �3 �hU�%( �3 �zU�%( �3 ��A ) �3 ��A ) �3 �� L) �3 �� ) �3 ��UL* �3 ��U * �3 �!T�%+ �3 �/T�%+ �3 �#V�%, �3 �0V�%, 4 �hP�%- 4 �sP�%- �3 ��A . 4 �_ L. 4 �m . (4 �\6L/ 04 �g6 / 94 �bD�%0 A4 �qD�%0 J4 ��L1 R4 �� 1 [4 ��L2 c4 �� 2 l4 �^2L3 t4 �j2 3 }4 �#V�%4 �4 �0V�%4 �4 ��? 5 �4 �� 5 �3 ��A 6 �4 �^B�6 �4 �qB�6 �4 ��4�%7 �4 ��4�%7 �3 ��A 8 �4 ��A 8 �4 ��7�%8 �4 ��7�%8 �4 �� L9 �4 �� 9 �4 �� �%: 5 �� �%:
5 � FP�%; 5 �
!�%= $5 � i(�%= L5 � �H�%> �5 � �/�%? X6 � �J�@ �6 �B�%A �6 ��A A �6 ��B&B 7 ��) C �3 ��A C 7 �)LC 7 � ) C 7 �vQD 7 ��Q D (7 ��A!&E I7 � �B&G T7 � �B'&H (; � ;J�J �; ��A!&K �; � �) M �; � �B&M �< ��A!&N = � �B&P �= � z4 Q > � 2- Q �A � 3?8&R C � �U�%R �C � ZE T D � �GG&T �3 ��A U �E ��LU �E �� U �E ��D�V �E ��D�V �E �HB�W �E �SB�W �E ��7LX �E ��7 X �E �sLY �E �� Y �E �^2LZ �E �j2 Z F � �[ F � L)L[ hF � �F~%[ vF � �FY&\ �F �)L] �F � ) ] �F �vQ^ �F ��Q ^ �F ��+L_ �F �, _ �F ��A!&` �F � �B&b G � �B_&c �L �B�%f �L ��A!&f �L � �B&h �M ��4? i �M ��4 i �M ��A j �N � �) k O � D l TY � "?q&l �Y � "?�&n Z � DU�&q TZ � �B&r �f � " s g � �B&s �h � �D�&t i � ��&u xi � ^�&w �i ��A z �j �B�%z �j ��Lz �j �� z �j �s/L{ �j ��/ { k �I�&| k �I�&| �3 ��A } � � �'�&} k ��L� k �� � #k ��G�&� +k ��G'� 4k ��A � l � ,@'� El � �V'� \l ��V$'� zl ��=L� }l � ;-� �l � �V2'� ��4? � ��)9'� zl �L� zl �$L� �l � e � �m � �0@'� n � �0�� |n �)L� �n � ) � �n ��L� �n �� � �n ��L� �n �� � �n �9*L� �n �K* � �n �U? � �n �U � �n ��AD'� p ��AL'� hp � !1V'� �p � �4? � dq � �V$'� �q � L� �q � $L� �q � �)9'� r � �=L� Wr ��%� hr �+8? � �r � WW�� 4s � L� ls � D:�� Dt � <Y� �t � 3$'� �t �)L� �t � ) � �t ��L� �t �� � �t ��L� �t �� � �t ��? � �t �� � u �hL�
u � � u � �)9'� hu ��A& � hv � �4? � �v � �=L� �v � <Y� (w � ��� �w � �V$'� �w � L� �w � �%� �t � 3$'� Dx ��L� Lx �� � Ux �13� ]x �E3 � hx ��A � �x � �4? � Xy � �)9'� �y � �=L� z ��9\'� z ��9b'� !z �#L� )z �0 � 2z �,L� :z �A � Cz �kL� Kz � � Tz �L� \z � � ez �% L� mz �6 � xz ��Ai'� ��q'� E{ ��? � H{ � hQx'� X{ ��Ai'� x{ � �? � �{ � �q'� } �B�%� V} �B�%� �} ��Ai'� �~ � �q'� � ��Q�'� � ��Q�'� � ��A�'� � � J�� #� ��Ai'� \� � �q'� �� � �= � � � �? � �� � 6L� �� � �S�� � ��'� �� � L�%� �� � %�'� �� � %�'� p� � %�'� � � �%�� B� � ��� T� � ��� �� � �H�'� � ��3�� �� ��3� � � � UP�� ̅ � sE�%� � � �F�'� `� � tH� � �� �B�%� Ї � �1�'� � � N+�'� 8� ��C�� @� ��CA� I� �b L� Q� �r � Z� ��*�� b� ��*�'� k� ��(L� s� ��( � |� � �'� �� � �'� �� �aL� �� �q � �� ��A � � � ��'� H� � �%�'� �� � �%(� ,� � &(� d� � &(� 8� � �2�� N� � 4�� d� �P L� �� ��L� `� ��D$(� � ��L� l� �7P� �� � ,L� � � �0@'� L� � Z5�� � � �)�� �� � �)�� �� � C)�� � � �)� � � A5+(h� � 8&9(�� �E @(m� ��AH(|� � NO( �� � ;FV(
�� � �b( �� � �1h( ĕ � �1n(
x� � �J�%�� � � u(� � �?�(H� � �P�7 � r: �� � �E�(ț � �E�(s� �B�%�� � � �� ��L�� �� �� �6 L �� �C �� �84L �� �J4 ɝ ��L ѝ �� ڝ �w3L � ��3 � �� L � �� �� �*L!� �* !
� ��L"� �� " � ��A�(#�� � �3�$T� �UL$\� �d $e� �8L%m� � 8 %v� �42L&~� �B2 &�� ��WL'�� ��W '�� ��,L(�� ��, (�� �ELL)�� �YL )�� �mLL* ��L *˟ ��LL+ӟ ��L +ܟ ��LL,� ��L ,� ��AG- � ��A�(.a� �? 6i� �% 6r� � �'7z� � �'7�� �aL8�� �q 8�� ��0? 9�� �1 9�� �zFL:�� ��F :�� �9*L;�� �K* ;Ǣ �U? <Ϣ �U <آ � Q? =� �Q =� ��A�(> � � �Vq'?d� � 5E @7 �N @}� ��L@�� �� @�� �@>LA�� �T> A�� �TULB�� �^U B�� ���(C�� ���(C�� ���(Dɣ ���(Dң ���Eڣ ��AE� ��E�(F� �F�(F� ��A)GH� ��A )Mk� ��A2)R�� ��AA)W�� � L)L]7 �B�%]o� ��A ]~� ��A ^�� � cHK)^�� � PHK)^ܥ � )HK)^� �B�%^ � � �)Q)^7 � _X� ��L`�3 ��A `_� � `p� � �La�� ��A a�� � a�� � �Lb�� ��A b�� � b�� � �Lc � ��A c4� � c�� � �Ld�� ��A d�� � d� � �Le�� ��A eH� � e�� � �Lf�� ��A f�� �B�%f�3 ��A f�� � � Yf� ��Q g� �g 8 g� ��Q hX� �g 8 hf� ��A i�� �; jج ��Q? j � � Q j&� � jC� � xOV)jK� ��K jC� � �OQ jT� �gA\)j�� ��Ah j�� ��A jȱ �; k � ��Q? k�� � Q kڴ � k�� � xOV)kK� ��K k�� � �OQ k � �gA\)k[� ��Ah kc� ��A k�� �; l�� ��Q? l�� � Q l�� � xOV)lK� ��K l�� � �OQ l�� �gA\)l� ��Ah l � ��A l(� �; m`� ��Q? m� � Q m,� � xOV)mK� ��K m,� � �OQ m4� �gA\)m�� ��Ah m�� ��A m7 �; n�� ��Q? nй � Og)nK� ��K nй � �OQ nع �A�n� ��Ah n#� �B�%n�3 ��A n/� � } q)n7� �B�%o�3 ��A oC� � � z)oL� � Dz)pm� � 1 �)q � � �S�)s � � �1�)wt� � �S�)x�� ��ANz�� � *? {�3 ��A {ɺ � Y{ߺ �B�%|�3 ��A |� � Y|�� �B�%}�3 ��A }� � g �)}� �B�%~�3 ��A ~ � � U �)~(� �B�%>� �B�% �T A `4 � � f0 � 1 �
S l> �
�2 # *F �3 Z - K 2& Z - K �2 # � � `4
� f0 (4
� l> 1 V *F 2& 2& 2& 2& 2& 2& 2& 2& 2& 2& 2& 2& 2& 2& 2& 2& 2& 2& 2& 2& `P �( 00 T �U 2& 2& 2) �Q �U �U } �R 2) �Q �U 2) �Q �U o/ 2) V o/ 2& 2& 2& 2& 2& 2& + + 2& 2& 2& 2) �Q �U �U } D 2) �Q �U 2& Z3 T �K �T �K �T jT �K �U �U �, �E �F � �/ XI 2& 2& 2& �7 �T �% 2& �& k* 2& 2& � � BT � � � T � 2& 2& 2& 2& 2& g? � �( 1 �, �H @ BT � T � � jT � � � � BT � 2& 2& 2& 2& 2& T � g? � � � BT � � BT � 2& 2& T � 2& 2& 2& 2& 2& 2& �9 A )W �+ �9 A )W �9 A )W 2& R I0 �9 A )W �= �= )W �T �% d7 �T �% d7 �T �% d7 �T �+ v 2& �/ �F % �1 > � �1 �I 2& 2& 2& 2& 2& 2& }T �T � }T �R �T � }T �T }T �R �T �U �% �0 �* _) _) � �Q �I U: �& �* J �* H& �E �, ]F � �E �H � �5 �E 6' R9 ? 8 3 �E �E X& �E 2& 2& 2& 2& 2& 2& 2& 2& �, 2& 2& 2& 2& 2& 2& 2& 2& 2& 2 7 � 1 � �F ]* 'U "Q 2& 2& 2& 2& 2& 2& 2& 2& NF )W 2& 2& 2& 2& 2& 2& 2& � l> V 1 *F � l> V 1 � l> V �K � l> V � 2& � SK 1 1 1 1 1 1 1 u w w � � � � � R �: �: �+ �R �S oR y: �H aR oR y: T , , {S {S# �- 9 U: U;
; u; ; ; <
< u< < < =
= u= = = >
> u> > > ? ? u? ? ? �A �A �A ! �A
1 �A 9 �A A �A I �A Q �A Y �A a �A i �A q �A y �A � �A � �A � �A � �A � �A � �A � �A � �A � �A � �A& � �A � �A � �A �A �A �A !�A )�A 1�A 9�A, ��A1 ��Q �g 8 ��A1 1N !�Q? PL !L ! PQ �A^ ��Ah PL $ �A^ ��A� ��A ��A ��A , � � , [
� , � , �
� , � � , �
� , G
� , � � ,
� , j � , 5 � , 4
� , �
� , n
� , O � , �
� , � � , � ,
, �
� �A 4 �LF4 �FP< �LF< �FPD �LFD �FPL �LFL �FPT �LFT �FP\ �LF\ �FPd �LFd �FPl �LFl �FPt �LFt �FP| �LF| �FP� �LF� �FP� �LF� �FP� �LF� �FP� �LF� �FP� �LF� �FP� �LF� �FP� �LF� �FP� �LF� �FP� �LF� �FP� �LF� �FP4 ��< ��D ��L ��T ��\ ��d ��l ��t ��| ��� ��� ��� ��� ��� ��� ��� ��� ��� ��� ��� L)L)kK�t� � t
� t�
� t�
� tn
� t� � t� � t4
� t � t�
� t�
� t � tG
� t5 � t� � t� � tO � |@02|�< ��A 9�A:9! 9.* Ii8AA�JIi P�VL)^KVQ�T]Q�/c)^Kj�8�Q�A1 Q�&�Y� PI�L��A ��T�|�A �@02�70�|�T�|70�a�A:aXLY�A ��A q�A i~1 y�A q�U��<)^K)C i q�Q y7=#�. )�70.�,&3)VX8�� ;��WB�H L�L)R�L)R�L)R�L)R)�*Y��P�r^��P�S? �GM? i� d��Av�h���D�I!���S���'�YL�aQ���A�� PL �\�|r2��Q? ��A ��A �<L ��0)�0L)cML)�WT�70Z)�FY�Y ��!L���J���A^ � PL �-%��G%L�pQ��G%L��T��70���T��@02�70��LK��A%� PL )�WT��A �eK<��Q? ��< ��A2��A �@02�5 ��eK��VX��eK����� �)�1���A �~1 � )k))�A �Q 7=% �+�A K1��P��Ah G7 �&= 70B�A )70I� rP�L�G� 70.)^K^)^Kd�Kj)70.��rL)L)@0w�R} �P�r� S? 5 N � ���A��r�);�)�C���A ��A ��A ��A ��A �A �A yL)L1L j9�A-A�93��B<�_:C)kKJI3WPQ�J QD��A-�� ���S Y�L��P Y?% Y�L, a�A a~11 I5 I�A I�A@ PL QHBT Y�LYG%Q ��T��70�$G�$r�$�A �@02,�A2��T��70��@02��< �� � ��D<4�T�470�4@02<�T�<70�<@02�@02D�< �A L P+ TWTL TG%0L�Q? ��A \ P+ dWTL dG%0\�Q? �A l P+ tG%0tWTL l�Q? ��A | P+ �WTL �G%0$�P|�Q? ��A � P+ �WTL ,<L ,�0�G%0��Q? ��A � P+ �WTL �G%0��Q? ��A � P+ �G%0�WTL ��Q? A L ��LL ��1
��H
��A^ � PL � L��L��+0
��L�� I
��PS
��+a
�� I
��PS
��+a
��A �r^��A �@02��A �@02��A �A �A @02�J�
��T��70��LK�A% PL �@02��T� �Q? ��J ��A �sW)�F 1t*�)kK()NX I3WT)?L_� ��Gf)kK�yV �)kK�)kK�Q. ��^2���?$�A $�+��A �,�A^ 4 PL �&z)�*9� ��1�)k)���R�<�A� !��,�B �D$�M&+��,1�'J ��=7D�A-�� I�R !�A !RZ�EA�=R`�
!�T ��i� �1o P $, ��5u� �n4{� N0 � L)R!L)R!�P�!.* 1RZ) J�A�A�I�*�I�*A��Q���Q���R��L)T�A[)@ ���%�\�< d�< yL)R���)kK�)RML\�T�\70�\�P����z'��U)�l�A-�7U�1� 1�H A@0& I�A-ID+"1) )Q�H A70Q�//��6F�(KR�KV|�A t P+ |WTL Y��|G%0t�Q? d�P��A-d� �\�A d�A aZ:�aPR�a�J�����qT��_T���%�� � P��S? �� P)�1��&D�Q�4Ly:y�2Ly�3L�JW �6 L)GY)�0 �&N��A���P�70Z�UK )�1\a�A a, L)�&=)�* )P2���A ��)��� �qL)�)�* ��A �] �& ��9��A �r^��< ��� L��IGa�AA��KN��A ��A�� PL ��Q? ���� �qL)RY�8���P���A-��A��� ��P ��&���S�)�F�V ���A ��K��b ���A-��K�A v7G��A �rN��KV��A ��C`�70f�70m�*- �St�D0|RL�S���M������A��d& s��� L)L�_:��5 ���A- �A� �A�)�H���R� L)R��1�12�1 2���A ��A�� PL �r^��Q? A�,n��>��% ? � ��3ML ��0�<L � 9��=M^�g 8 ��A �3U �>I !r& �u%��>��% ? � ��3ML )� B� 9��=M^�g 8 )�X�LK��A%� PL �70���Q? �&* 70���� r^�w�� ���E�LK�A% PL �P��1���R���� �< �Q? 1�A �LK�A% PL �70�|LK$�A%, PL ��E�L�A^,�Q? �Q? 4� �4��4�+�4 P�<�A^ D PL ��R���R�4n�����m:�4�A 4�+�4A�LWTL LG%0a-L���A 9JN9T�A!&VI[(�Q�& � � � � � � � � � � � � � � - � � � � � � � � � � � � � S � b � } � � � � � / � < � � I � N a � & @ a d $� (� ,� 0 1@ 4 =@ P� T X \ d� h l p t" x' |, �1 �6 �@ �; �@ �E �J �O �T �@ �� �Y �^ �c �h �m �r �w �| �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� <� @ D H L" P' U" X� \ ` h� l� p � �( (� , 01 4R 8m <� @� DJ H� L� P� Q" ]" i" l p. t= xL �@ �g �l �o � \! Dk! L� P T �� �" �" �m
�!
�!
�!
�! �! �! �! �! $�! (�! ,�! 0�! 4�! 8�! <�!
��!
�" �"! � ^/' � . . �*. �*. # �*. + �*. 3 +. ; S+. C Y+. K _+. S y+. [ �+. c �+. k ,. s ,. { ,. � Y+. � S+. � m,A � ^/C � a � ^/c � � � ^/� � ^/� � �0� � � � �0� � �0� � 81� � ^/� � �0� � � � �0� � �0� � ^/� � �0� � ~1� ^/� �0� ~1!� ^/#� �0#� #� �0#� �1#� 2A� ^/C� �0C� C� �0C� �1a� ^/c� �0c� c� �0c� �1�� ^/�� �0�� �� �0�� �1�� ^/�� �0�� K2�� ^/�� �0�� K2�� ^/� ^/!� ^/A� ^/a� ^/�� ^/�� �� ^/�� �� ^/�� �� ^/ � � ^/!� ^/A� ^/a� ^/�� ^/�� ^/�� ^/�� ^/� ^/!� ^/A� ^/a� ^/�� ^/�� ^/� �� �2@� `� i� �2�� �� �� �2� � )�2I i �� �2� ��2� � 3#� C� c� �� �� �� �� � #� c� �� �� � # � ! � g/A � }/� � �/ � �/! � �/A � �/a � �/� � � �
0� � � �
� a� $0�� ;0�� U0� i0 � !� �0@� `� a� �0�� �� �� �� �0�� � � @� `� �� � @� `� �� �� �� �� �� �� �� �� �,@-�� �� �� �� �� � � � !� @� A� a� �� �� �� �� �� �� � `3y-�3�-�� � � @� A� `� �� �� �� �� �� �� � � �31.�� �� � � � @� `� �� �� �� �� �� � � � ! � @ � A � a � � 3�.! � A � a � � � � � � � � � � � � � � � � � � ! � A � a � � � � � � � � � � � � � � � @ � ` � � � � � � � � � � � � � 3/a!� �!� �!� �!� �!� �!� �!� "� �# �# �#� �#� �#� $� !$� A$� a$� �$� �$� �$� �$� %� %� %� !%� @%� A%� `%� a%� �%� �%� �%� �%� �%� �%� �%� �%� &� &� &� !&� @&� A&� `&� a&� �&� �&� !'� A'� a'� �'� �'� �'� �'� �)� �)� +� @+� `+� �+� �+� �+� �+� ,� ,� @,� `,� �,� �,� �,� �,� -� -� �-� �-� �-� �-� .� .� @.� `.� �.� �.� �.� �.� /� /� @/� `/� �/� �/� 0� 0� @0� `0� �0� �0� �0� �0� 1� 1� @1� `1� �1� �1� �1� �1� �2� �2� �2� �2� 3� 3� @3� `3� �3� �3� �3� �3� 4� 4� 9� @9� `9� �9� :� :� @:� `:� �:� �:� �:� @;� `;� �;� �;� �;� �;� <� `<� �<� �<� �<� �<� =� =� �=� �=� �=� �=� >� >� @>� �>� �>� �>� �>� ?� @@�Q/ "���Fp��j8��5`��EQe���Y� � � � � 6
k
�
�
3JN{������������
��5[�����%gn����������ASVu����(�����\`��U[eku���� & ' +
, 4 6 9 ; A D E H J O T V # \ % ] ' ^ * d + l , u . } ; � < � = � > � ? � �T�) A�) `4�) � �) ��) f0�) ��) 1�) � �)
S�) l>�) ��) �2�) # �) *F* �3*
* Z* -* K * Z�) -�) K �) �2�) # �) ��) �) ��) `4�) � �) f0�) (4�) ��) l>�) 1* V* *F
* �U!* � '* �U'* 3T+* JV0* �P5* q '* z6'* uD;* �'* � '* f4'* JV0* �A* uBE* "5J*
8O* G'* � T* !)'* �QY* � '* �DE* }BE* �7'* �'* f4'* !)'* �QY* ,'* �4A* �'* �/'* II]* � '* �Gg* !)'* �'* �'* O*'* UA* !)'* �'* �'* �A* �'* �'* I3Y* �9r* 4'* E'* �'* '* : '* �Qx* �3~* �C�* v '* �*�* �('* �* u'* �'* y '* N4'* �'* �3'* � '* *'* !'* h'* 78'* F2'* �W'* �,'* ]L'* �L'* �L'* �L'* )A* �* u'*
1A* �F'* O*'* UA* QA* �'* X>'* �U'* (�* ��* ��* F�* �N�* �N�* �N�* �N�* �N�* �N�* �N�* �N�* 4N�* �N�*
! # % ' ) + - / 1 3 5 7 9 ! ; " = # ? $ A % C & E ' G ( I ) K . M / M 2 O 3 O 4 Q 5 Q 6 S 7 S 8 U 9 U : W ; W = Y > Y ? [ @ [ A ] B ] C _ D _ E a F a G c H c I e J e K g L g N i O i P k Q k T m U m V o W o X q Y q e s f s g u h u y w z w { y | y } { ~ { } � } � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �
� � � (� )� *� +� ,� -� .� /� 0� 1� 2� 3� Z� [� \� ]� ^� _� `� a� b� c� d� e� f� g� h� i� l� m� n� o� p� q� r� s� t� u� v� w� x� y� z� {� |� }� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� � � � � � � � � � � �
� � � � � � �9 �I 9 �K : �I : �K ; �O ; �Q ; �S ; �U ; �W ; �Y ; �[ < �O < �Q < �S < �U < �W < �Y < �[ = �O = �Q = �S = �U = �W = �Y = �[ > �O > �Q > �S > �U > �W > �Y > �[ ? �O ? �Q ? �] ? �U ? �W ? �_ ? �[ {--C U n { � >X`hpx��������������IPSVY\_behknqtwz}����*���
!��1W��� %�K Z k � � � # 7 ? G O ] k z � � � � � �
'
B
}
�
�
�
�
�
�
�
�
�Vh�=�5���ow��U8l��Tf���/����0EM{���Y�' �A5 A�S A�1 � 9e: 6 o0 - � �: �
tM �: }: '%G
'pJ �I �M 0mC �- � k- � 1. x� �- �� �. �� y. �� 1/ �. 1 2 3 4 5 6 7 8 9 : ; < = > ? @ " A % B & C & D ' E ' F ) G ) H * I . J B K B �< �; @< �; ; �; s; �: 8; �<
W< a; �;
�; p< < !; �: I; �; �: I; �; �; �; ; !; a; @< �;
�; '< s;
W< �: �< p< ~ � 5� 7� 9� 9 ������� � � 6 4c 4g 4 6c 8s 8x 8} 8� 8� 8� /[
5�
s ����S�g������!������+76;S+������ <>f__AnonymousType0`20 <>9__22_0 <.ctor>b__22_0 <RecordExceptions>b__22_0 <>9__33_0 <ToString>b__33_0 <GetOsVersion>b__33_0 <.cctor>b__3_0 <>9__24_0 <ReadFromXEFiles>b__24_0 <>9__15_0 <GetExceptions>b__15_0 <OnStart>b__16_0 <>c__DisplayClass18_0 <>9__19_0 <ParseInputArgs>b__19_0 <RemoveFromInputArgs>b__0 <>n__0 <>9__15_1 <GetExceptions>b__15_1 <cloudService>5__1 <subListSize>5__1 <queryProcessor>5__1 <>u__1 <Sublist>d__28`1 Nullable`1 IEnumerable`1 Task`1 ReadOnlyCollection`1 AsyncTaskMethodBuilder`1 IEqualityComparer`1 TaskAwaiter`1 IEnumerator`1 HashSet`1 List`1 get_Item1 <>7__wrap1 <>m__Finally1 <GetPeriodicTelemetry>d__32 kernel32 Microsoft.Win32 ToInt32 <telemetryQueries>5__2 Func`2 Tuple`2 KeyValuePair`2 IDictionary`2 ConcurrentDictionary`2 get_Item2 <>7__wrap2 <>m__Finally2 <queryCollectionName>5__3 <IdentifyCloudServicesAsync>d__3 Func`3 <GetPeriodicTelemetry>d__24 get_PagedMemorySize64 get_PrivateMemorySize64 get_WorkingSet64 UInt64 ToInt64 <errorsThisPeriod>5__4 <CheckCloudServiceAsync>d__4 <GetPeriodicTelemetry>d__25 <maxErrorsPerPeriod>5__5 <GetPeriodicTelemetry>d__26 SHA256 <>f__AnonymousType1`17 get_UTF8 <>9 <Module> <PrivateImplementationDetails> StretchDB NUMERIC TDE AVERAGE TELEMETRYFILENAME DATE STRING XML MSSQL BaseURL SUM MIN JSON System.IO P HADR MSOLAP_VER MSAS MDS QDS MSIS SSIS RLS strCopyrightITMS strCopyrightMS SYSTEM_INFORMATION_CLASS STATUS_INVALID_INFO_CLASS STATUS_SUCCESS TELEMETRYFILEFORMAT COUNT LAST MAX value__ ba pvExtraPolicyPara System.Data get_Data set_Data GetAggregatedData CoreData QueryableXEventData ConsumeNewData get_data mscorlib <>c System.Collections.Generic CheckCloudServiceAsync GetStringAsync IdentifyCloudServicesAsync _tc get_Id set_Id get_CurrentManagedThreadId <>l__initialThreadId get_InstanceId set_InstanceId GetNonWindowsInstanceId GetWindowsInstanceId get_InstanceUniqueId set_InstanceUniqueId get_instanceUniqueId get_MachineUniqueId set_MachineUniqueId get_SqmId set_SqmId GetSqmId get_SessionId set_SessionId get_sessionId get_CorrelationId set_CorrelationId get_correlationId GetCloudConnectorId GetDigitalProductId queryId ProductDiscoveryId Read _telemetryCollectorThread Add encoded _cantAccessDirLogged categoryFieldSpecified get_CategorySpecified set_CategorySpecified IsEnabled get_IsClustered set_IsClustered _lastAccessed AwaitUnsafeOnCompleted get_IsCompleted AlwaysEncrypted IsRegistryCaptureAllowed System.Collections.Specialized SafeHandleZeroOrMinusOneIsInvalid NewGuid get_rowGuid <data>i__Field <instanceUniqueId>i__Field <sessionId>i__Field <correlationId>i__Field <rowGuid>i__Field <isSSEIInstance>i__Field <sequence>i__Field <traceName>i__Field <roleName>i__Field <emitTime>i__Field <isInternalMachine>i__Field <instanceType>i__Field <operatingSystem>i__Field <schemaVersion>i__Field <oneSettingsVersion>i__Field <querySetVersion>i__Field <clientVersion>i__Field <queryIdentifier>i__Field <queryTimeInTicks>i__Field <rowStartIndex>i__Field <PartA_iKey>i__Field <query>i__Field get_Field set_Field fieldField packageField propertyNameField nameField dataTypeField predicateField <Data>k__BackingField <InstanceId>k__BackingField <InstanceUniqueId>k__BackingField <MachineUniqueId>k__BackingField <SqmId>k__BackingField <SessionId>k__BackingField <CorrelationId>k__BackingField <IsClustered>k__BackingField <AggregationField>k__BackingField <CloudService>k__BackingField <IsSSEIInstance>k__BackingField <SqlInstance>k__BackingField <Sequence>k__BackingField <IsConsoleMode>k__BackingField <ServerMode>k__BackingField <Name>k__BackingField <TraceName>k__BackingField <InstanceName>k__BackingField <RoleName>k__BackingField <ClusterNetworkName>k__BackingField <EtwApplicationName>k__BackingField <HostName>k__BackingField <SqlHostName>k__BackingField <IsInternalMachine>k__BackingField <ServiceType>k__BackingField <InstanceType>k__BackingField <AuthenticationString>k__BackingField <ConnectionString>k__BackingField <DnsHash>k__BackingField <LocalFilePath>k__BackingField <CycleLength>k__BackingField <IsInternal>k__BackingField <ProductLevel>k__BackingField <MetadataUrl>k__BackingField <ForceOptIn>k__BackingField <Version>k__BackingField <ASVersion>k__BackingField <SqlMajorVersion>k__BackingField <OsVersion>k__BackingField <ClientVersion>k__BackingField <HasPermission>k__BackingField <AggregationFunction>k__BackingField <Edition>k__BackingField <MachineInfo>k__BackingField <QueryIdentifier>k__BackingField <Fields>k__BackingField <MaxTelemetryCycles>k__BackingField <Values>k__BackingField <QueryTimeInTicks>k__BackingField <ForcedCredentials>k__BackingField <QueryCollections>k__BackingField <RequestHeaders>k__BackingField <HardMemoryLimit>k__BackingField <TotalMemoryLimit>k__BackingField <VertiPaqMemoryLimit>k__BackingField <LowMemoryLimit>k__BackingField <IsFast>k__BackingField <CommandTimeout>k__BackingField <Next>k__BackingField <IsLocalOnly>k__BackingField <Query>k__BackingField <DefaultCompatibility>k__BackingField HashPiiField DropPiiField versionField get_AggregationField set_AggregationField aggregationField actionField functionField groupingFieldsField aggregatesField PublishedEventField xEventField frequencyField periodicQueryField selectQueryField categoryField IndexBuild ReadToEnd DbCommand AdomdCommand SqlCommand Append MaxTracesPerSecond _maxTracesPerSecond set_IsBackground GetCurrentMethod <>3__fiveMinutePeriod Reserved44Keyword CriticalDataKeyword MeasuresKeyword TelemetryKeyword get_Cloud Replace IsNullOrWhiteSpace get_Namespace AddNamespace VersionBIDSHelpNamespace VersionHelpNamespace SendTrace get_StackTrace GetTrace get_Device get_CloudService set_CloudService SQLEnginePerformance get_IsSSEIInstance set_IsSSEIInstance get_isSSEIInstance IsClusteredInstance set_RoleInstance get_SqlInstance set_SqlInstance sqlInstance instance CriticalPersistence NormalPersistence get_Sequence set_Sequence _telemetrySequence get_sequence set_SyntheticSource Microsoft.Diagnostics.Tracing.EventSource TelemetryEventSource SqlServerTelemetrySource IntegrationServicesTelemetrySource AnalysisServicesTelemetrySource SetTelemetrySource _telemetrySource source GetHashCode get_ErrorCode _errorCode SqlProductFamilyCode FileMode get_IsConsoleMode set_IsConsoleMode isConsoleMode CompressionMode get_ServerMode set_ServerMode SelectSingleNode XmlNode Base64Decode get_Unicode Base64Encode UrlEncode get_Package set_Package Average _pqDataSourceUsage _componentUsage GetApplicationMemoryUsage get_Message exceptionMessage GetErrorMessage _errorMessage message AddRange PopulateQueryCollectionCache _queryCollectionCache _settingsCache Take GetSchemaTable DataTable get_NameTable XmlNameTable IsAvailable IEnumerable IDisposable ToDouble SafeHandle RuntimeTypeHandle ReleaseHandle GetTypeFromHandle SetHandle handle Single ProductLicenseFile file Tuple XName get_Name set_Name get_TraceName set_TraceName get_traceName get_InstanceName set_InstanceName _instanceName eventSourceName sourceName set_NodeName fileName get_RoleName set_RoleName get_roleName hiveName GetElementsByTagName get_ClusterNetworkName set_ClusterNetworkName GetClusterNetworkName get_ColumnName set_ColumnName get_EtwApplicationName set_EtwApplicationName queryCollectionName ConfConfigAppName get_ProcessName GetName get_HostName set_HostName GetUnsafeHostName get_SqlHostName set_SqlHostName hostName ConfConfigKeyName AssemblyName get_PropertyName set_PropertyName name OneTime DateTime _scaleoutExecutionTime _executionTime get_TotalProcessorTime get_emitTime ReadLine AppendLine get_NewLine Combine IAsyncStateMachine SetStateMachine stateMachine get_IsInternalMachine set_IsInternalMachine get_isInternalMachine set_Type get_DataType set_DataType GetFieldType SQLServiceType get_ServiceType set_ServiceType get_InstanceType set_InstanceType get_instanceType ValueType OfType get_DeclaringType LogType logType FunctionType serverType GetType GetElementType frequencyType categoryType EventLogEntryType FileShare Where System.Core ColumnStore get_InstalledUICulture set_DefaultThreadCurrentUICulture get_InvariantCulture set_DefaultThreadCurrentCulture databaseToUse CopySinksToUse MethodBase ServiceBase InternalDataCollectionBase get_InvariantCultureIgnoreCase get_OrdinalIgnoreCase ChangeDatabase Polybase HttpWebResponse GetResponse Close System.IDisposable.Dispose TryParse get_Predicate set_Predicate X509Certificate certificate AddOrUpdate Create XEventsXEventAggregate get_State DebuggerBrowsableState ConnectionState <>1__state Delete Write ClearFileContentOverwrite XAttribute CompilerGeneratedAttribute GeneratedCodeAttribute UnverifiableCodeAttribute DebuggableAttribute DebuggerBrowsableAttribute ComVisibleAttribute AssemblyKeyFileAttribute AssemblyTitleAttribute AssemblyKeyNameAttribute AsyncStateMachineAttribute IteratorStateMachineAttribute XmlTypeAttribute XmlIgnoreAttribute XmlAttributeAttribute DefaultValueAttribute DebuggerStepThroughAttribute AssemblyTrademarkAttribute TargetFrameworkAttribute SecurityCriticalAttribute XmlArrayItemAttribute XmlEnumAttribute DebuggerHiddenAttribute AssemblyDelaySignAttribute ExtensionAttribute AssemblyFileVersionAttribute AssemblyInformationalVersionAttribute SecurityPermissionAttribute AssemblyDescriptionAttribute CompilationRelaxationsAttribute HandleProcessCorruptedStateExceptionsAttribute ReliabilityContractAttribute AssemblyProductAttribute AssemblyCopyrightAttribute CLSCompliantAttribute XmlElementAttribute XmlRootAttribute AssemblyCompanyAttribute DesignerCategoryAttribute RuntimeCompatibilityAttribute SuppressUnmanagedCodeSecurityAttribute FiveMinute Byte get_Value currentReleaseTimeBombValue evalTimeBombValue GetOneSettingValue GetRawOneSettingValue MinValue GetValue defaultValue ConfConfigDefaultNotExistValue GetCpeRegistryValue GetRegistryValue GetFirstRegistryValue GetPropertyValue value GetRegistryHive hive get_Active toRemove sqlceip.exe _egressDataSize _ingressDataSize cbSize StructSize Serialize Deserialize size SizeOf IndexOf _eTag WerEventNameSetupConfig SHA256Cng Microsoft.Diagnostics.Tracing System.Threading Encoding DataMasking isUtcRunning System.Runtime.Versioning Autotuning DatabaseMirroring FromBase64String ToBase64String ASUsageMetricsRoleGuidString SqlEngineUsageMetricsRoleGuidString GetPrivateProfileString ProductCodeNameString ProductNameString LongProductNameBrandingString ProductNameShortcutBrandingString ToDebugString GetQueryGroupsFromXmlString xmlString ProductVersionString get_AuthenticationString set_AuthenticationString authenticationString ProductVersionLocationString get_ConnectionString set_ConnectionString connectionString ByteArrayToString GetString inputString Substring SQLOSCLRHosting WriteLocalLog WriteLocalErrorLog EventLog InitializeBatch GetSHA256Hash ComponentWiseHash ComputeHash GetSHA256CngHash ComputeStringHash get_DnsHash set_DnsHash Refresh Flush Math get_LocalFilePath set_LocalFilePath localFilePath filePath GetFullPath registryPath path get_Length get_CycleLength set_CycleLength SetLength length EndsWith StartsWith HashPii MarkPii DropPii TelemetryApi WerEventNameSetupMsi obj RemoteCertificateValidationCallback set_ServerCertificateValidationCallback FiveMinutePeriodsInAWeek UtcTelemetrySink FileTelemetrySink AppInsightTelemetrySink get_Task get_Local Marshal Spatial Decimal <>3__original get_IsInternal set_IsInternal Temporal val set_Model System.Collections.ObjectModel System.ComponentModel Microsoft.ApplicationInsights.Channel ITelemetryChannel get_TelemetryChannel SPLevel set_Level get_ProductLevel set_ProductLevel EventLevel Util _util WhenAll crypt32.dll ntdll.dll DBNull System.Xml LoadXml ParseXml GetNewQueryCollectionXml _xEventAggregationsXml Microsoft.Cloud.Sql.Analytics.BoxTelemetry.PeriodicQueries.xml Microsoft.Cloud.Sql.Analytics.BoxTelemetry.SSASPeriodicQueries.xml Microsoft.Cloud.Sql.Analytics.BoxTelemetry.PerDbPeriodicQueries.xml Microsoft.Cloud.Sql.Analytics.BoxTelemetry.SSASPerDbPeriodicQueries.xml Microsoft.Cloud.Sql.Analytics.BoxTelemetry.XeQueries.xml Microsoft.Cloud.Sql.Analytics.BoxTelemetry.SSISXeQueries.xml Microsoft.Cloud.Sql.Analytics.BoxTelemetry.MachineInfoQueries.xml Microsoft.Cloud.Sql.Analytics.BoxTelemetry.XEventAggregations.xml get_MetadataUrl set_MetadataUrl CloudServiceMetadataUrl _cloudServiceMetadataUrl url GetManifestResourceStream FileStream GetResponseStream GetQueryGroupsFromStream GZipStream MemoryStream stream get_Item set_Item item set_OperatingSystem get_operatingSystem HashAlgorithm Trim IsEnabledOnCrossPlatform GetLocalAuditDirectoryForCrossPlatform IsCrossPlatform isCrossPlatform Sum Enum _sum get_ForceOptIn set_ForceOptIn _forceOptIn CheckIfSqlServiceSettingIsOn AlwaysOn Boolean TimeSpan InjectXToken VersionHelpSettingsToken Open Flatten Min TelemetryCollectorMain X509Chain CertFreeCertificateChain CheckChain SafeFreeCertChain chain Login _min Join DataColumn con GetExtension GetFileNameWithoutExtension get_ASVersion set_ASVersion get_OSVersion get_Version set_Version SchemaVersion get_schemaVersion BuildVersion MaxMaintenanceVersion get_FileVersion SqlMajorFileVersion GetFileVersion AzulJreVersion VisualStudio2012ShellVersion VisualStudioShellVersion get_SqlMajorVersion set_SqlMajorVersion _sqlMajorVersion MinorVersion get_OsVersion set_OsVersion GetOsVersion get_OneSettingsVersion set_OneSettingsVersion CurrentOneSettingsVersion get_oneSettingsVersion get_ProductVersion GetProductVersion get_querySetVersion get_ClientVersion set_ClientVersion get_clientVersion get_Session ResetSession System.IO.Compression get_HasPermission set_HasPermission get_Location ConfConfigDefaultFileLocation get_Aggregation set_Aggregation XEventsXEventAggregateAggregation DataClassifciation NtQuerySystemInformation GetSystemHostOsDistributionInformation destination get_Operation ServerConfiguration TelemetryConfiguration Microsoft.ApplicationInsights.Extensibility.Implementation System.Globalization System.Xml.Serialization System.Web.Script.Serialization Optimization get_Action set_Action SecurityAction op_Subtraction System.Reflection DataTableCollection NameValueCollection DataColumnCollection AdomdRestrictionCollection WebHeaderCollection ManagementObjectCollection X509ChainElementCollection DataRowCollection KeyCollection isQueryCollection set_Connection DbConnection AdomdConnection SqlConnection section AdomdRestriction get_Function set_Function get_AggregationFunction set_AggregationFunction get_Edition set_Edition IsEvaluationEdition _lastSessionDefinition _sessionDefinition set_Position _telemetryInfoOption IOException NotSupportedException AggregateException ExternalException ArgumentNullException SqlException get_InnerException OneSettingsException SetException HttpRequestException TelemetryException exception System.Runtime.ConstrainedExecution System.Data.Common StringComparison Run ASInstanceInfo FileInfo get_MachineInfo set_MachineInfo _machineInfo TimeZoneInfo CultureInfo FileVersionInfo GetVersionInfo AssemblyVersionInfo MemberInfo GetSqlServerInfo info Zero Sleep sqlceip Skip OnStop cpp System.Net.Http Backup AvailabilityGroup kvp System.Xml.Linq System.Linq Microsoft.SqlServer.XEvent.Linq <data>j__TPar <instanceUniqueId>j__TPar <sessionId>j__TPar <correlationId>j__TPar <rowGuid>j__TPar <isSSEIInstance>j__TPar <sequence>j__TPar <traceName>j__TPar <roleName>j__TPar <emitTime>j__TPar <isInternalMachine>j__TPar <instanceType>j__TPar <operatingSystem>j__TPar <schemaVersion>j__TPar <oneSettingsVersion>j__TPar <querySetVersion>j__TPar <clientVersion>j__TPar <queryIdentifier>j__TPar <queryTimeInTicks>j__TPar <rowStartIndex>j__TPar <PartA_iKey>j__TPar <query>j__TPar Clear Char Cer get_Number LoginDisabledErrorNumber LoginFailErrorNumber DbDataReader AdomdDataReader SqlDataReader ExecuteReader StreamReader TextReader PeriodicQueryReader IFormatProvider StringBuilder get_TelemetryProcessorChainBuilder <>t__builder SetFolder GetLocalAuditFolder SetupSupportFolder _lastFolder _folder sender XmlNamespaceManager _logger ManagementObjectSearcher get_QueryIdentifier set_QueryIdentifier get_queryIdentifier ServiceBroker System.CodeDom.Compiler XContainer OneSettingsHelper XEGrouper StringComparer ChainPolicyParameter GetAwaiter StreamWriter TextWriter Enter loopCounter IncrementCounter GetRecordsFromEventCounter _scaleoutExecutionMaster server XmlSerializer _jsonSerializer JavaScriptSerializer get_Major ResourceGovernor SendError dwError _error SSISXeQueryProcessor _ssisXeQueryProcessor sqlQueryProcessor MachineInfoQueryProcessor GetQueryProcessor XeSessionTelemetryQueryProcessor PerDbSSASServerTelemetryQueryProcessor PerDbSqlServerTelemetryQueryProcessor ITelemetryProcessor ClearNodeNameTelemetryProcessor ServerCertificateValidator IEnumerator System.Collections.Generic.IEnumerable<System.Collections.Generic.IEnumerable<T>>.GetEnumerator System.Collections.Generic.IEnumerable<Microsoft.Cloud.Sql.Analytics.BoxTelemetry.Telemetry>.GetEnumerator System.Collections.IEnumerable.GetEnumerator .ctor .cctor Monitor IntPtr FiveMinutePeriodsInAnHour System.Diagnostics get_Fields set_Fields get_GroupingFields set_GroupingFields FromSeconds NativeMethods _periods _nonAggregateRecords GetRecords _maxRecords set_Keywords EventKeywords System.Runtime.ExceptionServices System.Runtime.InteropServices System.Runtime.CompilerServices DebuggingModes PeriodicQueries Microsoft.SqlServer.Test.Utilities get_Tables ExpandEnvironmentVariables get_MaxTelemetryCycles set_MaxTelemetryCycles Microsoft.Win32.SafeHandles ReadFromXEFiles GetFiles obscureNames GetValueNames System.Security.Cryptography.X509Certificates get_Aggregates set_Aggregates _fileContentOverwrites FromMinutes GetBytes get_Values set_Values GetRegistrySettingValues GetRegistryValues set_Tags EventFieldTags EventTags set_Flags dwFlags EventSourceSettings GetMaxTracesPerSecondFromOneSettings GetValuesFromOneSettings QueryOneSettings settings ParseInputArgs RemoveFromInputArgs args cloudPaths _cloudServicePaths AllowedregistryPaths <>4__this get_Ticks get_QueryTimeInTicks set_QueryTimeInTicks get_queryTimeInTicks SetTelemetrySinks _telemetrySinks sinks System.Threading.Tasks get_ForcedCredentials set_ForcedCredentials forcedCredentials Equals Protocols cloudMetadataUrls GetEncodedQueryParams queryParams Dns Contains _nonPIIColumns get_Columns System.Web.Extensions TelemetryContextExtensions DictionaryExtensions System.Security.Permissions ParseXEventAggregations _aggregations System.Collections get_QueryCollections set_QueryCollections FeatureRestrictions WindowRankingFunctions _evaluationEditions CriticalDataOptions EventSourceOptions MeasuresOptions BoxTelemetryOptions RecordExceptions get_InnerExceptions GetExceptions _exceptions _options GetQueryGroups get_Chars System.Net.Http.Headers get_Headers HttpHeaders get_RequestHeaders set_RequestHeaders HttpRequestHeaders get_DefaultRequestHeaders requestHeaders _perfCounters _eventCounters SslPolicyErrors sslPolicyErrors infoClass set_PriorityClass ProcessPriorityClass FileAccess System.ServiceProcess _executionProcess _thisProcess GetCurrentProcess set_EndpointAddress Compress Microsoft.ApplicationInsights.DataContracts Microsoft.ApplicationInsights telemetryTraits SetProcessResourceLimits Descendants get_ChainElements GetContents XEvents Exists NtStatus pvExtraPolicyStatus ChainPolicyStatus get_Rows get_TotalDays RefreshIntervalInDays get_Keys RemoveAt Concat AppendFormat ManagementBaseObject DeserializeObject ManagementObject Select dict Get System.Net GetSchemaDataSet set_MaxWorkingSet System.Collections.IEnumerator.Reset DateTimeOffset Wait op_Implicit op_Explicit Audit Split get_HardMemoryLimit set_HardMemoryLimit get_TotalMemoryLimit set_TotalMemoryLimit get_VertiPaqMemoryLimit set_VertiPaqMemoryLimit get_LowMemoryLimit set_LowMemoryLimit Exit get_Default get_Result _scaleoutExecutionResult _executionResult GetResult SetResult NextResult ToUpperInvariant ToLowerInvariant Microsoft.AnalysisServices.AdomdClient System.Data.SqlClient HttpClient TelemetryClient System.Management XElement XmlElement get_DocumentElement SetTelemetryEnvironment XDocument XmlDocument System.Collections.Generic.IEnumerator<System.Collections.Generic.IEnumerable<T>>.Current System.Collections.Generic.IEnumerator<Microsoft.Cloud.Sql.Analytics.BoxTelemetry.Telemetry>.Current System.Collections.IEnumerator.Current System.Collections.Generic.IEnumerator<System.Collections.Generic.IEnumerable<T>>.get_Current System.Collections.Generic.IEnumerator<Microsoft.Cloud.Sql.Analytics.BoxTelemetry.Telemetry>.get_Current System.Collections.IEnumerator.get_Current <>2__current System.Collections.Concurrent GetFileContent SetFileContent GetContent content get_XEvent set_XEvent XEventsXEvent PublishedEvent TrackEvent get_Count _scaleoutMaxExecutedCount get_FieldCount _count ThreadStart OnStart Convert MaxLinuxTcpPort get_IsFast set_IsFast isFast Last _last HttpWebRequest _dbList FieldList XmlNodeList ToList Sublist First get_CommandTimeout set_CommandTimeout SqlCommandTimeout commandTimeout input get_Next set_Next MoveNext System.Text AppendText AppendAllText get_InnerText next get_Context CloudContext DeviceContext GetInternalContext get_ChainContext pChainContext chainContext SessionContext OperationContext TelemetryContext v RegistryView view get_Now get_UtcNow DataRow NewRow Max _max lChainIndex lElementIndex get_rowStartIndex SqlInstanceIDPrefix AsInstanceIDPrefix RsInstanceIDPrefix VersionHelpKeywordPrefix FileVersionSuffix FiveMinutePeriodsInADay GetFileNameForToday ToArray get_IsArray CertVerifyCertificateChainPolicy VerifyChainPolicy policy RealtimeLatency NormalLatency Consistency get_Frequency set_Frequency <>3__frequency _partAIKey get_Key OpenSubKey subKey OpenBaseKey hiveKey oneSettingKey get_PartA_iKey set_InstrumentationKey ContainsKey RegistryKey key System.Security.Cryptography GetExecutingAssembly get_IsLocalOnly set_IsLocalOnly isLocalOnly Any ToDictionary ClearDictionary get_Query set_Query get_PeriodicQuery set_PeriodicQuery PeriodicQueriesPeriodicQuery ExecuteNonQuery registrySettingsToQuery get_SelectQuery set_SelectQuery selectQuery get_query AcceleratedDatabaseRecovery get_Category set_Category ProductUpdateCategory PagedMemory PhysicalMemory InMemory _telemetryDirectory Inventory Microsoft.Diagnostics.Telemetry ITelemetry GetPeriodicTelemetry SendTelemetry GetCloudCollectorTelemetry Microsoft.Cloud.Sql.Analytics.BoxTelemetry telemetry WriteEntry IPHostEntry GetHostEntry GetInstanceSpecificRegistry get_Capacity op_Equality op_Inequality Programmability Microsoft.ApplicationInsights.Extensibility get_DefaultCompatibility set_DefaultCompatibility WebUtility LowestDeadLockPriority System.Security System.Net.Security IsNullOrEmpty �9{ { P a r t A _ i K e y = { 0 } , r o l e N a m e = { 1 } , c l i e n t V e r s i o n = { 2 } , i s I n t e r n a l M a c h i n e = { 3 } , s e s s i o n I d = { 4 } , o p e r a t i n g S y s t e m = { 5 } , t r a c e N a m e = { 6 } , d a t a = { 7 } , r o w G u i d = { 8 } , r o w S t a r t I n d e x = { 9 } , q u e r y I d e n t i f i e r = { 1 0 } , s e q u e n c e = { 1 1 } , s c h e m a V e r s i o n = { 1 2 } , e m i t T i m e = { 1 3 } , q u e r y T i m e I n T i c k s = { 1 4 } , o n e S e t t i n g s V e r s i o n = { 1 5 } , c o r r e l a t i o n I d = { 1 6 } , i n s t a n c e U n i q u e I d = { 1 7 } , i s S S E I I n s t a n c e = { 1 8 } , i n s t a n c e T y p e = { 1 9 } } } ��{ { i n s t a n c e U n i q u e I d = { 0 } , i s S S E I I n s t a n c e = { 1 } , i n s t a n c e T y p e = { 2 } , s c h e m a V e r s i o n = { 3 } , e m i t T i m e = { 4 } , s e s s i o n I d = { 5 } , c o r r e l a t i o n I d = { 6 } , s e q u e n c e = { 7 } , c l i e n t V e r s i o n = { 8 } , i s I n t e r n a l M a c h i n e = { 9 } , o p e r a t i n g S y s t e m = { 1 0 } , q u e r y S e t V e r s i o n = { 1 1 } , t r a c e N a m e = { 1 2 } , q u e r y I d e n t i f i e r = { 1 3 } , d a t a = { 1 4 } , q u e r y = { 1 5 } , q u e r y T i m e I n T i c k s = { 1 6 } } } . )C o u l d n o t r e a d f r o m UU n a b l e t o p a r s e G e t Q u e r y G r o u p s F r o m S t r e a m : M a x R e c o r d s 3S E T D E A D L O C K _ P R I O R I T Y - 1 0 =O p e n f a i l e d w i t h e r r o r n u m b e r QC h a n g e D a t a b a s e f a i l e d w i t h e r r o r n u m b e r
c m p r s _ OE x e c u t e R e a d e r f a i l e d w i t h e r r o r n u m b e r
m a s t e r �/S E L E C T T O P 3 0 d . [ n a m e ]
F R O M s y s . d a t a b a s e s d W I T H ( n o l o c k )
I N N E R J O I N s y s . m a s t e r _ f i l e s m f W I T H ( n o l o c k )
O N m f . d a t a b a s e _ i d = d . d a t a b a s e _ i d
L E F T O U T E R J O I N s y s . d a t a b a s e _ m i r r o r i n g d m W I T H ( n o l o c k )
O N d m . d a t a b a s e _ i d = d . d a t a b a s e _ i d
L E F T O U T E R J O I N s y s . d m _ h a d r _ d a t a b a s e _ r e p l i c a _ s t a t e s h a d r W I T H ( n o l o c k )
O N h a d r . [ d a t a b a s e _ i d ] = d . [ d a t a b a s e _ i d ]
W H E R E d . [ s t a t e ] N O T B E T W E E N 1 A N D 6 - - o n l i n e o n l y
A N D d . [ u s e r _ a c c e s s ] N O T I N ( 1 , 2 ) - - m u l t i u s e r
A N D d . [ s o u r c e _ d a t a b a s e _ i d ] I S N U L L - - n o t s n a p s h o t
A N D d . [ n a m e ] N O T I N ( ' m a s t e r ' , ' t e m p d b ' , ' m o d e l ' , ' m s d b ' ) - - n o t s y s t e m
A N D I S N U L L ( d m . [ m i r r o r i n g _ r o l e ] , 1 ) = 1 - - e i t h e r p r i n c i p a l o r n o t m i r r o r e d
A N D d . [ i s _ i n _ s t a n d b y ] = 0 - - n o t s t a n d b y
A N D D A T A B A S E P R O P E R T Y E X ( d . [ n a m e ] , ' C o l l a t i o n ' ) I S N O T N U L L - - s t a r t e d
A N D I S N U L L ( h a d r . [ d a t a b a s e _ s t a t e ] , 0 ) = 0 - - o n l i n e i n H A D R
G R O U P B Y d . [ n a m e ]
O R D E R B Y S U M ( m f . s i z e ) D E S C - - s a m p l i n g u s i n g s i z e
n a m e M e s s a g e -X E v e n t A g g r e g a t i o n s . x m l x e c o l l e c t �#S E L E C T t a r g e t _ d a t a
F R O M s y s . d m _ x e _ s e s s i o n _ t a r g e t s x e t W I T H ( n o l o c k )
J O I N s y s . d m _ x e _ s e s s i o n s x e s W I T H ( n o l o c k )
O N x e s . a d d r e s s = x e t . e v e n t _ s e s s i o n _ a d d r e s s
W H E R E x e s . n a m e = ' t e l e m e t r y _ x e v e n t s '
A N D x e t . t a r g e t _ n a m e = ' r i n g _ b u f f e r ' t a r g e t _ d a t a W a r n i n g N o t a r g e t _ d a t a . )R e s e t S e s s i o n f a i l e d � i f n o t e x i s t s ( s e l e c t * f r o m s y s . d m _ x e _ s e s s i o n s w h e r e n a m e = ' t e l e m e t r y _ x e v e n t s ' )
a l t e r e v e n t s e s s i o n t e l e m e t r y _ x e v e n t s o n s e r v e r s t a t e = s t a r t e v e n t d a t a v a l u e
a c t i o n p a c k a g e N a m e 'A g g r e g a t i o n F u n c t i o n C O U N T !A g g r e g a t i o n F i e l d V e r s i o n F i e l d F i e l d { 0 } = { 1 } , F i e l d M a p p i n g A g g r e g a t e d V a l u e CG e t V a l u e s F r o m O n e S e t t i n g s f a i l e d : �qi f e x i s t s ( s e l e c t * f r o m s y s . s e r v e r _ e v e n t _ s e s s i o n s w h e r e n a m e = ' t e l e m e t r y _ x e v e n t s ' )
d r o p e v e n t s e s s i o n t e l e m e t r y _ x e v e n t s o n s e r v e r
c r e a t e e v e n t s e s s i o n t e l e m e t r y _ x e v e n t s o n s e r v e r
- A D D E V E N T [ { 0 } ] . [ { 1 } ] (
W H E R E { 0 }
) )(
A C T I O N ( [ { 0 } ] )
) , �� A D D E V E N T [ s q l s e r v e r ] . [ s e r v e r _ s t a r t _ s t o p ]
a d d t a r g e t p a c k a g e 0 . r i n g _ b u f f e r
( s e t o c c u r r e n c e _ n u m b e r = 1 0 0 )
w i t h
(
M A X _ D I S P A T C H _ L A T E N C Y = 1 2 0 S E C O N D S ,
M A X _ M E M O R Y = 4 M B ,
s t a r t u p _ s t a t e = o n
)
i f n o t e x i s t s ( s e l e c t * f r o m s y s . d m _ x e _ s e s s i o n s w h e r e n a m e = ' t e l e m e t r y _ x e v e n t s ' )
a l t e r e v e n t s e s s i o n t e l e m e t r y _ x e v e n t s o n s e r v e r s t a t e = s t a r t | 0 X M L A : I n s t a n c e O n c e I n s t a n c e D a y S e r v e r M o d e E d i t i o n A S V e r s i o n P r o d u c t L e v e l )D e f a u l t C o m p a t i b i l i t y H a r d M e m o r y L i m i t !T o t a l M e m o r y L i m i t L o w M e m o r y L i m i t 'V e r t i P a q M e m o r y L i m i t C o l u m n N a m e A N D [ ] = ' ' 'C o m p a t i b i l i t y _ L e v e l T y p e T a b l e I D H i e r a r c h y I D ��S E L E C T [ C A T A L O G _ N A M E ] a s [ F o r E a c h D B I D ] , 1 a s [ C o u n t D B ] F R O M $ S y s t e m . D B S c h e m a _ C a t a l o g s F o r E a c h D B I D { D B N a m e } ' '' a s [ D a t a b a s e _ I D ] 9% P r o g r a m D a t a % \ S S I S T e l e m e t r y \ !S Q L I S S e r v i c e { 0 } 0 E v e n t N a m e )M a x N u m O f F i l e s R e a c h e d
N u m b e r I n t V a l u e 1 I n t V a l u e 2 I n t V a l u e 3 I n t V a l u e 4 G u i d S t r i n g V a l u e 1 S t r i n g V a l u e 2 L o n g V a l u e I n g r e s s D a t a S i z e E g r e s s D a t a S i z e C o m p o n e n t U s a g e !P a c k a g e E x e c u t i o n E r r o r C o d e O n C l o u d S e r v i c e N u m O f W o r k e r s )S c a l e O u t T a s k C o m p l e t e 3P o w e r Q u e r y D a t a S o u r c e U s a g e C o m p o n e n t
R e s u l t N u m O f E n a b l e d N u m O f D i s a b l e d /S c a l e O u t E x e c u t i o n M a s t e r
M a s t e r +S c a l e O u t E x e c u t i o n T i m e T i m e 1S c a l e O u t M a x E x e c u t e d C o u n t /S c a l e o u t E x e c u t i o n R e s u l t E x e c u t e d C o u n t D a t a S o u r c e K i n d %A u t h e n t i c a t i o n K i n d !E x e c u t i o n P r o c e s s P r o c e s s E x e c u t i o n T i m e E x e c u t i o n R e s u l t S i z e c l o u d s e r v i c e
o s i n f o r e g i s t r y k e y s - > =q u e r y e n c o u n t e r e d a n e x c e p t i o n o s l a n g u a g e o s t i m e z o n e gQ u e r y n o t i m p l e m e n t e d i n M a c h i n e I n f o Q u e r y P r o c e s s o r . !R e g i s t r y S e t t i n g s ;R e g i s t r y S e t t i n g s F o r N o n W i n d o w s IN o R e g i s t r y S e t t i n g f r o m O n e s e t t i n g s
a m a z o n ]h t t p : / / 1 6 9 . 2 5 4 . 1 6 9 . 2 5 4 / l a t e s t / m e t a - d a t a / a m i - i d o p e n S t a c k mh t t p : / / 1 6 9 . 2 5 4 . 1 6 9 . 2 5 4 / o p e n s t a c k / l a t e s t / m e t a _ d a t a . j s o n a z u r e h t t p : / / 1 6 9 . 2 5 4 . 1 6 9 . 2 5 4 / m e t a d a t a / i n s t a n c e ? a p i - v e r s i o n = 2 0 1 8 - 1 0 - 0 1 M e t a d a t a T r u e U s e r - A g e n t S Q L S e r v e r C E I P
g o o g l e ��h t t p : / / m e t a d a t a . g o o g l e . i n t e r n a l / c o m p u t e M e t a d a t a / v 1 / p r o j e c t / p r o j e c t - i d M e t a d a t a - F l a v o r
G o o g l e r a c k s p a c e 5C : \ P r o g r a m F i l e s \ R a c k s p a c e %M a c h i n e I n f o Q u e r i e s W o r k i n g S e t 6 4 #P a g e d M e m o r y S i z e 6 4 %T o t a l P r o c e s s o r T i m e 9N o Q u e r y P r o c e s s o r f o u n d f o r . x m l !C l o u d C o n n e c t o r I d 5B a d x m l f r o m O n e S e t t i n g s : T e l e m e t r y !C u s t o m e r F e e d b a c k 7c : \ v a r \ o p t \ m s s q l \ m s s q l . c o n f f a l s e AU s e r R e q u e s t e d L o c a l A u d i t D i r e c t o r y ;e n t e r p r i s e e v a l u a t i o n e d i t i o n #d e v e l o p e r e d i t i o n e x p r e s s e d i t i o n S Q L S e r v e r M S S Q L $ M S S Q L S E R V E R uS e r v e r = { 0 } ; I n i t i a l C a t a l o g = m a s t e r ; A p p l i c a t i o n N a m e = { 1 } ; { 2 } S Q L S e r v e r C E I P P e r i o d i c Q u e r i e s )P e r D b P e r i o d i c Q u e r i e s X e Q u e r i e s ��S E L E C T n a m e , v a l u e F R O M s y s . e x t e n d e d _ p r o p e r t i e s W H E R E n a m e = ' M S _ S Q L C E I P S E R V I C E S E T T I N G S ' ; 3M S _ S Q L C E I P S E R V I C E S E T T I N G S 1 S e t u p !D i g i t a l P r o d u c t I d KS Q L S e r v e r C E I P e n c o u n t e r e d a p r o b l e m : C P E %E v a l u a t i o n E d i t i o n s YS O F T W A R E \ M i c r o s o f t \ M i c r o s o f t S Q L S e r v e r \ { 0 } \ uS O F T W A R E \ M i c r o s o f t \ M i c r o s o f t S Q L S e r v e r \ I n s t a n c e N a m e s \ S Q L +\ \ . \ p i p e \ S Q L L o c a l \ { 0 } ;\ \ . \ p i p e \ S Q L L o c a l \ M S S Q L S E R V E R n e t w o r k t c p p o r t D e f a u l t N o t E x i s t , { 0 } { 0 } \ { 1 } )S Q L _ E n g i n e _ C o r e _ I n s t qS O F T W A R E \ M i c r o s o f t \ M i c r o s o f t S Q L S e r v e r \ { 0 } \ C l u s t e r S t a t e 1A n a l y s i s S e r v i c e s / S e r v e r / GD a t a S o u r c e = { 0 } ; A p p l i c a t i o n N a m e = { 1 } 'S S A S P e r i o d i c Q u e r i e s 1S S A S P e r D b P e r i o d i c Q u e r i e s )A n a l y s i s _ S e r v e r _ F u l l ��S O F T W A R E \ M i c r o s o f t \ M i c r o s o f t S Q L S e r v e r \ M S A S { 0 } . { 1 } \ C l u s t e r S t a t e C l u s t e r N a m e wS O F T W A R E \ M i c r o s o f t \ M i c r o s o f t S Q L S e r v e r \ M S A S { 0 } . { 1 } \ C l u s t e r wS O F T W A R E \ M i c r o s o f t \ M i c r o s o f t S Q L S e r v e r \ I n s t a n c e N a m e s \ O L A P _S O F T W A R E \ M i c r o s o f t \ M i c r o s o f t S Q L S e r v e r \ { 0 } \ C P E S S I S X e Q u e r i e s YS O F T W A R E \ M i c r o s o f t \ M i c r o s o f t S Q L S e r v e r \ { 0 } 0
S S E I U I S S E I d e f a u l t 2 A - M S T e l D e f a u l t 9 C o l l e c t e d 3M i c r o s o f t . S q l . S e r v e r . C e i p Yh t t p s : / / v o r t e x . d a t a . m i c r o s o f t . c o m / c o l l e c t / v 1 QA I F - 6 0 c 2 5 5 2 d - b 6 1 9 - 4 9 2 5 - 8 d 6 6 - 3 0 e c 0 b 8 3 d 0 9 d S c h e m a V e r s i o n Q u e r y I d e n t i f i e r C o r r e l a t i o n I d #T e l e m e t r y S e q u e n c e !Q u e r y T i m e I n T i c k s D a t a ] y y y y - M M - d d . j s o n o -: : A p p l i c a t i o n S e t t i n g s : %: : Q u e r y C o l l e c t i o n : [0 o r n e g a t i v e n u m b e r f r o m o n e s e t t i n g s { 0 } { 1 } EC o n v e r t . T o I n t 3 2 f a i l e d f o r { 0 } { 1 } 3d e f a u l t V a l u e i s n u l l f o r [P r o b l e m s p l i t t i n g s t r i n g t o a r r a y { 0 } { 1 } { 2 } !M i s s i n g s e t t i n g I f - N o n e - M a t c h E T a g ��h t t p s : / / s e t t i n g s - w i n . d a t a . m i c r o s o f t . c o m / s e t t i n g s / v 2 . 0 / s q l s e r v e r / s q l s e r v e r c e i p s c e n a r i o I d a p p
a p p V e r o s W i n d o w s d e v i c e I d s : s e t t i n g s /S e t t i n g r e f r e s h f a i l e d ? & { 0 } = { 1 } 1 . 0 . 0 . 0 1I n t e g r a t e d S e c u r i t y = S S P I 1 2 7 . 0 . 0 . 1 l o c a l h o s t L o c a l H o s t EG e t U n s a f e H o s t N a m e _ T h r o w s _ E x c e p t i o n I n s t a l l I D sS O F T W A R E \ M i c r o s o f t \ M i c r o s o f t S Q L S e r v e r \ I n s t a n c e N a m e s \ R S - M{ 2 7 0 0 e b 3 9 - 5 f f 0 - 4 c 2 2 - a 1 d c - a 2 9 7 6 f 3 9 3 e a b } / \ Ic : \ v a r \ o p t \ m s s q l \ . s y s t e m \ i n s t a n c e _ i d %R e a c h e s F i l e C o n t e n t 3M a l f o r m e d K e y V a l u e s t r i n g 7F i l e p a t h d o e s n o t e x i s t : ?U n a b l e t o g e t d a t a , e x c e p t i o n : . m i c r o s o f t . c o m #. s y s - s q l s v r . l o c a l 1F a i l e d t o q u e r y O S i n f o .
{ 0 : x 2 } X 2 L o c a l M a c h i n e C l a s s e s R o o t C u r r e n t C o n f i g C u r r e n t U s e r P e r f o r m a n c e D a t a U s e r s AS O F T W A R E ; H A R D W A R E ; S Y S T E M ; C o n t r o l A r g s ; S t a c k T r a c e 7S Q L S e r v e r U n h a n d l e d E x c e p t i o n iS q l C e i p s t a r t e d p i d : { 0 } i n s t a n c e : { 1 } C P E F l a g : { 2 } b o t h S i n k T o U s e s q l c e i p gB o t h s o u r c e a n d d e s t i n a t i o n h a v e t o b e i n i t i a l i z e d . a i u t c E x c e p t i o n Q u e r y I d E r r o r S t a t e E r r o r N u m b e r - s e r v i c e - f o r c e o p t i n - d i r P a t h
- l o c a l - f a s t GS E L E C T * F R O M W i n 3 2 _ O p e r a t i n g S y s t e m U n k n o w n MO S q u e r y h a d e n c o u n t e r e d a n e x c e p t i o n . O b j e c t E x p a n s i o n E x p a n d O b j e c t +D I S C O V E R _ X M L _ M E T A D A T A {h t t p : / / s c h e m a s . m i c r o s o f t . c o m / a n a l y s i s s e r v i c e s / 2 0 1 1 / e n g i n e / 3 0 0 sh t t p : / / s c h e m a s . m i c r o s o f t . c o m / a n a l y s i s s e r v i c e s / 2 0 0 3 / e n g i n e 3D e f a u l t C o m p a t i b i l i t y L e v e l {h t t p : / / s c h e m a s . m i c r o s o f t . c o m / a n a l y s i s s e r v i c e s / 2 0 1 2 / e n g i n e / 4 0 0 a s k/ / a s : S e r v e r P r o p e r t y [ a s : N a m e = ' M e m o r y \ H a r d M e m o r y L i m i t ' ] )d e s c e n d a n t : : a s : V a l u e m/ / a s : S e r v e r P r o p e r t y [ a s : N a m e = ' M e m o r y \ T o t a l M e m o r y L i m i t ' ] i/ / a s : S e r v e r P r o p e r t y [ a s : N a m e = ' M e m o r y \ L o w M e m o r y L i m i t ' ] s/ / a s : S e r v e r P r o p e r t y [ a s : N a m e = ' M e m o r y \ V e r t i P a q M e m o r y L i m i t ' ] %M a x T r a c e s P e r S e c o n d T r a c e N a m e : { 0 } %C o r r e l a t i o n I d : { 0 } )Q u e r y I d e n t i f i e r : { 0 } Q u e r y : { 0 } D a t a :
E T W _ G R O U P M{ 5 E C B 0 B A C - B 9 3 0 - 4 7 F 5 - A 8 A 4 - E 8 2 5 3 5 2 9 E D B 7 } 5W r o n g u s e . N o t I m p l e m e n t e d P a r s e E r r o r : t e l e m e t r y _ x e l o g . x e l IP o p u l a t e Q u e r y C o l l e c t i o n C a c h e f a i l e d C o u n t e r N a m e T o t a l S a m p l e s M i n M a x A v e r a g e P e r f C o u n t e r s %M a x E r r o r s P e r P e r i o d ;T o o m a n y e r r o r s t h i s p e r i o d : C a p t i o n �f��e�(I�����ps$ Q e �E �U ���� �m�� �� � ���m �m�m ����,
.
� � ��������� �
� � �
������ R(
� &
(
F"
�� ��
�! �E �) �� ���� ���� �E�- ���� ��
���� ����6������������������������ �� �� �� �E �E �E�E �I � �Q ����
���U �Y �� �m
�� ��������@ �� ����
�m ����(
��T����(����( ���������� :��������(���� ,, 4T�� �e �i
�m���i�m������ �q�i �m
��%������T��T���� ��
��T�� ��
��T�� �� ����������(��-
����$��(������( (( �� ��
�� �� ��S������������� � �
���
� �
����� �� � � �y �� �
�
�
�� �
� � ��
�� .�������������� ������� ����� ����
����
������ ���� �q
�q �y�� �������� �!�%���)�)�
��- ������ ����������� ���� �=�m �m �=
�m �m �!������
���)���) �����
��
���
��
�� �� �� �� ���� �� �� �� � :����������� ����� ��������
�������������������������5�9�����5�9���9�������5���9���9������� �5��� �9��� ��������� �5����� �9����� ���9���9���9����
�5
�9
��
�����5���9���9���9���9�� �5 �5 �9 �9�5�9
�5��
�9���5��� �9��� �5����� �9����� �5
�9
�5��
�9��& �����A���������A ��
������������ �� ���M�M �M 0
�� �A ���M�� �M��
����hD��D��
���� �� ����
��
�e����D��D��D �� ���� DDP��
� �������y
�y �m �� �� � �� �� DD�� � �� �} ���}������ �m ���E���m���m��� ����
�m�m�����m�� � �� ����
+
0�� !
����
�� �� � � �� �� �� �=���� ���=���� �� ���� � � � �
(���m���m��
��
��
��
�� �!�� ��
�Y
���� ���� *
�m����
��%
�m����
%
���� ��
�� ��
�=�9
%�� �m �= �=
�9
�������� � � �% �) ���q���� �q����
���5�9�5�9��
�� �( �5�e
�� ������ �� �m
�� �= �E���} (
�����5�9��0 ��
�m��
��������
�I ��
�� �� �U ��� ���������� �I ��'
��
���������������������e �Y
���������������� �� �e�
���� ��
��� �m
�m �u
�� �=�� �m �m �=
��
����������
��� �� �q ���� �u � � �y � �y �} �� �� ���
���� ��
�=��
�� �� ��
N
d�5�9���A����hh ���Y ���������A����h�A �m�A
��
�A �� �Y
�Y ��
0
�Y ������ ��%���]�5�9�Y�� �m
�9 �� �A�Y
�Y����
Bp������
���q��������
��
��
��
��
�q ����
����
�m
�m
��+ p�� ����
������@���� ������ �������� t���� x������ ��
��
�m ��
�m �m �� ���m �9
�,
�
�E�z\V4���]̀�̑�?_�
:1�8V�6N5��k �m׀� $ � � $ RSA1 ''6�n_�����1�:�fl/��y�����2}/��R4H�<=\]��Ǽ��(k,Q�\�$+�Au2����I���RmRo� ���{���l�O���1
�ˢ�#V{-��P���b�왹J�|};(���1 5 . 0 . 0 . 0 z 1 5 . 0 (M i c r o s o f t S Q L S e r v e r ��{ 0 x b d 7 f 7 c 0 d , 0 x 7 c 3 6 , 0 x 4 7 2 1 , { 0 x a f , 0 x a 8 , 0 x b , 0 x a 7 , 0 x 0 , 0 x e 2 , 0 x 6 d , 0 x 9 e } } S Q L S e r v e r 2 0 1 9 2M i c r o s o f t S Q L S e r v e r 2 0 1 9 2 0 1 9 1 5 0
s q l 1 3 2S Q L S e r v e r B o o k s O n l i n e . 1 5 . 0 S Q L 2 0 1 9 S Q L S e r v e r 2 0 1 9 L{ 3 6 4 3 6 b 5 d - 7 5 f 6 - 4 6 2 b - 9 e 6 6 - c 7 6 1 3 c a b c d 8 4 } HD B C C 2 3 D 9 - 8 4 E 0 - 4 B 4 D - A 8 B 0 - 9 A 7 3 6 B 6 9 3 F 4 C S Q L v 1 5 M S S Q L 1 5 M S A S 1 5 M S R S 1 5 � S Q L 1 4 0 M S I S Q L 1 4 0 E x c e p t i o n ��{ 0 x 2 4 1 4 b c 1 b , 0 x 1 5 7 2 , 0 x 4 c d 9 , { 0 x 9 c , 0 x a 5 , 0 x 6 5 , 0 x 1 6 , 0 x 6 d , 0 x 8 d , 0 x e f , 0 x 3 d } } :C o p y r i g h t ? ? ? ? M i c r o s o f t 2 0 1 9 8 @C o p y r i g h t ? ? ? ? M i c r o s o f t I T 2 0 1 9 ,m s - h e l p : / / M S . S Q L C C . v 1 5 *m s - h e l p : / / M S . V S C C . v 9 0 1 4 . 0 1 1 . 0 . 3
! " # $ % & 2S E T D E A D L O C K _ P R I O R I T Y - 1 0 H &H t e l e m e t r y _ x e l o g . x e l C l o u d C o n n e c t o r I d S Q L S e r v e r C E I P W o r k i n g S e t 6 4 "P a g e d M e m o r y S i z e 6 4 $T o t a l P r o c e s s o r T i m e � 6c : \ v a r \ o p t \ m s s q l \ m s s q l . c o n f D e f a u l t N o t E x i s t n e t w o r k t c p p o r t Q u e r y S e t S t a t s �� 9 PA I F - 6 0 c 2 5 5 2 d - b 6 1 9 - 4 9 2 5 - 8 d 6 6 - 3 0 e c 0 b 8 3 d 0 9 d ��h t t p s : / / s e t t i n g s - w i n . d a t a . m i c r o s o f t . c o m / s e t t i n g s / v 2 . 0 / s q l s e r v e r / s q l s e r v e r c e i p 1 . 0 . 0 . 0 @S O F T W A R E ; H A R D W A R E ; S Y S T E M ; C o n t r o l @ � @ � � � ��.��System.Security.Permissions.SecurityPermissionAttribute, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089TSkipVerification ( , 048��
���� ��T�� ��(��������� ����� ����
��������������hl ��D ��
���� ��
����
�e`�������������� ��
�q������p ����
�m�� ��
�� �
���=�Md�Y ��
�M���Y�� ��
����D���� ����tx� ��=�9
��
��� �
�=�� �$�=��
( ( , , 0 0 4 4 8 8 �� �� �� ���� ���� ���� ���� ����( T ����0�� 0�� ��
0�� �� �A����h �A���� ��
�� ��
��D ��D D �m��
�m��
��
l ���� D �� �� �� ���m�m �m �� �� �� ��
�� ��
������ �q �� ��
�� ���� ��
����
�� �� �� �� �� ���� p �� �������� ��
�� �� ��
�� ���� �m�� �m�� ��
��
������
����
��
�� ��
���� �m ����
�9
� �(�,
� �( ��
��( ( ( ( ( ( ( ( ( ( (
( ( (
( ( ( ( ( ( ( ( ( ( ( (( ,( ( ( 0( 4( 8( ( ��
( ��D( ��( �� (
( �q( ��( �m��( ( ��
( ��( ( �m TWrapNonExceptionThrows Sql Server Telemetry Client > 9This tool collects and uploads telemetry from SQL Server. Microsoft SQL Server $ Microsoft. All rights reserved. M HMicrosoft SQL Server is a registered trademark of Microsoft Corporation. Microsoft Corporation 15.0.2170.1 T OF:\dbs\sh\el1q\0415_151203\cmd\1p\Tools\scopas\custom\data\snk\sql2003snkey.snk 9 .NETFramework,Version=v4.6.2 TFrameworkDisplayName j eMicrosoft.Cloud.Sql.Analytics.BoxTelemetry.MachineInfoQueryProcessor+<IdentifyCloudServicesAsync>d__3 f aMicrosoft.Cloud.Sql.Analytics.BoxTelemetry.MachineInfoQueryProcessor+<CheckCloudServiceAsync>d__4 [ VMicrosoft.Cloud.Sql.Analytics.BoxTelemetry.TelemetrySource+<GetPeriodicTelemetry>d__24 [ VMicrosoft.Cloud.Sql.Analytics.BoxTelemetry.TelemetrySource+<GetPeriodicTelemetry>d__25 d _Microsoft.Cloud.Sql.Analytics.BoxTelemetry.SqlServerTelemetrySource+<GetPeriodicTelemetry>d__32 k fMicrosoft.Cloud.Sql.Analytics.BoxTelemetry.AnalysisServicesTelemetrySource+<GetPeriodicTelemetry>d__26 N IMicrosoft.Cloud.Sql.Analytics.BoxTelemetry.TelemetrySink+<Sublist>d__28`1 Always Encrypted Always On Availability Group " Accelerated Database Recovery Data Classification Data Masking Database Mirroring Feature Restrictions Resource Governor Server Configuration Service Broker SQL Engine Performance SQLOS CLR Hosting
Stretch DB Window / Ranking Functions xsd4.0.30319.33440 code H T
AnonymousTypeT Namespace&http://tempuri.org/PeriodicQueries.xsdE T Namespace&http://tempuri.org/PeriodicQueries.xsdT
IsNullable 7 T Namespace&http://tempuri.org/PeriodicQueries.xsdK T
AnonymousTypeT Namespace)http://tempuri.org/XEventAggregations.xsdH T Namespace)http://tempuri.org/XEventAggregations.xsdT
IsNullable : T Namespace)http://tempuri.org/XEventAggregations.xsd
PeriodicQuery XEvent Aggregate T
IsNullable " TDataTypenonNegativeInteger Field T
IsNullable U FunctionType UDataType � <?xml version="1.0" encoding="utf-8"?>
<PeriodicQueries xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://tempuri.org/PeriodicQueries.xsd">
<PeriodicQuery>
<PropertyName>FileStreamContainer.001</PropertyName>
<SelectQuery>
SELECT db_id() AS database_id,
df.[type] AS DBFileType,
ds.[type] AS DataSpaceType,
ds.is_default AS IsDefault,
ds.is_system AS IsSystem,
SUM(CAST(df.size AS BIGINT))*8 AS DatabaseSize,
COUNT_BIG(DISTINCT df.physical_name) AS FileCount
FROM sys.database_files df
LEFT OUTER JOIN sys.data_spaces ds
ON ds.data_space_id = df.data_space_id
GROUP BY df.type, ds.type, ds.is_default, ds.is_system
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Inventory</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>MemoryOptimizedScalarUDFCount.001</PropertyName>
<SelectQuery>
SELECT DB_ID() AS database_id, COUNT_BIG(*) as MemoryOptimizedScalarUDFCount
FROM sys.sql_modules m WITH(nolock) JOIN sys.objects o WITH(nolock) ON m.object_id=o.object_id
WHERE uses_native_compilation=1 and o.type='FN'
</SelectQuery>
<Frequency>Day</Frequency>
<Category>InMemory</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>MemoryOptimizedTriggerCount.001</PropertyName>
<SelectQuery>
SELECT DB_ID() AS database_id, COUNT_BIG(*) as MemoryOptimizedTriggerCount
FROM sys.sql_modules m WITH(nolock) JOIN sys.triggers t WITH(nolock) ON m.object_id=t.object_id
WHERE uses_native_compilation=1
</SelectQuery>
<Frequency>Day</Frequency>
<Category>InMemory</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>TableProperties.002</PropertyName>
<SelectQuery>
SELECT DB_ID() AS database_id,
is_remote_data_archive_enabled,
temporal_type,
is_memory_optimized,
lock_escalation,
type,
COUNT_BIG(*) AS NumTables,
is_node,
is_edge
FROM sys.tables WITH(nolock)
GROUP BY
is_remote_data_archive_enabled,
temporal_type,
is_memory_optimized,
lock_escalation,
type,
is_node,
is_edge
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Inventory</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>QueryStoreOptions.001</PropertyName>
<SelectQuery>
SELECT
db_id() AS database_id,
desired_state AS QueryStoreDesiredState,
actual_state AS QueryStoreActualState,
current_storage_size_mb AS QueryStoreCurrentStorageSizeMb
FROM sys.database_query_store_options WITH(nolock)</SelectQuery>
<Frequency>Day</Frequency>
<Category>QDS</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>AlwaysEncryptedColumnMasterKeyCountByProviderName.002</PropertyName>
<SelectQuery>
select
db_id() as database_id,
COUNT_BIG(*) AS ColumnMasterKeyCount,
CASE WHEN key_store_provider_name IN ('MSSQL_CERTIFICATE_STORE', 'MSSQL_CSP_PROVIDER', 'MSSQL_CNG_STORE', 'Azure_Key_Vault', 'MSSQL_JAVA_KEYSTORE') THEN key_store_provider_name ELSE 'CustomKeyStoreProvider' END AS KeyStoreProviderName,
allow_enclave_computations AS AllowEnclaveComputations
FROM sys.column_master_keys WITH(nolock)
group by key_store_provider_name, allow_enclave_computations
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Always Encrypted</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>AlwaysEncryptedColumnEncryptionKeyCountByAlgorithm.002</PropertyName>
<SelectQuery>
SELECT
db_id() as database_id,
COUNT_BIG(DISTINCT(V.column_encryption_key_id)) AS [ColumnEncryptionKeyCount],
CASE
WHEN V.encryption_algorithm_name = 'RSA_OAEP' THEN encryption_algorithm_name
ELSE 'CustomAlgorithm'
END AS encryption_algorithm_name,
M.allow_enclave_computations
FROM sys.column_encryption_keys K WITH(nolock)
INNER JOIN sys.column_encryption_key_values V WITH(nolock)
ON K.column_encryption_key_id = V.column_encryption_key_id
INNER JOIN sys.column_master_keys M WITH(nolock)
ON M.column_master_key_id = V.column_master_key_id
GROUP BY
CASE
WHEN V.encryption_algorithm_name = 'RSA_OAEP' THEN encryption_algorithm_name
ELSE 'CustomAlgorithm'
END,
M.allow_enclave_computations
HAVING
COUNT_BIG(DISTINCT(V.column_encryption_key_id)) > 0
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Always Encrypted</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>AlwaysEncryptedUsageInfo.002</PropertyName>
<SelectQuery>
WITH COL_VAL(object_id,EncryptedColumns,AllowEnclaveComputations) AS
(SELECT object_id,
COUNT_BIG(*) AS EncryptedColumns,
max(M.allow_enclave_computations) AS AllowEnclaveComputations
FROM sys.columns C WITH(nolock) inner join sys.column_encryption_key_values V ON V.column_encryption_key_id = C.column_encryption_key_id
JOIN sys.column_master_keys M ON M.column_master_key_id = V.column_master_key_id
WHERE C.column_encryption_key_id IS NOT NULL
GROUP BY object_id
HAVING COUNT(DISTINCT(V.column_encryption_key_id)) > 0)
SELECT
db_id() AS database_id,
COL_VAL.*,
P.rows
FROM COL_VAL join sys.partitions P WITH(nolock) ON COL_VAL.object_id = P.object_id
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Always Encrypted</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>AlwaysEncryptedColumnInfo.002</PropertyName>
<SelectQuery>
SELECT
db_id() as database_id,
C.object_id,
C.column_id,
C.user_type_id,
C.max_length,
C.precision,
C.scale,
C.collation_name,
C.is_nullable,
CASE
WHEN C.encryption_algorithm_name = 'AEAD_AES_256_CBC_HMAC_SHA_256'
THEN C.encryption_algorithm_name
ELSE 'CustomAlgorithm'
END AS encryption_algorithm_name,
C.encryption_type_desc,
M.allow_enclave_computations
FROM sys.columns C WITH(nolock)
INNER JOIN sys.column_encryption_key_values V WITH(nolock)
ON V.column_encryption_key_id = C.column_encryption_key_id
INNER JOIN sys.column_master_keys M WITH(nolock)
ON M.column_master_key_id = V.column_master_key_id
WHERE C.column_encryption_key_id IS NOT NULL
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Always Encrypted</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>ExternalTableCount.001</PropertyName>
<SelectQuery>
SELECT DB_ID() AS database_id, eds.type AS ExternalDataSource, COUNT_BIG(*) AS NumberOfTables
FROM sys.external_tables et WITH(nolock)
INNER JOIN sys.external_data_sources eds WITH(nolock)
ON et.data_source_id = eds.data_source_id
GROUP BY eds.type
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Polybase</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>RLSSecurityPoliciesCount.001</PropertyName>
<SelectQuery>
SELECT DB_ID() AS database_id,
is_schema_bound,
COUNT_BIG(*) AS RLSSecurityPoliciesCount
FROM sys.security_policies WITH(nolock)
GROUP BY is_schema_bound
</SelectQuery>
<Frequency>Day</Frequency>
<Category>RLS</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>RLSPredicateCount.001</PropertyName>
<SelectQuery>
SELECT DB_ID() AS database_id, predicate_type, operation, COUNT_BIG(*) AS Count
FROM sys.security_predicates WITH(nolock)
GROUP BY predicate_type, operation
</SelectQuery>
<Frequency>Day</Frequency>
<Category>RLS</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>RLSUniqueCount.001</PropertyName>
<SelectQuery>
SELECT DB_ID() AS database_id, COUNT_BIG(DISTINCT target_object_id) AS RLSTablesWithSecurityPredicateCount, COUNT_BIG(DISTINCT predicate_definition) AS RLSUniqueFunctionCount
FROM sys.security_predicates WITH(nolock)
</SelectQuery>
<Frequency>Day</Frequency>
<Category>RLS</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>SqlDbAssmPermSetStream.001</PropertyName>
<SelectQuery>
SELECT DB_ID() AS [database_id], permission_set AS [sPermissionSet], COUNT_BIG(*) AS [sNumObjects]
FROM sys.assemblies WITH(nolock)
WHERE is_user_defined = 1
GROUP BY permission_set
</SelectQuery>
<Frequency>Day</Frequency>
<Category>SQLOS CLR Hosting</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>SqlDbClrStream.001</PropertyName>
<SelectQuery>
SELECT DB_ID() AS [database_id], (SELECT COUNT_BIG(*) FROM sys.assemblies WITH(nolock) WHERE is_user_defined = 1) AS [sNumObjects], COUNT_BIG(*) AS [sNumUDT]
FROM sys.assembly_types WITH(nolock)
WHERE is_user_defined = 1
</SelectQuery>
<Frequency>Day</Frequency>
<Category>SQLOS CLR Hosting</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>ExternalLibrarySizeCount.001</PropertyName>
<SelectQuery>
SELECT DB_ID() AS [database_id],
MIN(DATALENGTH(content)) AS [external_libraries_min_size],
AVG(DATALENGTH(content)) AS [external_libraries_avg_size],
MAX(DATALENGTH(content)) AS [external_libraries_max_size],
COUNT(DISTINCT external_library_id) AS [external_libraries_count]
FROM sys.external_library_files
</SelectQuery>
<Frequency>Day</Frequency>
<Category>R</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>SqlDbFtStream.001</PropertyName>
<SelectQuery>
SELECT DB_ID() AS [database_id],
(SELECT COUNT_BIG(fulltext_catalog_id)
FROM sys.fulltext_catalogs WITH(nolock)) AS [sNumCatalogs],
(SELECT COUNT_BIG(distinct t.object_id)
FROM sys.fulltext_indexes f WITH(nolock) JOIN sys.tables t WITH(nolock)
ON (f.object_id=t.object_id) WHERE f.is_enabled=1) AS [sNumTables]
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Inventory</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>TVPStoredProcs.001</PropertyName>
<SelectQuery>
SELECT db_id() AS database_id, COUNT_BIG(*) AS [TVPStoredProcsCount]
FROM sys.types t WITH(nolock)
JOIN sys.parameters p WITH(nolock) ON t.system_type_id = p.system_type_id AND t.user_type_id=p.user_type_id
JOIN sys.objects o WITH(nolock) ON o.object_id = p.object_id
WHERE is_table_type = 1
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Inventory</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>ColumnProperties.001</PropertyName>
<SelectQuery>
SELECT
db_id() AS database_id,
c.system_type_id,
c.user_type_id,
c.is_sparse,
c.is_column_set,
c.is_filestream,
c.encryption_type,
CASE WHEN o.object_id IS NOT NULL THEN 1 ELSE 0 END AS is_user,
COUNT_BIG(*) AS [ColCount],
CASE WHEN c.collation_name IS NULL THEN CONVERT(VARCHAR(128), SERVERPROPERTY('Collation')) ELSE c.collation_name END AS collation_name,
AVG(c.max_length) AS avg_max_length
FROM sys.columns c WITH (NOLOCK)
LEFT OUTER JOIN sys.objects o WITH (NOLOCK)
ON o.object_id = c.object_id
AND o.type = 'U'
GROUP BY
c.system_type_id,
c.user_type_id,
c.is_sparse,
c.is_column_set,
c.encryption_type,
c.is_filestream,
CASE WHEN o.object_id IS NOT NULL THEN 1 ELSE 0 END,
CASE WHEN c.collation_name IS NULL THEN CONVERT(VARCHAR(128), SERVERPROPERTY('Collation')) ELSE c.collation_name END
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Inventory</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>TableTypes.001</PropertyName>
<SelectQuery>
SELECT db_id() AS database_id, COUNT_BIG(*) AS [TableTypes]
FROM sys.types WITH(nolock)
WHERE is_table_type = 1
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Inventory</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>NumFilteredIndicesOnSparse.001</PropertyName>
<SelectQuery>
WITH CTE AS (
SELECT DISTINCT i.object_id oid, i.index_id iid
FROM sys.indexes i WITH(nolock)
JOIN sys.index_columns ic ON i.object_id = ic.object_id
JOIN sys.columns c WITH(nolock) ON ic.column_id = c.column_id AND c.object_id = i.object_id
WHERE c.is_sparse = 1
AND ic.key_ordinal != 0
AND i.has_filter = 1
)
SELECT COUNT_BIG(*) AS NumFilteredIndicesOnSparse
, db_id() AS database_id
FROM CTE
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Inventory</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>NumFilteredStatsManuallyCreated.001</PropertyName>
<SelectQuery>
select COUNT_BIG(*) AS NumFilteredStatsManuallyCreated
, db_id() AS database_id
from sys.stats WITH(nolock) where has_filter =1 and user_created =1
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Inventory</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>CellsPerObjectAvg.001</PropertyName>
<SelectQuery>
SELECT AVG(cells_per_object) AS CellsPerObjectAvg
, db_id() AS database_id
FROM sys.spatial_index_tessellations WITH(nolock)
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Spatial</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>TableAndIndexStorage.001</PropertyName>
<SelectQuery>
SELECT
db_id() AS database_id,
o.[type] AS object_type,
i.[type] AS index_type,
p.[data_compression],
COUNT_BIG(DISTINCT p.[object_id]) AS NumTables,
COUNT_BIG(DISTINCT CAST(p.[object_id] AS VARCHAR(30)) + '|' + CAST(p.[index_id] AS VARCHAR(10))) AS NumIndexes,
ISNULL(px.[IsPartitioned], 0) AS IsPartitioned,
IIF(px.[IsPartitioned] = 1, COUNT_BIG(1), 0) NumPartitions,
SUM(p.[rows]) NumRows
FROM sys.partitions p
INNER JOIN sys.objects o
ON o.[object_id] = p.[object_id]
INNER JOIN sys.indexes i
ON i.[object_id] = p.[object_id]
AND i.[index_id] = p.[index_id]
OUTER APPLY (SELECT
x.[object_id], 1 AS [IsPartitioned]
FROM sys.partitions x
WHERE x.[object_id] = p.[object_id]
GROUP by
x.[object_id]
HAVING MAX(x.partition_number) > 1) px
WHERE o.[type] NOT IN ('S', 'IT')
GROUP BY
o.[type]
,i.[type]
,p.[data_compression]
,px.[IsPartitioned]
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Inventory</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>DataMaskingMaskedColumnsCount.001</PropertyName>
<SelectQuery>SELECT DB_ID() AS database_id, COUNT_BIG(*) AS DataMaskingMaskedColumnsCount FROM sys.masked_columns WITH(nolock)</SelectQuery>
<Frequency>Day</Frequency>
<Category>Data Masking</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>DataMaskingMaskedColumnsCountPerType.001</PropertyName>
<SelectQuery>
SELECT DB_ID() AS database_id, MaskingFunction + '_' + CAST(TypeId AS VARCHAR(10)) AS PropertyType, COUNT_BIG(*) as DataMaskingMaskedColumnsCountPerType
FROM
(
SELECT SUBSTRING(masking_function, 1, CHARINDEX('(', masking_function) - 1) AS MaskingFunction, system_type_id AS TypeId
FROM sys.masked_columns WITH(nolock)
) a
GROUP BY MaskingFunction, TypeId
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Data Masking</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>MDSTables.001</PropertyName>
<SelectQuery>
SELECT COUNT_BIG(*) AS MdsTables
, db_id() AS database_id
FROM INFORMATION_SCHEMA.TABLES WITH(nolock)
WHERE TABLE_TYPE = 'BASE TABLE'
AND TABLE_NAME = 'tblSystem'
AND TABLE_SCHEMA = 'mdm'
</SelectQuery>
<Frequency>Day</Frequency>
<Category>MDS</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>MDSUserCount.001</PropertyName>
<SelectQuery>
IF OBJECT_ID('mdm.tblUser') IS NOT NULL
BEGIN
SELECT db_id() as database_id, row_count AS count
FROM sys.tables t WITH(nolock)
JOIN sys.dm_db_partition_stats ps WITH(nolock)
ON t.object_id = ps.object_id
WHERE t.name = 'tblUser' AND t.schema_id = SCHEMA_ID('mdm') AND ps.index_id < 2
END
</SelectQuery>
<Frequency>Day</Frequency>
<Category>MDS</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>MDSModelCount.001</PropertyName>
<SelectQuery>
IF OBJECT_ID('mdm.tblModel') IS NOT NULL
BEGIN
SELECT db_id() as database_id, row_count AS count
FROM sys.tables t WITH(nolock)
JOIN sys.dm_db_partition_stats ps WITH(nolock)
ON t.object_id = ps.object_id
WHERE t.name = 'tblModel' AND t.schema_id = SCHEMA_ID('mdm') AND ps.index_id < 2
END
</SelectQuery>
<Frequency>Day</Frequency>
<Category>MDS</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>MDSEntityCount.001</PropertyName>
<SelectQuery>
IF OBJECT_ID('mdm.tblEntity') IS NOT NULL
BEGIN
SELECT db_id() as database_id, row_count AS count
FROM sys.tables t WITH(nolock)
JOIN sys.dm_db_partition_stats ps WITH(nolock)
ON t.object_id = ps.object_id
WHERE t.name = 'tblEntity' AND t.schema_id = SCHEMA_ID('mdm') AND ps.index_id < 2
END
</SelectQuery>
<Frequency>Day</Frequency>
<Category>MDS</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>MDSAttributeCount.001</PropertyName>
<SelectQuery>
IF OBJECT_ID('mdm.tblAttribute') IS NOT NULL
BEGIN
SELECT db_id() as database_id, row_count AS count
FROM sys.tables t WITH(nolock)
JOIN sys.dm_db_partition_stats ps WITH(nolock)
ON t.object_id = ps.object_id
WHERE t.name = 'tblAttribute' AND t.schema_id = SCHEMA_ID('mdm') AND ps.index_id < 2
END
</SelectQuery>
<Frequency>Day</Frequency>
<Category>MDS</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>MDSExplicitHierarchyCount.001</PropertyName>
<SelectQuery>
IF OBJECT_ID('mdm.tblHierarchy') IS NOT NULL
BEGIN
SELECT db_id() as database_id, row_count AS count
FROM sys.tables t WITH(nolock)
JOIN sys.dm_db_partition_stats ps WITH(nolock)
ON t.object_id = ps.object_id
WHERE t.name = 'tblHierarchy' AND t.schema_id = SCHEMA_ID('mdm') AND ps.index_id < 2
END
</SelectQuery>
<Frequency>Day</Frequency>
<Category>MDS</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>MDSSyncRelationshipCount.001</PropertyName>
<SelectQuery>
IF OBJECT_ID('mdm.tblSyncRelationship') IS NOT NULL
BEGIN
SELECT db_id() as database_id, row_count AS count
FROM sys.tables t WITH(nolock)
JOIN sys.dm_db_partition_stats ps WITH(nolock)
ON t.object_id = ps.object_id
WHERE t.name = 'tblSyncRelationship' AND t.schema_id = SCHEMA_ID('mdm') AND ps.index_id < 2
END
</SelectQuery>
<Frequency>Day</Frequency>
<Category>MDS</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>MDSLeafMemberCount.001</PropertyName>
<SelectQuery>
IF OBJECT_ID('mdm.tblSystem') IS NOT NULL
BEGIN
SELECT db_id() as database_id, SUM(row_count) AS count
FROM sys.tables t WITH(nolock)
JOIN sys.dm_db_partition_stats ps WITH(nolock)
ON t.object_id = ps.object_id
WHERE t.name like '%_EN' AND t.schema_id = SCHEMA_ID('mdm') AND ps.index_id < 2
END
</SelectQuery>
<Frequency>Day</Frequency>
<Category>MDS</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>MDSCollectionInUseCount.001</PropertyName>
<SelectQuery>
IF OBJECT_ID('mdm.tblSystem') IS NOT NULL
BEGIN
SELECT db_id() as database_id, COUNT_BIG(*) AS count
FROM sys.tables WITH(nolock)
WHERE name like '%_CN' AND schema_id = SCHEMA_ID('mdm')
END
</SelectQuery>
<Frequency>Day</Frequency>
<Category>MDS</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>MDSVersion.002</PropertyName>
<SelectQuery>
IF OBJECT_ID('mdm.tblSystem') IS NOT NULL
BEGIN
SELECT db_id() AS database_id, SchemaVersion
FROM mdm.tblSystem WITH(nolock)
END
</SelectQuery>
<Frequency>Day</Frequency>
<Category>MDS</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>IndexCount.001</PropertyName>
<SelectQuery>
WITH TablesAndViews AS
(SELECT object_id, 'table' AS object_type FROM sys.tables WITH(nolock) UNION ALL SELECT object_id, 'view' AS object_type FROM sys.views WITH(nolock))
SELECT
db_id() as database_id,
i.type,
i.is_unique,
i.is_primary_key,
i.is_unique_constraint,
i.is_disabled,
i.has_filter,
COUNT_BIG(1) CountOfIndexes,
t.object_type
FROM sys.indexes i WITH(nolock)
INNER JOIN TablesAndViews t
ON t.object_id = i.object_id
GROUP BY i.type,
i.is_unique,
i.is_primary_key,
i.is_unique_constraint,
i.has_filter,
t.object_type,
i.is_disabled
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Inventory</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>SBMessageTypes.001</PropertyName>
<SelectQuery>
SELECT COUNT_BIG(*) AS number_of_message_types
, db_id() AS database_id
FROM sys.service_message_types WITH(nolock)
WHERE message_type_id > 65535
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Service Broker</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>SBContracts.001</PropertyName>
<SelectQuery>
SELECT COUNT_BIG(*) AS number_of_contracts
, db_id() AS database_id
FROM sys.service_contracts WITH(nolock)
WHERE service_contract_id > 65535
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Service Broker</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>SBQueues.001</PropertyName>
<SelectQuery>
SELECT COUNT_BIG(*) AS number_of_queues
, db_id() AS database_id
FROM sys.service_queues WITH(nolock)
WHERE is_ms_shipped != 1
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Service Broker</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>SBQueuesEnabled.001</PropertyName>
<SelectQuery>
SELECT COUNT_BIG(*) AS number_of_enabled_queues
, db_id() AS database_id
FROM sys.service_queues WITH(nolock)
WHERE is_ms_shipped != 1 AND is_receive_enabled = 1 AND is_enqueue_enabled = 1
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Service Broker</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>SBQueuesWithActivationOn.001</PropertyName>
<SelectQuery>
SELECT COUNT_BIG(*) AS number_of_activated_queues
, db_id() AS database_id
FROM sys.service_queues WITH(nolock)
WHERE is_activation_enabled = 1
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Service Broker</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>SBServices.001</PropertyName>
<SelectQuery>
SELECT COUNT_BIG(*) AS number_of_services
, db_id() AS database_id
FROM sys.services WITH(nolock)
WHERE service_id > 65535
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Service Broker</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>SBRoutes.001</PropertyName>
<SelectQuery>
SELECT COUNT_BIG(*) AS number_of_routes
, db_id() AS database_id
FROM sys.routes WITH(nolock)
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Service Broker</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>SBConversations.001</PropertyName>
<SelectQuery>
SELECT COUNT_BIG(DISTINCT conversation_id) AS number_of_conversations
, db_id() AS database_id
FROM sys.conversation_endpoints WITH(nolock)
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Service Broker</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>SBEncryptedConversations.001</PropertyName>
<SelectQuery>
SELECT COUNT_BIG(DISTINCT conversation_id) AS number_of_encrypted_conversations
, db_id() AS database_id
FROM sys.conversation_endpoints WITH(nolock)
WHERE outbound_session_key_identifier <> '00000000-0000-0000-0000-000000000000' OR
inbound_session_key_identifier <> '00000000-0000-0000-0000-000000000000'
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Service Broker</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>SBReadersPerQueueAvg.001</PropertyName>
<SelectQuery>
SELECT SUM(max_readers) AS number_of_queue_readers
, db_id() AS database_id
FROM sys.service_queues WITH(nolock)
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Service Broker</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>SBQueuesWithRetention.001</PropertyName>
<SelectQuery>
SELECT COUNT_BIG(*) AS number_of_queues_with_retention
, db_id() AS database_id
FROM sys.service_queues WITH(nolock)
WHERE is_retention_enabled = 1
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Service Broker</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>NumTimeIndices.001</PropertyName>
<SelectQuery>
WITH CTE AS (
SELECT DISTINCT i.object_id oid, i.index_id iid
FROM sys.indexes i WITH(nolock)
JOIN sys.index_columns ic WITH(nolock) ON i.object_id = ic.object_id
JOIN sys.columns c WITH(nolock) ON ic.column_id = c.column_id AND c.object_id = i.object_id
WHERE c.system_type_id = 41 AND c.user_type_id = 41 -- only time columns
AND ic.key_ordinal != 0 -- only key columns
)
SELECT COUNT_BIG(*) AS [NumTimeIndices], db_id() AS database_id
FROM CTE
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Inventory</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>NumDatetime2Indices.001</PropertyName>
<SelectQuery>
WITH CTE AS (
SELECT DISTINCT i.object_id oid, i.index_id iid
FROM sys.indexes i WITH(nolock)
JOIN sys.index_columns ic WITH(nolock) ON i.object_id = ic.object_id
JOIN sys.columns c WITH(nolock) ON ic.column_id = c.column_id AND c.object_id = i.object_id
WHERE c.system_type_id = 42 AND c.user_type_id = 42 -- only datetime2 columns
AND ic.key_ordinal != 0 -- only key columns
)
SELECT COUNT_BIG(*) AS [NumDatetime2Indices], db_id() AS database_id
FROM CTE
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Inventory</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>NumDatetimeoffsetIndices.001</PropertyName>
<SelectQuery>
WITH CTE AS (
SELECT DISTINCT i.object_id oid, i.index_id iid
FROM sys.indexes i WITH(nolock)
JOIN sys.index_columns ic WITH(nolock) ON i.object_id = ic.object_id
JOIN sys.columns c WITH(nolock) ON ic.column_id = c.column_id AND c.object_id = i.object_id
WHERE c.system_type_id = 43 AND c.user_type_id = 43 -- only datetimeoffset columns
AND ic.key_ordinal != 0 -- only key columns
)
SELECT COUNT_BIG(*) AS [NumDatetimeoffsetCols], db_id() AS database_id
FROM CTE
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Inventory</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>NumOfMODFilegroups.001</PropertyName>
<SelectQuery>
SELECT COUNT_BIG(*) AS [NumOfMODFilegroups], db_id() AS database_id FROM sys.data_spaces WITH(nolock) WHERE type='FX'
</SelectQuery>
<Frequency>Day</Frequency>
<Category>InMemory</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>XTPMemoryAllocatedForUserDataKb.001</PropertyName>
<SelectQuery>
SELECT
ISNULL(sum(memory_allocated_for_table_kb+memory_allocated_for_indexes_kb) ,0) AS total_memory_allocated_for_user_data_kb, db_id() AS database_id
FROM sys.dm_db_xtp_table_memory_stats WITH(nolock)
</SelectQuery>
<Frequency>Day</Frequency>
<Category>InMemory</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>XTPMemoryUsed.001</PropertyName>
<SelectQuery>
SELECT
ISNULL(SUM(memory_used_by_table_kb),0) AS total_memory_used_by_tables_kb,
ISNULL(SUM(memory_used_by_indexes_kb),0) AS total_memory_used_by_indexes_kb, db_id() AS database_id
FROM sys.dm_db_xtp_table_memory_stats WITH(nolock)
</SelectQuery>
<Frequency>Day</Frequency>
<Category>InMemory</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>XTPCheckpointFileCount.001</PropertyName>
<SelectQuery>
SELECT COUNT_BIG(*) AS [XTPCheckpointFileCount], db_id() AS database_id FROM sys.dm_db_xtp_checkpoint_files WITH(nolock)
</SelectQuery>
<Frequency>Day</Frequency>
<Category>InMemory</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>NumOfMemoryOptimizedNDTs.001</PropertyName>
<SelectQuery>
SELECT COUNT_BIG(*) AS [NumOfMemoryOptimizedNDTs], db_id() AS database_id FROM sys.tables WITH(nolock) WHERE is_memory_optimized=1 AND durability=1
</SelectQuery>
<Frequency>Day</Frequency>
<Category>InMemory</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>NumOfNativeProcs.001</PropertyName>
<SelectQuery>
SELECT COUNT_BIG(*) AS [NumOfNativeProcs], db_id() AS database_id FROM sys.sql_modules m WITH(nolock) JOIN sys.procedures p WITH(nolock) ON m.object_id=p.object_id WHERE uses_native_compilation=1
</SelectQuery>
<Frequency>Day</Frequency>
<Category>InMemory</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>NumOfMemoryOptimizedTableTypes.001</PropertyName>
<SelectQuery>
SELECT COUNT_BIG(*) AS [NumOfMemoryOptimizedTableTypes], db_id() AS database_id FROM sys.table_types WITH(nolock) WHERE is_memory_optimized=1
</SelectQuery>
<Frequency>Day</Frequency>
<Category>InMemory</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>XTPNumOfIndexes.001</PropertyName>
<SelectQuery>
SELECT ISNULL(AVG(c),0) AS [XTPAvgNumOfIndexes],
ISNULL(MAX(c),0) AS [XTPMaxNumOfIndexes], db_id() AS database_id
FROM (SELECT COUNT_BIG(*) AS c
FROM sys.indexes i WITH(nolock) JOIN sys.tables t WITH(nolock) ON i.object_id=t.object_id WHERE t.is_memory_optimized=1
GROUP BY i.object_id) a
</SelectQuery>
<Frequency>Day</Frequency>
<Category>InMemory</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>XTPObjects.001</PropertyName>
<SelectQuery>
SELECT
ISNULL(SUM(row_update_attempts)+SUM(row_delete_attempts),0) AS rows_touched,
ISNULL(SUM(write_conflicts),0) AS write_conflicts, db_id() AS database_id
FROM sys.dm_db_xtp_object_stats WITH(nolock)
</SelectQuery>
<Frequency>Day</Frequency>
<Category>InMemory</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>XTPNumOfHashIndexes.001</PropertyName>
<SelectQuery>
SELECT ISNULL(AVG(c),0) AS [XTPAvgNumOfHashIndexes],
ISNULL(MAX(c),0) AS [XTPMaxNumOfHashIndexes], db_id() AS database_id
FROM (SELECT COUNT_BIG(*) AS c FROM sys.indexes i WITH(nolock) JOIN sys.tables t WITH(nolock) ON i.object_id=t.object_id WHERE t.is_memory_optimized=1 and i.type=7
GROUP BY i.object_id) a
</SelectQuery>
<Frequency>Day</Frequency>
<Category>InMemory</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>XTPRGUsage.001</PropertyName>
<SelectQuery>
select COUNT_BIG(*) AS [XTPRGUsageCount],
isnull(sum(rp.max_memory_kb), 0) as [XTPRGMaxMemoryKB],
isnull(sum(rp.max_memory_percent), 0) AS [XTPRGMaxMemoryPercent], db_id() AS database_id
from sys.databases d WITH(nolock) join sys.dm_resource_governor_resource_pools rp WITH(nolock) on d.resource_pool_id=rp.pool_id
where database_id=db_id() and isnull(resource_pool_id, 2) > 2 and exists (select * from sys.data_spaces WITH(nolock) where type='FX')
</SelectQuery>
<Frequency>Day</Frequency>
<Category>InMemory</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>XTPAlwaysOnAG.001</PropertyName>
<SelectQuery>
select count_big(*) AS [XTPAlwaysOnAG],
isnull(sum(ar.availability_mode),0) AS [XTPAlwaysOnAGSync], db_id() AS database_id
from sys.databases d WITH (NOLOCK)
join sys.availability_databases_cluster adb WITH (NOLOCK)
on d.group_database_id=adb.group_database_id
join sys.availability_replicas ar WITH (NOLOCK)
on d.replica_id=ar.replica_id
where database_id=db_id() and exists (select * from sys.data_spaces WITH (NOLOCK) where type='FX')
</SelectQuery>
<Frequency>Day</Frequency>
<Category>InMemory</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>NumDBsWithSpatialIndexes.001</PropertyName>
<SelectQuery>
select case
when COUNT_BIG(*)>0 then 1
else 0
End AS [NumDBsWithSpatialIndexes], db_id() AS database_id
from sys.spatial_index_tessellations WITH(nolock)
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Spatial</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>DatabaseAuditAction.002</PropertyName>
<SelectQuery>
select db_id() AS database_id, COUNT_BIG(DISTINCT audit_action_name) AS AuditActionCount
from sys.database_audit_specification_details WITH(nolock)
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Audit</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>ColumnstoreIndexType.001</PropertyName>
<SelectQuery>
select object_id, type_desc, data_space_id, db_id() AS database_id from sys.indexes WITH(nolock) where type = 5 or type = 6
</SelectQuery>
<Frequency>Day</Frequency>
<Category>ColumnStore</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>ProgrammabilityModulesAndConstructs.001</PropertyName>
<SelectQuery>
SELECT db_id() AS database_id, o.[type] as ModuleType, COUNT_BIG(*) as ModuleCount
FROM sys.objects AS o WITH(nolock)
WHERE o.type in ('AF', 'F', 'FN', 'FS', 'FT', 'IF', 'P', 'PC', 'TA', 'TF', 'TR', 'X', 'C', 'D', 'PG', 'SN', 'SO', 'SQ', 'TT', 'UQ', 'V')
GROUP BY o.[type]
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Programmability</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>TablesWithIndexOnXmlColumnCount.001</PropertyName>
<SelectQuery>
SELECT DB_ID() AS database_id, COUNT_BIG(DISTINCT ic.object_id) as table_count
FROM sys.index_columns ic WITH(nolock)
INNER JOIN sys.columns col WITH(nolock) ON ic.object_id = col.object_id and ic.column_id = col.column_id
WHERE col.system_type_id = 241
</SelectQuery>
<Frequency>Day</Frequency>
<Category>XML</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>TablesWithIndexOnSpatialColumnCount.001</PropertyName>
<SelectQuery>
SELECT DB_ID() AS database_id, COUNT_BIG(DISTINCT ic.object_id) as table_count
FROM sys.index_columns ic WITH(nolock)
INNER JOIN sys.columns col WITH(nolock) ON ic.object_id = col.object_id and ic.column_id = col.column_id
WHERE col.user_type_id = 129 OR col.user_type_id = 130
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Spatial</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>PolybaseDataSource.002</PropertyName>
<SelectQuery>
SELECT
db_id() AS database_id,
SUM([SqlPbIsHdfs]) AS [SqlPbCountHdfs],
SUM([SqlPbIsWasb]) AS [SqlPbCountWasb],
SUM([SqlPbHasResourceMgr]) AS [SqlPbCountResourceMgr],
SUM([SqlPbIsSqlServer]) AS [SqlPbIsSqlServer],
SUM([SqlPbIsOracle]) AS [SqlPbIsOracle],
SUM([SqlPbIsTeradata]) AS [SqlPbIsTeradata],
SUM([SqlPbIsMongoDB]) AS [SqlPbIsMongoDB],
SUM([SqlPbIsGenericOdbc]) AS [SqlPbIsGenericOdbc]
FROM
(
SELECT
CASE WHEN resource_manager_location IS NOT NULL THEN 1 ELSE 0 END AS [SqlPbHasResourceMgr],
CASE WHEN location LIKE 'hdfs%' THEN 1 ELSE 0 END AS [SqlPbIsHdfs],
CASE WHEN location LIKE 'wasb%' THEN 1 ELSE 0 END AS [SqlPbIsWasb],
CASE WHEN location LIKE 'sqlserver%' THEN 1 ELSE 0 END AS [SqlPbIsSqlServer],
CASE WHEN location LIKE 'oracle%' THEN 1 ELSE 0 END AS [SqlPbIsOracle],
CASE WHEN location LIKE 'teradata%' THEN 1 ELSE 0 END AS [SqlPbIsTeradata],
CASE WHEN location LIKE 'mongodb%' THEN 1 ELSE 0 END AS [SqlPbIsMongoDB],
CASE WHEN location LIKE 'odbc%' THEN 1 ELSE 0 END AS [SqlPbIsGenericOdbc]
FROM
sys.external_data_sources WITH(nolock)
WHERE
type in (0, 6)
) S
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Polybase</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>PolybaseFileFormat.002</PropertyName>
<SelectQuery>
SELECT
db_id() AS database_id,
format_type AS [SqlPbFormatType],
data_compression AS [sqlPbDataCompression],
COUNT_BIG(*) AS CountFileFormat
FROM sys.external_file_formats WITH(nolock)
GROUP BY
format_type,
data_compression
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Polybase</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>ExternalTableInfo.001</PropertyName>
<SelectQuery>
SELECT db_id() AS database_id,
COUNT_BIG(*) AS [NumExternalTables],
MAX([NumColumns]) AS [MaxNumColumns],
MIN([NumColumns]) AS [MinNumColumns],
AVG([NumColumns]) AS [AvgNumColumns],
MAX([MaxRowWidth]) AS [MaxFullRowWidth],
MIN([MaxRowWidth]) AS [MinFullRowWidth],
AVG([MaxRowWidth]) AS [AvgFullRowWidth]
FROM ( SELECT COUNT_BIG(*) AS [NumColumns],
SUM(CASE WHEN max_length > 0 THEN max_length ELSE 0 END) AS [MaxRowWidth]
FROM sys.tables t WITH(nolock) INNER JOIN sys.columns c WITH(nolock) ON t.object_id = c.object_id
WHERE t.is_external=1
GROUP BY t.object_id ) S
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Polybase</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>ExternalStatsCount.001</PropertyName>
<SelectQuery>
SELECT db_id() AS database_id,
COUNT_BIG(*) AS [NumExternalStats]
FROM sys.tables t WITH(nolock) INNER JOIN sys.stats s WITH(nolock) ON t.object_id = s.object_id
WHERE t.is_external=1
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Polybase</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>ColumnStoreOldDeltaStoreCountPerBucket.001</PropertyName>
<!-- Used to find all delta stores that have been created more than a day old and are still open and per bucket. -->
<SelectQuery>
SELECT db_id() AS database_id,
CASE
WHEN total_rows < 10000 THEN '< 10k'
WHEN total_rows < 100000 THEN '>= 10K and < 100K'
WHEN total_rows > 100000 THEN '> 100K'
END DeltaStoresCategory
,COUNT_BIG(*) as [DeltaStoresCount]
FROM sys.dm_db_column_store_row_group_physical_stats
WHERE STATE = 1 AND created_time < DATEADD(day, -1, GETDATE())
GROUP BY
CASE
WHEN total_rows < 10000 THEN '< 10k'
WHEN total_rows < 100000 THEN '>= 10K and < 100K'
WHEN total_rows > 100000 THEN '> 100K'
END
</SelectQuery>
<Frequency>Day</Frequency>
<Category>ColumnStore</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>ColumnStorePercentageOfRowsInDeltaStore.001</PropertyName>
<!-- Used to collect information about average of percentage of rows in deltastore to total rows in the database-->
<SelectQuery>
select db_id() AS database_id,
ISNULL(AVG(convert(decimal(10,2),(100 *((cs2.[rowsin_deltastore_count] *1.0) /
((CASE WHEN cs1.[total_rows_count] = 0 THEN 1 ELSE cs1.[total_rows_count] END)* 1.0))))),0)
as [percent_open_deltastore] from
(select object_id, index_id, SUM(total_rows) as [total_rows_count] from sys.dm_db_column_store_row_group_physical_stats
group by object_id, index_id) as cs1
join
(select object_id, index_id, SUM(total_rows) as [rowsin_deltastore_count]
from sys.dm_db_column_store_row_group_physical_stats where state = 1 group by object_id, index_id) as cs2
on cs1.object_id = cs2.object_id and cs1.index_id = cs2.index_id
</SelectQuery>
<Frequency>Day</Frequency>
<Category>ColumnStore</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>DatabaseAutomaticTuningOptions.002</PropertyName>
<!-- Used to collect information which Automatic tuning options (like force_last_good_plan) are enabled on a database and their state.
Returns exactly one row for each automatic tuning option, for SQL17 it should be only one. -->
<SelectQuery>
select db_id() AS database_id,
name AS automatic_tuning_option_name,
desired_state,
actual_state,
reason
from sys.database_automatic_tuning_options
where desired_state > 0
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Autotuning</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>ColumnStoreRowGroupsQuality.001</PropertyName>
<!-- Used to find the quality of the rowgroups in terms of percentage of deleted rows compared to total rows-->
<SelectQuery>
SELECT db_id() AS database_id, ISNULL(AVG(100*(((total_rows - ISNULL(deleted_rows,0)) *1.0)/
ISNULL(((CASE WHEN total_rows = 0 THEN 1 ELSE total_rows END) * 1.0),1))), 0) AS PercentFull
FROM sys.column_store_row_groups
</SelectQuery>
<Frequency>Day</Frequency>
<Category>ColumnStore</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>ColumnStoreOpenDeltaStore.001</PropertyName>
<!-- Used to collect information about total number of open delta store as a percentage of total number of rowgroups-->
<SelectQuery>
select db_id() AS database_id, ISNULL(AVG(100 *((cs2.[open_deltastore_count] * 1.0) /
((CASE WHEN cs1.[total_row_group_count] = 0 THEN 1 ELSE cs1.[total_row_group_count] END)* 1.0))),0) as [percent_open_deltastore] from
(select object_id, index_id, COUNT_BIG(*) as [total_row_group_count] from sys.column_store_row_groups
group by object_id, index_id) as cs1
join
(select object_id, index_id, COUNT_BIG(*) as [open_deltastore_count], AVG(total_rows) as [avg_rows_in_deltastore]
from sys.column_store_row_groups where state = 1 group by object_id, index_id) as cs2
on cs1.object_id = cs2.object_id and cs1.index_id = cs2.index_id
</SelectQuery>
<Frequency>Day</Frequency>
<Category>ColumnStore</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>DataClassification.001</PropertyName>
<!-- Used to collect Data Classification feature usage.-->
<SelectQuery>
SELECT
DB_ID() AS database_id,
COUNT_BIG(*) AS TotalNumberOfClassifiedColumns,
COUNT_BIG(DISTINCT Totals.major_id) AS TotalNumberOfClassifiedTables,
COUNT_BIG(DISTINCT Totals.information_type_name) AS TotalNumberOfUniqueInformationTypes,
COUNT_BIG(DISTINCT Totals.sensitivity_label_name) AS TotalNumberOfUniqueSenstivityLabels
FROM (SELECT
C1.major_id,
C1.minor_id,
C1.information_type_name,
C2.sensitivity_label_name
FROM (SELECT
major_id,
minor_id,
value AS information_type_name
FROM sys.extended_properties
WHERE NAME = 'sys_information_type_name') C1
FULL OUTER JOIN (SELECT
major_id,
minor_id,
value AS sensitivity_label_name
FROM sys.extended_properties
WHERE NAME = 'sys_sensitivity_label_name') C2
ON (C1.major_id = C2.major_id AND C1.minor_id = C2.minor_id)) AS Totals
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Inventory</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>FullTextIndex.001</PropertyName>
<!-- Used to collect Full Text index info on language filters.-->
<SelectQuery>
SELECT db_id() AS database_id,
f.[language_id],
IIF(f.[type_column_id] IS NOT NULL, 1, 0) HasFilter,
COUNT_BIG(DISTINCT f.[object_id]) TableCount,
COUNT_BIG(*) IndexCount
FROM sys.fulltext_index_columns f
GROUP BY
f.language_id,
IIF(f.type_column_id IS NOT NULL, 1, 0)
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Inventory</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>QDSQueries.001</PropertyName>
<!-- Used to collect overview of queries executed if they turn on QDS.-->
<SelectQuery>
SELECT db_id() AS database_id,
COUNT_BIG(1) QueryCount,
SUM(count_compiles) TotalCompiles,
MAX(last_compile_duration) MaxLastCompileDuration,
MIN(last_compile_duration) MinLastCompileDuration,
AVG(last_compile_duration) AvgLastCompileDuration,
SUM(last_compile_duration) TotalLastCompileDuration
FROM sys.query_store_query AS Qry
WHERE qry.last_execution_time >= DATEADD(HOUR, -24, GETDATE())
AND qry.is_internal_query = 0
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Inventory</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>SSISPackageExecution.001</PropertyName>
<!-- Used to collect Data Classification feature usage.-->
<SelectQuery>
IF ((SELECT db_name()) LIKE 'SSISDB%'
AND EXISTS (SELECT TOP 1 1
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME IN ('packages', 'executions')
AND TABLE_SCHEMA = 'catalog'
AND COLUMN_NAME IN ('package_id', 'execution_id')
)
)
BEGIN
SELECT
(SELECT COUNT(DISTINCT p.[package_id]) AS PackageCount
FROM [catalog].[packages] p) AS PackageCount,
(SELECT COUNT(DISTINCT e.[execution_id]) AS ExecutionCount
FROM [catalog].[executions] e) AS ExecutionCount;
END
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Inventory</Category>
</PeriodicQuery>
</PeriodicQueries>
� <?xml version="1.0" encoding="utf-8"?>
<PeriodicQueries xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://tempuri.org/PeriodicQueries.xsd">
<PeriodicQuery>
<PropertyName>ISOLanguage.001</PropertyName>
<SelectQuery>
exec xp_msver 'Language'
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Inventory</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>NonStandardSettings.001</PropertyName>
<SelectQuery>
DECLARE @ConfigDefault TABLE (
Name NVARCHAR(35) PRIMARY KEY,
DefaultValue SQL_VARIANT
);
INSERT INTO @ConfigDefault (Name, DefaultValue)
VALUES ('access check cache bucket count',0)
,('access check cache quota',0)
,('Ad Hoc Distributed Queries',0)
,('affinity I/O mask',0)
,('affinity mask',0)
,('affinity64 I/O mask',0)
,('affinity64 mask',0)
,('Agent XPs',1)
,('allow polybase export',0)
,('allow updates',0)
,('awe enabled',0)
,('backup compression default',0)
,('blocked process threshold (s)',0)
,('c2 audit mode',0)
,('clr enabled',0)
,('common criteria compliance enabled',0)
,('cost threshold for parallelism',5)
,('cross db ownership chaining',0)
,('cursor threshold',-1)
,('Database Mail XPs',0)
,('default full-text language',1033)
,('default language',0)
,('default trace enabled',1)
,('disallow results from triggers',0)
,('EKM provider enabled',0)
,('external scripts enabled',0)
,('filestream access level',0)
,('fill factor (%)',0)
,('ft crawl bandwidth (max)',100)
,('ft crawl bandwidth (min)',0)
,('ft notify bandwidth (max)',100)
,('ft notify bandwidth (min)',0)
,('hadoop connectivity',0)
,('index create memory (KB)',0)
,('in-doubt xact resolution',0)
,('lightweight pooling',0)
,('locks',0)
,('max degree of parallelism',0)
,('max full-text crawl range',4)
,('max server memory (MB)',2147483647)
,('max text repl size (B)',65536)
,('max worker threads',0)
,('media retention',0)
,('min memory per query (KB)',1024)
,('min server memory (MB)',0)
,('nested triggers',1)
,('network packet size (B)',4096)
,('Ole Automation Procedures',0)
,('open objects',0)
,('optimize for ad hoc workloads',0)
,('PH timeout (s)',60)
,('polybase network encryption',1)
,('precompute rank',0)
,('priority boost',0)
,('query governor cost limit',0)
,('query wait (s)',-1)
,('recovery interval (min)',0)
,('remote access',1)
,('remote admin connections',0)
,('remote login timeout (s)',10) --20
,('remote proc trans',0)
,('remote query timeout (s)',600)
,('Replication XPs',0)
,('scan for startup procs',0)
,('server trigger recursion',1)
,('set working set size',0)
,('show advanced options',0)
,('SMO and DMO XPs',1)
,('SQL Mail XPs',0)
,('transform noise words',0)
,('two digit year cutoff',2049)
,('user connections',0)
,('user options',0)
,('xp_cmdshell',0)
,('column encryption enclave type',0);
SELECT
c.name ConfigName,
c.value ValueSet,
c.value_in_use ValueInUse,
d.DefaultValue DefaultValue
FROM sys.configurations c WITH(nolock)
INNER JOIN @ConfigDefault d ON c.name = d.Name
WHERE
c.value != c.value_in_use
OR c.value_in_use != d.DefaultValue;
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Server Configuration</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>DatabaseGuid.004</PropertyName>
<SelectQuery>
SELECT database_id, database_guid,
CASE
WHEN db_name(database_id) LIKE '%WideWorldImportersDW%' THEN 'WideWorldImportersDW'
WHEN db_name(database_id) LIKE '%WideWorldImporters%' THEN 'WideWorldImporters'
WHEN db_name(database_id) LIKE '%AdventureWorks2016CTP3%' THEN 'AdventureWorks2016CTP3'
WHEN db_name(database_id) LIKE '%AdventureWorksDW2016CTP3%' THEN 'AdventureWorksDW2016CTP3'
WHEN db_name(database_id) LIKE '%AdventureWorks2014%' THEN 'AdventureWorks2014'
WHEN db_name(database_id) LIKE '%AdventureWorksDW2014%' THEN 'AdventureWorksDW2014'
WHEN db_name(database_id) LIKE '%AdventureWorks2012%' THEN 'AdventureWorks2012'
WHEN db_name(database_id) LIKE '%AdventureWorksDW2012%' THEN 'AdventureWorksDW2012'
WHEN db_name(database_id) LIKE '%AdventureWorks2008%' THEN 'AdventureWorks2008'
WHEN db_name(database_id) LIKE '%AdventureWorksDW2008%' THEN 'AdventureWorksDW2008'
WHEN db_name(database_id) LIKE '%AdventureWorksDW%' THEN 'AdventureWorksDW'
WHEN db_name(database_id) LIKE '%AdventureWorks%' THEN 'AdventureWorks'
WHEN db_name(database_id) LIKE '%ReportServerTempDB%' THEN 'ReportServerTempDB'
WHEN db_name(database_id) LIKE '%ReportServer%' THEN 'ReportServer'
WHEN db_name(database_id) LIKE '%WSS_Content%' THEN 'WSS_Content'
WHEN db_name(database_id) LIKE '%MDW%' THEN 'MDW'
WHEN db_name(database_id) LIKE '%MicrosoftDynamicsAX_baseline%' THEN 'MicrosoftDynamicsAX_baseline'
WHEN db_name(database_id) LIKE '%MicrosoftDynamicsAX%' THEN 'MicrosoftDynamicsAX'
WHEN db_name(database_id) = 'master' THEN 'master'
WHEN db_name(database_id) = 'msdb' THEN 'msdb'
WHEN db_name(database_id) = 'tempdb' THEN 'tempdb'
WHEN db_name(database_id) = 'model' THEN 'model'
WHEN db_name(database_id) LIKE '%SharePoint_Config%' THEN 'SharePoint_Config'
WHEN db_name(database_id) LIKE '%SharePoint_AdminContent%' THEN 'SharePoint_AdminContent'
WHEN db_name(database_id) LIKE '%AppManagement%' THEN 'AppManagement'
WHEN db_name(database_id) LIKE '%Bdc_Service_DB%' THEN 'Bdc_Service_DB'
WHEN db_name(database_id) LIKE '%Search_Service_Application_DB%' THEN 'Search_Service_Application_DB'
WHEN db_name(database_id) LIKE '%Search_Service_Application_AnalyticsReportingStoreDB%' THEN 'Search_Service_Application_AnalyticsReportingStoreDB'
WHEN db_name(database_id) LIKE '%Search_Service_Application_CrawlStoreDB%' THEN 'Search_Service_Application_CrawlStoreDB'
WHEN db_name(database_id) LIKE '%Search_Service_Application_LinkStoreDB%' THEN 'Search_Service_Application_LinkStoreDB'
WHEN db_name(database_id) LIKE '%Secure_Store_Service_DB%' THEN 'Secure_Store_Service_DB'
WHEN db_name(database_id) LIKE '%SharePoint_Logging%' THEN 'SharePoint_Logging'
WHEN db_name(database_id) LIKE '%SettingsServiceDB%' THEN 'SettingsServiceDB'
WHEN db_name(database_id) LIKE '%User Profile Service Application_ProfileDB%' THEN 'User Profile Service Application_ProfileDB'
WHEN db_name(database_id) LIKE '%User Profile Service Application_SyncDB%' THEN 'User Profile Service Application_SyncDB'
WHEN db_name(database_id) LIKE '%User Profile Service Application_SocialDB%' THEN 'User Profile Service Application_SocialDB'
WHEN db_name(database_id) LIKE '%WordAutomationServices%' THEN 'WordAutomationServices'
WHEN db_name(database_id) LIKE '%Managed Metadata Service Application_Metadata%' THEN 'Managed Metadata Service Application_Metadata'
WHEN db_name(database_id) LIKE '%SharePoint Translation Services%' THEN 'SharePoint Translation Services'
WHEN db_name(database_id) LIKE '%ProjectWebApp%' THEN 'ProjectWebApp'
WHEN db_name(database_id) LIKE '%DefaultPowerPivotServiceApplicationDB%' THEN 'DefaultPowerPivotServiceApplicationDB'
WHEN db_name(database_id) LIKE '%PerformancePoint Service%' THEN 'PerformancePoint Service'
WHEN db_name(database_id) LIKE '%SessionStateService%' THEN 'SessionStateService'
WHEN db_name(database_id) = 'SSISDB' THEN 'SSISDB'
WHEN db_name(database_id) = 'DQS_MAIN' THEN 'DQS_MAIN'
ELSE 'Other'
END AS default_database_class
FROM sys.database_recovery_status WITH(nolock)
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Server Configuration</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>ServerServices.002</PropertyName>
<SelectQuery>
SELECT startup_type, status
FROM sys.dm_server_services WITH(nolock)
WHERE servicename LIKE 'SQL Server Agent (%'
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Server Configuration</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>ServerRegistry.001</PropertyName>
<SelectQuery>
SELECT
value_name,
value_data
FROM sys.dm_server_registry WITH(nolock)
WHERE value_name = 'InstallId'
OR (registry_key LIKE '%Polybase%' AND value_name = 'ScaleOutReady')
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Server Configuration</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>AlwaysEncryptedColumnEncryptionEnclaveEnclave.001</PropertyName>
<SelectQuery>
Select
current_enclave_session_count,
current_column_encryption_key_count,
current_memory_size_kb,
total_evicted_session_count
from sys.dm_column_encryption_enclave WITH(nolock)
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Always Encrypted</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>AlwaysEncryptedColumnEncryptionEnclaveEnclaveOperationStats.001</PropertyName>
<SelectQuery>
Select
operation_type,
total_operation_count
from sys.dm_column_encryption_enclave_operation_stats WITH(nolock)
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Always Encrypted</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>HadrAvailabilityReplicaStates.001</PropertyName>
<SelectQuery>
SELECT replica_id, group_id, is_local, role, operational_state, recovery_health, synchronization_health, connected_state, last_connect_error_number, last_connect_error_timestamp FROM sys.dm_hadr_availability_replica_states WITH(nolock)
</SelectQuery>
<Frequency>Day</Frequency>
<Category>HADR</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>SqlServerMemory.001</PropertyName>
<SelectQuery>
SELECT cntr_value AS SqlServerMemory FROM sys.dm_os_performance_counters WITH(nolock) WHERE object_name = 'SQLServer:Memory Manager' AND counter_name = 'Total Server Memory (KB)'
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Server Configuration</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>DatabaseProperties.002</PropertyName>
<SelectQuery>
SELECT
database_id,
source_database_id AS SDID,
create_date,
compatibility_level,
user_access,
is_read_only,
is_auto_close_on,
is_auto_shrink_on,
state,
is_in_standby,
is_cleanly_shutdown,
is_supplemental_logging_enabled AS SLE,
recovery_model,
page_verify_option,
is_auto_create_stats_on AS ACS,
is_auto_create_stats_incremental_on AS ACSI,
is_auto_update_stats_on AS AUS,
is_auto_update_stats_async_on AUSA,
is_fulltext_enabled AS FTE,
is_trustworthy_on AS TW,
is_db_chaining_on AS DBC,
is_parameterization_forced AS PF,
is_master_key_encrypted_by_server AS MKEBS,
is_query_store_on AS QS,
is_published AS TREPL,
is_merge_published AS MREPL,
is_distributor,
is_sync_with_backup AS SWB,
is_broker_enabled AS BE,
log_reuse_wait,
is_cdc_enabled AS CDC,
is_encrypted,
is_honor_broker_priority_on AS HBP,
replica_id AS RID,
group_database_id AS GDID,
resource_pool_id AS RPID,
containment,
target_recovery_time_in_seconds AS TRT,
delayed_durability,
is_memory_optimized_elevate_to_snapshot_on AS MOES,
is_remote_data_archive_enabled AS RDAE,
collation_name AS DBCollation
FROM sys.databases WITH(nolock)
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Inventory</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>TempDbDataFileCount.001</PropertyName>
<SelectQuery>
SELECT COUNT_BIG(*) AS TempDbDataFileCount FROM sys.master_files WITH(nolock) WHERE database_id = 2 AND [type] = 0
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Inventory</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>DatabaseSize.001</PropertyName>
<SelectQuery>SELECT database_id, type, SUM(CAST(size AS BIGINT))*8 as DatabaseSize FROM sys.master_files WITH(nolock) GROUP BY database_id, type</SelectQuery>
<Frequency>Day</Frequency>
<Category>Inventory</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>ReadOnlyRoutingRuleCount.001</PropertyName>
<SelectQuery>select COUNT_BIG(*) AS ReadOnlyRoutingRuleCount from sys.availability_read_only_routing_lists WITH(nolock)</SelectQuery>
<Frequency>Day</Frequency>
<Category>Always On</Category>
</PeriodicQuery>
<!--The following queries help to understand how Transparent Data Encryption (TDE) is being used and configured by the SQL Server instance.
This helps the service understand where changes and investments can be made in encryption-at-rest, including deprecations and further improvements.-->
<PeriodicQuery>
<PropertyName>AsymmetricKeysInfo.001</PropertyName>
<SelectQuery>
-- In the following query, the EKM provider type (cryptographic provider or not) and the asymmetric key algorithm for TDE are collected.
SELECT provider_type, algorithm_desc, COUNT_BIG(*) AS key_count FROM sys.asymmetric_keys WITH(nolock) GROUP BY provider_type, algorithm_desc
</SelectQuery>
<Frequency>Day</Frequency>
<Category>TDE</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>EncryptionCertificateInfo.001</PropertyName>
<SelectQuery>
--In the following query, the certificate certificate key length, and the certificate encryption type for TDE are collected.
SELECT key_length, pvt_key_encryption_type, COUNT_BIG(*) AS cert_count FROM sys.certificates WITH(nolock) GROUP BY key_length, pvt_key_encryption_type
</SelectQuery>
<Frequency>Day</Frequency>
<Category>TDE</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>EncryptionKeyInfo.001</PropertyName>
<SelectQuery>
-- In the following query, the corresponding database ID, symmetric database encryption key algorithm, TDE state, and database encryption key encryptor type are collected.
SELECT database_id, key_algorithm, key_length, encryption_state, encryptor_type, COUNT_BIG(*) AS key_count FROM sys.dm_database_encryption_keys WITH(nolock) GROUP BY database_id, key_algorithm, key_length, encryption_state, encryptor_type
</SelectQuery>
<Frequency>Day</Frequency>
<Category>TDE</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>SQLServerProperties.003</PropertyName>
<SelectQuery>
SELECT
SERVERPROPERTY('Collation') AS [Collation],
SERVERPROPERTY('IsFullTextInstalled') AS [SqlFTinstalled],
SERVERPROPERTY('IsIntegratedSecurityOnly') AS [SqlIntSec],
SERVERPROPERTY('IsSingleUser') AS [IsSingleUser],
SERVERPROPERTY ('FileStreamEffectiveLevel') AS [SqlFilestreamMode],
SERVERPROPERTY('IsPolybaseInstalled') AS [SqlPbInstalled],
SERVERPROPERTY('PolybaseRole') AS [SqlPbNodeRole],
SERVERPROPERTY('ProductMajorVersion') AS [SqlVersionMajor],
SERVERPROPERTY('ProductMinorVersion') AS [SqlVersionMinor],
SERVERPROPERTY('ProductBuild') AS [SqlVersionBuild],
SERVERPROPERTY('ProductBuildType') AS ProductBuildType,
SERVERPROPERTY('ProductLevel') AS ProductLevel,
SERVERPROPERTY('ProductUpdateLevel') AS ProductUpdateLevel,
SERVERPROPERTY('ProductUpdateReference') AS ProductUpdateReference,
RIGHT(CAST(SERVERPROPERTY('ProductVersion') AS NVARCHAR(30)),CHARINDEX('.', REVERSE(CAST(SERVERPROPERTY('ProductVersion') AS NVARCHAR(30)))) - 1) AS ProductRevision,
SERVERPROPERTY('EditionID') AS SQLEditionId,
SERVERPROPERTY('IsClustered') AS IsClustered,
SERVERPROPERTY('IsHadrEnabled') AS IsHadrEnabled,
SERVERPROPERTY('IsAdvancedAnalyticsInstalled') AS [SqlAdvAInstalled],
@@PACK_RECEIVED AS PacketReceived,
@@VERSION AS Version,
SERVERPROPERTY('IsLocalDB') AS IsLocalDB,
SERVERPROPERTY('IsNonGolden') AS IsNonGolden,
SERVERPROPERTY('IsTempdbMetadataMemoryOptimized') AS IsTempdbMetadataMemoryOptimized
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Server Configuration</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>SQLQueryOptimizer.001</PropertyName>
<SelectQuery>
DECLARE @i bigint
SET @i = (SELECT CASE WHEN occurrence = 0 THEN NULL ELSE occurrence END FROM sys.dm_exec_query_optimizer_info WITH(nolock) WHERE counter = N'optimizations')
SELECT
MAX(CASE counter WHEN N'trivial plan' THEN CONVERT(INT, 100000000 * (occurrence * 1.0) / @i) END) AS [SqlQOFracTrivPlan],
MAX(CASE counter WHEN N'search 0' THEN CONVERT(INT, 100000000 * (occurrence * 1.0) / @i) END) AS [SqlQOFracSearch0],
MAX(CASE counter WHEN N'search 1' THEN CONVERT(INT, 100000000 * (occurrence * 1.0) / @i) END) AS [SqlQOFracSearch1],
MAX(CASE counter WHEN N'search 2' THEN CONVERT(INT, 100000000 * (occurrence * 1.0) / @i) END) AS [SqlQOFracSearch2],
MAX(CASE counter WHEN N'timeout' THEN CONVERT(INT, 100000000 * (occurrence * 1.0) / @i) END) AS [SqlQOFracTimeout],
MAX(CASE counter WHEN N'memory limit exceeded' THEN CONVERT(INT, 100000000 * (occurrence * 1.0) / @i) END) AS [SqlQOFracMemLimit],
MAX(CASE counter WHEN N'search 0 time' THEN CONVERT(INT, IsNull(value,0) * 10000) END) AS [SqlQOAvgSearch0time],
MAX(CASE counter WHEN N'search 1 time' THEN CONVERT(INT, IsNull(value,0) * 10000) END) AS [SqlQOAvgSearch1time],
MAX(CASE counter WHEN N'search 2 time' THEN CONVERT(INT, IsNull(value,0) * 10000) END) AS [SqlQOAvgSearch2time],
MAX(CASE counter WHEN N'search 0 tasks' THEN CONVERT(INT, IsNull(value,0)) END) AS [SqlQOAvgSearch0tasks],
MAX(CASE counter WHEN N'search 1 tasks' THEN CONVERT(INT, IsNull(value,0)) END) AS [SqlQOAvgSearch1tasks],
MAX(CASE counter WHEN N'search 2 tasks' THEN CONVERT(INT, IsNull(value,0)) END) AS [SqlQOAvgSearch2tasks],
MAX(CASE counter WHEN N'gain stage 0 to stage 1' THEN CONVERT(INT, IsNull(value,0) * 1000) END) AS [SqlQOAvgStage1gain],
MAX(CASE counter WHEN N'gain stage 1 to stage 2' THEN CONVERT(INT, IsNull(value,0) * 1000) END) AS [SqlQOAvgStage2gain]
FROM sys.dm_exec_query_optimizer_info WITH(nolock)
</SelectQuery>
<Frequency>Day</Frequency>
<Category>QDS</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>SqlEndPointsProtocolStream.001</PropertyName>
<SelectQuery>
SELECT protocol AS [sProtocolId], COUNT_BIG(*) AS [sNumProtocols] FROM master.sys.endpoints WITH(nolock) GROUP BY protocol
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Protocols</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>SBConnections.001</PropertyName>
<!-- Checks whether SSB has any cross-instance connections. If >0 then SQL is using SSB across instances -->
<SelectQuery>
SELECT COUNT_BIG(*) AS SBConnections FROM sys.dm_broker_connections WITH(nolock)
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Service Broker</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>SBForwarderInstances.001</PropertyName>
<SelectQuery>
SELECT COUNT_BIG(*) AS number_of_forwarders
FROM sys.service_broker_endpoints WITH(nolock)
WHERE is_message_forwarding_enabled = 1
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Service Broker</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>OsSysInfo.003</PropertyName>
<SelectQuery>
SELECT
cpu_count AS LogicalCPUCount,
hyperthread_ratio AS HyperthreadRatio,
physical_memory_kb/1024.0 AS PhysicalMemoryMB,
CONVERT(VARCHAR(20), sqlserver_start_time, 120) AS SQLServerStartTime,
affinity_type_desc AS AffinityTypeDesc,
virtual_machine_type AS VirtualMachineType,
socket_count as SocketCount,
cores_per_socket as CoresPerSocket,
numa_node_count as NumaNodeCount,
container_type as ContainerType,
container_type_desc as ContainerDescription
FROM sys.dm_os_sys_info WITH(nolock)
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Server Configuration</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>Auditing.001</PropertyName>
<SelectQuery>
select
type_desc,
on_failure_desc,
queue_delay,
is_state_enabled
from sys.server_audits WITH(nolock)
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Audit</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>ServerAuditAction.002</PropertyName>
<SelectQuery>
select COUNT_BIG(distinct audit_action_name) AS ServerAuditActionCount
from sys.server_audit_specification_details WITH(nolock)
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Audit</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>NumAGinServer.001</PropertyName>
<SelectQuery>
select COUNT_BIG(*) as [NumAGinServer] from sys.availability_groups WITH(nolock)
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Availability Group</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>NumDBperAG.001</PropertyName>
<SelectQuery>
select COUNT_BIG(*) AS [NumDBperAG] from sys.dm_hadr_database_replica_states where group_id in
(select group_id from sys.dm_hadr_availability_replica_states WITH(nolock) where is_local = 1 and role = 1) and is_local = 1 group by group_id
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Availability Group</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>NumReplicaPerAG.001</PropertyName>
<SelectQuery>
select COUNT_BIG(*) AS [NumReplicaPerAG]
from sys.dm_hadr_availability_replica_states where group_id in
(select group_id from sys.dm_hadr_availability_replica_states WITH(nolock) where is_local = 1 and role = 1) group by group_id
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Availability Group</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>AvailabilityGroups.003</PropertyName>
<SelectQuery>
select
group_id,
automated_backup_preference AS [BackupPreference],
failure_condition_level,
health_check_timeout,
dtc_support,
db_failover,
is_distributed,
required_synchronized_secondaries_to_commit,
cluster_type,
sequence_number
from sys.availability_groups where group_id in
(select group_id from sys.dm_hadr_availability_replica_states WITH(nolock) where is_local = 1 and role = 1)
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Availability Group</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>ListenerUsed.001</PropertyName>
<SelectQuery>
select
case
when (listener_id IS NOT NULL) then 1
else 0
end AS [listener_used]
from sys.availability_group_listeners WITH(nolock) where group_id in
(select group_id from sys.dm_hadr_availability_replica_states WITH(nolock) where is_local = 1 and role = 1)
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Availability Group</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>AvailabilityReplicas.002</PropertyName>
<SelectQuery>
select
group_id,
replica_id,
availability_mode,
failover_mode,
primary_role_allow_connections,
secondary_role_allow_connections,
LEN(ISNULL(read_only_routing_url, '')) as read_only_routing_url_length,
seeding_mode,
session_timeout
from sys.availability_replicas WITH(nolock) where group_id in
(select group_id from sys.dm_hadr_availability_replica_states WITH(nolock) where is_local = 1 and role = 1)
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Availability Group</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>SqlBackupStatistics.001</PropertyName>
<SelectQuery>
SELECT b1.device_type,
ISNULL(b1.[type],'NULL') AS backup_type,
b1.is_copy_only,
b1.time_bucket,
b1.compressed_backup_size_bucket,
b1.compression_percent_bucket,
b1.backup_throughput_bucket,
COUNT_BIG(b1.device_type) AS 'count',
b1.encryption
FROM
(
SELECT
mf.device_type,
bset.[type],
CAST(bset.[is_copy_only] AS INT) AS [is_copy_only],
CASE
WHEN DATEDIFF(SECOND, bset.[backup_start_date], bset.[backup_finish_date]) = 0 THEN 0
WHEN DATEDIFF(SECOND, bset.[backup_start_date], bset.[backup_finish_date]) BETWEEN 1 AND 30 THEN 1
WHEN DATEDIFF(SECOND, bset.[backup_start_date], bset.[backup_finish_date]) BETWEEN 30 AND 60 THEN 2
WHEN DATEDIFF(MINUTE, bset.[backup_start_date], bset.[backup_finish_date]) BETWEEN 1 AND 5 THEN 3
WHEN DATEDIFF(MINUTE, bset.[backup_start_date], bset.[backup_finish_date]) BETWEEN 5 AND 10 THEN 4
WHEN DATEDIFF(MINUTE, bset.[backup_start_date], bset.[backup_finish_date]) BETWEEN 10 AND 30 THEN 5
WHEN DATEDIFF(MINUTE, bset.[backup_start_date], bset.[backup_finish_date]) BETWEEN 30 AND 60 THEN 6
WHEN DATEDIFF(HOUR, bset.[backup_start_date], bset.[backup_finish_date]) BETWEEN 1 AND 2 THEN 7
WHEN DATEDIFF(HOUR, bset.[backup_start_date], bset.[backup_finish_date]) BETWEEN 2 AND 6 THEN 8
WHEN DATEDIFF(HOUR, bset.[backup_start_date], bset.[backup_finish_date]) BETWEEN 6 AND 12 THEN 9
WHEN DATEDIFF(HOUR, bset.[backup_start_date], bset.[backup_finish_date]) BETWEEN 12 AND 24 THEN 10
ELSE 99
END
AS 'time_bucket',
CASE
WHEN CAST(ISNULL(bset.compressed_backup_size, 0) / 1048576 AS FLOAT) BETWEEN 0 AND 1 THEN 0
WHEN CAST(ISNULL(bset.compressed_backup_size, 0) / 1048576 AS FLOAT) BETWEEN 1 AND 5 THEN 1
WHEN CAST(ISNULL(bset.compressed_backup_size, 0) / 1048576 AS FLOAT) BETWEEN 5 AND 25 THEN 2
WHEN CAST(ISNULL(bset.compressed_backup_size, 0) / 1048576 AS FLOAT) BETWEEN 25 AND 100 THEN 3
WHEN CAST(ISNULL(bset.compressed_backup_size, 0) / 1048576 AS FLOAT) BETWEEN 100 AND 500 THEN 4
WHEN CAST(ISNULL(bset.compressed_backup_size, 0) / 1048576 AS FLOAT) BETWEEN 500 AND 1000 THEN 5
WHEN CAST(ISNULL(bset.compressed_backup_size, 0) / 1048576 AS FLOAT) BETWEEN 1000 AND 5000 THEN 6
WHEN CAST(ISNULL(bset.compressed_backup_size, 0) / 1048576 AS FLOAT) BETWEEN 5000 AND 10000 THEN 7
WHEN CAST(ISNULL(bset.compressed_backup_size, 0) / 1048576 AS FLOAT) BETWEEN 10000 AND 50000 THEN 8
WHEN CAST(ISNULL(bset.compressed_backup_size, 0) / 1048576 AS FLOAT) BETWEEN 50000 AND 100000 THEN 9
ELSE 99
END
AS compressed_backup_size_bucket,
CASE
WHEN CAST(((ISNULL(bset.backup_size,0) - ISNULL(bset.compressed_backup_size,0)) /
CASE WHEN bset.backup_size <= 0 THEN 1
ELSE ISNULL(bset.backup_size, 1)
END
) * 100 AS FLOAT) = 0.0 THEN 0
ELSE (CAST(((ISNULL(bset.backup_size,0) - ISNULL(bset.compressed_backup_size,0)) /
CASE WHEN bset.backup_size <= 0 THEN 1
ELSE ISNULL(bset.backup_size, 1)
END
) * 100 AS INT)/10) + 1
END
AS compression_percent_bucket,
CASE
WHEN CAST(CAST(ISNULL(bset.compressed_backup_size, 0) / 1024 AS FLOAT) / (CASE WHEN DATEDIFF(SECOND, bset.[backup_start_date], bset.[backup_finish_date]) = 0 THEN 1 END) AS FLOAT) = 0.0 THEN 0
WHEN CAST(CAST(ISNULL(bset.compressed_backup_size, 0) / 1024 AS FLOAT) / (CASE WHEN DATEDIFF(SECOND, bset.[backup_start_date], bset.[backup_finish_date]) = 0 THEN 1 END) AS FLOAT) BETWEEN 0 AND 100 THEN 1
WHEN CAST(CAST(ISNULL(bset.compressed_backup_size, 0) / 1024 AS FLOAT) / (CASE WHEN DATEDIFF(SECOND, bset.[backup_start_date], bset.[backup_finish_date]) = 0 THEN 1 END) AS FLOAT) BETWEEN 100 AND 500 THEN 2
WHEN CAST(CAST(ISNULL(bset.compressed_backup_size, 0) / 1024 AS FLOAT) / (CASE WHEN DATEDIFF(SECOND, bset.[backup_start_date], bset.[backup_finish_date]) = 0 THEN 1 END) AS FLOAT) BETWEEN 500 AND 1000 THEN 3
WHEN CAST(CAST(ISNULL(bset.compressed_backup_size, 0) / 1024 AS FLOAT) / (CASE WHEN DATEDIFF(SECOND, bset.[backup_start_date], bset.[backup_finish_date]) = 0 THEN 1 END) AS FLOAT) BETWEEN 1000 AND 5000 THEN 4
WHEN CAST(CAST(ISNULL(bset.compressed_backup_size, 0) / 1024 AS FLOAT) / (CASE WHEN DATEDIFF(SECOND, bset.[backup_start_date], bset.[backup_finish_date]) = 0 THEN 1 END) AS FLOAT) BETWEEN 5000 AND 10000 THEN 5
WHEN CAST(CAST(ISNULL(bset.compressed_backup_size, 0) / 1024 AS FLOAT) / (CASE WHEN DATEDIFF(SECOND, bset.[backup_start_date], bset.[backup_finish_date]) = 0 THEN 1 END) AS FLOAT) BETWEEN 10000 AND 20000 THEN 6
WHEN CAST(CAST(ISNULL(bset.compressed_backup_size, 0) / 1024 AS FLOAT) / (CASE WHEN DATEDIFF(SECOND, bset.[backup_start_date], bset.[backup_finish_date]) = 0 THEN 1 END) AS FLOAT) BETWEEN 20000 AND 30000 THEN 7
WHEN CAST(CAST(ISNULL(bset.compressed_backup_size, 0) / 1024 AS FLOAT) / (CASE WHEN DATEDIFF(SECOND, bset.[backup_start_date], bset.[backup_finish_date]) = 0 THEN 1 END) AS FLOAT) BETWEEN 30000 AND 50000 THEN 8
WHEN CAST(CAST(ISNULL(bset.compressed_backup_size, 0) / 1024 AS FLOAT) / (CASE WHEN DATEDIFF(SECOND, bset.[backup_start_date], bset.[backup_finish_date]) = 0 THEN 1 END) AS FLOAT) BETWEEN 50000 AND 100000 THEN 9
WHEN CAST(CAST(ISNULL(bset.compressed_backup_size, 0) / 1024 AS FLOAT) / (CASE WHEN DATEDIFF(SECOND, bset.[backup_start_date], bset.[backup_finish_date]) = 0 THEN 1 END) AS FLOAT) BETWEEN 100000 AND 500000 THEN 10
WHEN CAST(CAST(ISNULL(bset.compressed_backup_size, 0) / 1024 AS FLOAT) / (CASE WHEN DATEDIFF(SECOND, bset.[backup_start_date], bset.[backup_finish_date]) = 0 THEN 1 END) AS FLOAT) BETWEEN 500000 AND 1000000 THEN 11
ELSE 99
END
AS backup_throughput_bucket, -- in KB
CASE
WHEN bset.encryptor_type like '%CERTIFICATE%' THEN 1
WHEN bset.encryptor_type like '%ASYMMETRIC KEY%' THEN 2
ELSE 0
END
AS encryption
FROM [msdb].[dbo].[backupset] bset WITH (READUNCOMMITTED)
JOIN [msdb].[dbo].[backupmediafamily] mf WITH (READUNCOMMITTED) ON mf.media_set_id = bset.media_set_id
WHERE
backup_finish_date <= GETDATE() and backup_finish_date > DATEADD(hh, -24, GETDATE() )
) AS b1
GROUP BY
b1.device_type,
b1.[type],
b1.is_copy_only,
b1.time_bucket,
b1.compressed_backup_size_bucket,
b1.compression_percent_bucket,
b1.backup_throughput_bucket,
b1.encryption
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Backup</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>DatabaseIOStream.001</PropertyName>
<SelectQuery>
select 1 as name, -- Temp DB
case mf.type_desc
when 'ROWS' then 1
when 'LOG' then 2
end as 'type',
CAST(SUM(num_of_reads) as nvarchar(128)) as total_num_of_reads,
CAST(SUM(num_of_bytes_read) as nvarchar(128)) as total_num_of_bytes_read,
CAST(SUM(io_stall_read_ms) as nvarchar(128)) as total_io_stall_read_ms,
CAST(SUM(num_of_writes) as nvarchar(128)) as total_num_of_writes,
CAST(SUM(num_of_bytes_written) as nvarchar(128)) as total_num_of_bytes_written,
CAST(SUM(io_stall_write_ms) as nvarchar(128)) as total_io_stall_write_ms,
COUNT_BIG(*) as total
from sys.dm_io_virtual_file_stats(NULL, NULL) fs, sys.master_files mf
where fs.database_id = mf.database_id and fs.file_id = mf.file_id and fs.database_id = 2 and (fs.num_of_reads != 0 OR fs.num_of_writes != 0)
group by mf.name, mf.type, mf.type_desc
UNION ALL
select 2 as name, -- User DBs
case mf.type_desc
when 'ROWS' then 1
when 'LOG' then 2
end as 'type',
CAST(SUM(num_of_reads) as nvarchar(128)) as total_num_of_reads,
CAST(SUM(num_of_bytes_read) as nvarchar(128)) as total_num_of_bytes_read,
CAST(SUM(io_stall_read_ms) as nvarchar(128)) as total_io_stall_read_ms,
CAST(SUM(num_of_writes) as nvarchar(128)) as total_num_of_writes,
CAST(SUM(num_of_bytes_written) as nvarchar(128)) as total_num_of_bytes_written,
CAST(SUM(io_stall_write_ms) as nvarchar(128)) as total_io_stall_write_ms,
COUNT_BIG(*) as total
from sys.dm_io_virtual_file_stats(NULL, NULL) fs, sys.master_files mf
where fs.database_id = mf.database_id and fs.file_id = mf.file_id and fs.database_id > 4 and (fs.num_of_reads != 0 OR fs.num_of_writes != 0)
group by mf.type, mf.type_desc
UNION ALL
select 3 as name, -- System DBs
case mf.type_desc
when 'ROWS' then 1
when 'LOG' then 2
end as 'type',
CAST(SUM(num_of_reads) as nvarchar(128)) as total_num_of_reads,
CAST(SUM(num_of_bytes_read) as nvarchar(128)) as total_num_of_bytes_read,
CAST(SUM(io_stall_read_ms) as nvarchar(128)) as total_io_stall_read_ms,
CAST(SUM(num_of_writes) as nvarchar(128)) as total_num_of_writes,
CAST(SUM(num_of_bytes_written) as nvarchar(128)) as total_num_of_bytes_written,
CAST(SUM(io_stall_write_ms) as nvarchar(128)) as total_io_stall_write_ms,
COUNT_BIG(*) as total
from sys.dm_io_virtual_file_stats(NULL, NULL) fs, sys.master_files mf WITH(nolock)
where fs.database_id = mf.database_id and fs.file_id = mf.file_id and (fs.database_id = 1 OR fs.database_id = 3 OR fs.database_id = 4) and (fs.num_of_reads != 0 OR fs.num_of_writes != 0)
group by mf.type, mf.type_desc
</SelectQuery>
<Frequency>Day</Frequency>
<Category>SQL Engine Performance</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>XTPMemoryAllocatedForSystemKb.001</PropertyName>
<SelectQuery>
SELECT
ISNULL(sum(allocated_bytes)/1024,0) AS total_memory_allocated_for_system_kb
FROM sys.dm_xtp_system_memory_consumers WITH(nolock)
</SelectQuery>
<Frequency>Day</Frequency>
<Category>InMemory</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>XTPTransactionStatistics.001</PropertyName>
<SelectQuery>
SELECT
total_count,
rows_touched,
dependencies_taken,
dependencies_failed,
validation_failures
FROM sys.dm_xtp_transaction_stats WITH(nolock)
</SelectQuery>
<Frequency>Day</Frequency>
<Category>InMemory</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>SQLXIDBFileCount.001</PropertyName>
<SelectQuery>
-- SQLXI datapoint - count of db files in XI path
SELECT COUNT_BIG(name) AS xi_db_file_count
FROM sys.master_files WITH(nolock)
WHERE credential_id IS NOT NULL
AND state = 0
</SelectQuery>
<Frequency>Day</Frequency>
<Category>HADR</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>ColumnstoreMergePolicy.001</PropertyName>
<SelectQuery>
select cntr_value as merge_policy_evaluation
from sys.dm_os_performance_counters WITH(nolock)
where
object_name like '%columnstore%' and
counter_name ='Total Merge Policy Evaluations' and
instance_name = '_Total'
</SelectQuery>
<Frequency>Day</Frequency>
<Category>ColumnStore</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>DbccTraceStatus.001</PropertyName>
<SelectQuery>
DBCC TRACESTATUS
</SelectQuery>
<Frequency>Day</Frequency>
<Category>SQL Engine Performance</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>ExternalScriptStats.001</PropertyName>
<SelectQuery>
select counter_name, cntr_value from sys.dm_os_performance_counters where object_name like '%External Scripts%'
</SelectQuery>
<Frequency>Day</Frequency>
<Category>R</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>ExternalResourcePools.001</PropertyName>
<SelectQuery>
SELECT count_big(*) AS external_resource_pools from sys.resource_governor_external_resource_pools WHERE name != 'default'
</SelectQuery>
<Frequency>Day</Frequency>
<Category>R</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>ExternalScriptExecStats.001</PropertyName>
<SelectQuery>
select language, counter_name, counter_value from sys.dm_external_script_execution_stats
</SelectQuery>
<Frequency>Day</Frequency>
<Category>R</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>SQLConnectorInfo.001</PropertyName>
<SelectQuery>
/*The following query helps to understand how the Microsoft SQL Server Connector for Azure Key Vault (EKM Provider) is being used for those configuring Azure Key Vault for Transparent Data Encryption (TDE), Cell Level Encryption (CLE), and/or Backup encryption.
The count of cryptographic EKM providers and the version number of SQL Server Connector on the SQL Server instance are collected. For non-Microsoft EKM providers, no specific information other than the count of non-Microsoft providers is being queried.
Note: 'A16BA7DE-26E0-43C4-871C-4ED750C65597' is the provider guid for the Microsoft SQL Server Connector, and is used only to help identify its use by the instance.*/
SELECT
'Other' as ProviderType,
null as ProviderVersion,
count_big(*) as ProviderCount
FROM sys.dm_cryptographic_provider_properties
WHERE guid != 'A16BA7DE-26E0-43C4-871C-4ED750C65597'
UNION ALL
SELECT
'SQLServerConnector' as ProviderType,
provider_version as ProviderVersion,
1 as ProviderCount
FROM sys.dm_cryptographic_provider_properties
WHERE guid = 'A16BA7DE-26E0-43C4-871C-4ED750C65597'
ORDER BY ProviderType, ProviderVersion
</SelectQuery>
<Frequency>Day</Frequency>
<Category>TDE</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>BPEConfiguration.001</PropertyName>
<!-- Used to collect configuration information about Buffer Pool Extension (BPE)-->
<SelectQuery>
SELECT state, current_size_in_kb FROM sys.dm_os_buffer_pool_extension_configuration WITH(nolock)
</SelectQuery>
<Frequency>Day</Frequency>
<Category>SQL Engine Performance</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>HostInformation.001</PropertyName>
<!-- Used to collect OS related information about the host -->
<SelectQuery>
SELECT
host_platform,
host_distribution,
host_release,
host_service_pack_level,
host_sku,
os_language_version
FROM sys.dm_os_host_info
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Inventory</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>AvailabilityGroupsWithDtcSupport.001</PropertyName>
<SelectQuery>
select count(*) as AgsWithDtcSupportOn
from sys.availability_groups WITH(nolock) where dtc_support = 1 and group_id in
(select group_id from sys.dm_hadr_availability_replica_states WITH(nolock) where is_local = 1 and role = 1)
</SelectQuery>
<Frequency>Day</Frequency>
<Category>HADR</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>AvailabilityGroupListeners.002</PropertyName>
<SelectQuery>
select group_id, listener_id, LEN(ISNULL(dns_name,'')) AS dns_length, is_conformant
from sys.availability_group_listeners WITH(nolock)
where group_id in (select group_id from sys.dm_hadr_availability_replica_states WITH(nolock) where is_local = 1 and role = 1)
</SelectQuery>
<Frequency>Day</Frequency>
<Category>HADR</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>DmHadrDatabaseReplicaStates.002</PropertyName>
<SelectQuery>
SELECT top 1000
group_id, replica_id, group_database_id,group_database_id, is_local, is_primary_replica, synchronization_state, is_commit_participant, synchronization_health, database_state, is_suspended
FROM sys.dm_hadr_database_replica_states WITH(nolock)
where group_id in (select group_id from sys.dm_hadr_availability_replica_states WITH(nolock) where is_local = 1 and role = 1)
</SelectQuery>
<Frequency>Day</Frequency>
<Category>HADR</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>LinkedServerInstances.001</PropertyName>
<!--Collect information on Linked Server and distribution of OLE DB providers used for Linked Servers. Assume that non-default server entries indicate some Distributed Query operations are being done-->
<SelectQuery>
SELECT COUNT(*) as provider_count, provider FROM sys.servers WITH(nolock) WHERE is_linked=1 GROUP BY provider
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Server Configuration</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>CPUUtilization.001</PropertyName>
<SelectQuery>
DECLARE @msticks bigint, @mstickstime datetime, @LastHour datetime
SELECT @mstickstime = GETDATE(), @msticks = ms_ticks from sys.dm_os_sys_info
SELECT @LastHour = DATEADD(HOUR, -1, @mstickstime);
WITH Quartiles AS (
SELECT DISTINCT
CONVERT(VARCHAR(10), CAST(DATEADD (ms, -1 * (@msticks - [timestamp]),@mstickstime) AS DATE), 112) EventDate,
CONVERT(VARCHAR(30), TIMEFROMPARTS(DATEPART(HOUR, DATEADD (ms, -1 * (@msticks - [timestamp]),@mstickstime)), 00,00,00,00), 114) AS [EventTime],
PERCENTILE_DISC(0.5) WITHIN GROUP (ORDER BY record.value('(Record/SchedulerMonitorEvent/SystemHealth/ProcessUtilization)[1]', 'int')
)
OVER (PARTITION BY CONVERT(VARCHAR(10), CAST(DATEADD (ms, -1 * (@msticks - [timestamp]),@mstickstime) AS DATE), 112),
CONVERT(VARCHAR(30), TIMEFROMPARTS(DATEPART(HOUR, DATEADD (ms, -1 * (@msticks - [timestamp]),@mstickstime)), 00,00,00,00), 114)
) AS MedianSQLCPU
,
PERCENTILE_CONT(0.75) WITHIN GROUP (ORDER BY record.value('(Record/SchedulerMonitorEvent/SystemHealth/ProcessUtilization)[1]', 'int')
)
OVER (PARTITION BY CONVERT(VARCHAR(10), CAST(DATEADD (ms, -1 * (@msticks - [timestamp]),@mstickstime) AS DATE), 112),
CONVERT(VARCHAR(30), TIMEFROMPARTS(DATEPART(HOUR, DATEADD (ms, -1 * (@msticks - [timestamp]),@mstickstime)), 00,00,00,00), 114)
) AS Q3SQLCPU
,
PERCENTILE_CONT(0.25) WITHIN GROUP (ORDER BY record.value('(Record/SchedulerMonitorEvent/SystemHealth/ProcessUtilization)[1]', 'int')
)
OVER (PARTITION BY CONVERT(VARCHAR(10), CAST(DATEADD (ms, -1 * (@msticks - [timestamp]),@mstickstime) AS DATE), 112),
CONVERT(VARCHAR(30), TIMEFROMPARTS(DATEPART(HOUR, DATEADD (ms, -1 * (@msticks - [timestamp]),@mstickstime)), 00,00,00,00), 114)
) AS Q1SQLCPU
FROM (
SELECT timestamp, CONVERT (xml, record) AS 'record'
FROM sys.dm_os_ring_buffers
WHERE ring_buffer_type = 'RING_BUFFER_SCHEDULER_MONITOR'
AND record LIKE '%<SystemHealth>%'
) AS t
WHERE DATEPART(HOUR, DATEADD (ms, -1 * (@msticks - [timestamp]),@mstickstime)) = DATEPART(HOUR, @LastHour)
AND CAST(DATEADD (ms, -1 * (@msticks - [timestamp]),@mstickstime) AS DATE) = CAST(@LastHour AS DATE)
),
SimpleStats AS (
SELECT
CONVERT(VARCHAR(10), CAST(DATEADD (ms, -1 * (@msticks - [timestamp]),@mstickstime) AS DATE), 112) EventDate,
CONVERT(VARCHAR(30), TIMEFROMPARTS(DATEPART(HOUR, DATEADD (ms, -1 * (@msticks - [timestamp]),@mstickstime)), 00,00,00,00), 114) AS [EventTime],
MAX(record.value('(Record/SchedulerMonitorEvent/SystemHealth/ProcessUtilization)[1]', 'int')) AS [MaxSQLCPU],
MIN(record.value('(Record/SchedulerMonitorEvent/SystemHealth/ProcessUtilization)[1]', 'int')) AS [MinSQLCPU],
AVG(record.value('(Record/SchedulerMonitorEvent/SystemHealth/ProcessUtilization)[1]', 'int')) AS [AvgSQLCPU]
FROM (
SELECT timestamp, CONVERT (xml, record) AS 'record'
FROM sys.dm_os_ring_buffers
WHERE ring_buffer_type = 'RING_BUFFER_SCHEDULER_MONITOR'
AND record LIKE '%<SystemHealth>%'
) AS t
WHERE DATEPART(HOUR, DATEADD (ms, -1 * (@msticks - [timestamp]),@mstickstime)) = DATEPART(HOUR, @LastHour)
AND CAST(DATEADD (ms, -1 * (@msticks - [timestamp]),@mstickstime) AS DATE) = CAST(@LastHour AS DATE)
GROUP BY
CONVERT(VARCHAR(10), CAST(DATEADD (ms, -1 * (@msticks - [timestamp]),@mstickstime) AS DATE), 112) ,
CONVERT(VARCHAR(30), TIMEFROMPARTS(DATEPART(HOUR, DATEADD (ms, -1 * (@msticks - [timestamp]),@mstickstime)), 00,00,00,00), 114)
)
SELECT
ss.EventDate AS EventDate,
ss.EventTime AS EventTime,
ss.MaxSQLCPU,
ss.MinSQLCPU,
ss.AvgSQLCPU,
q.MedianSQLCPU,
q.Q1SQLCPU,
q.Q3SQLCPU
FROM SimpleStats ss
INNER JOIN Quartiles q
ON q.EventDate = ss.EventDate
AND q.EventTime = ss.EventTime
</SelectQuery>
<Frequency>Hour</Frequency>
<Category>Inventory</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>SQLServerLoginStats.001</PropertyName>
<SelectQuery>
SELECT pr.type PrincipalType,
pr.default_language_name DefaultLanguageName,
COUNT_BIG(DISTINCT pr.principal_id) PrincipalCount
FROM sys.server_principals AS pr
GROUP BY
pr.type, pr.default_language_name
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Server Configuration</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>QuorumConfiguration.001</PropertyName>
<SelectQuery>
SELECT quorum_type_desc FROM [sys].[dm_hadr_cluster]
</SelectQuery>
<Frequency>Day</Frequency>
<Category>HADR</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>NumNodesInCluster.001</PropertyName>
<SelectQuery>
SELECT COUNT_BIG(*) AS NumOfNodes FROM [sys].[dm_hadr_cluster_members] WHERE member_type = 0
</SelectQuery>
<Frequency>Day</Frequency>
<Category>HADR</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>ChangeTrackingDatabases.001</PropertyName>
<SelectQuery>
SELECT
database_id,
is_auto_cleanup_on,
retention_period,
retention_period_units_desc,
retention_period_units
FROM sys.change_tracking_databases
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Server Configuration</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>PolybaseCluster.002</PropertyName>
<SelectQuery>
select 1 IsPolybaseCluster
where exists (select * from sys.dm_cluster_endpoints)
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Server Configuration</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>DTCActiveTransactions.001</PropertyName>
<SelectQuery>
SELECT COUNT_BIG(DISTINCT transaction_uow) DTCActiveTransactions
FROM sys.dm_tran_active_transactions WITH (NOLOCK)
WHERE name = 'DTC Transaction';
</SelectQuery>
<Frequency>Day</Frequency>
<Category>HADR</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>DistributedModules.001</PropertyName>
<SelectQuery>
SELECT
CASE
WHEN name like '%msdtcprx.dll%' THEN 'msdtcprx'
WHEN name like '%sqljdbc_xa.dll%' THEN 'sqljdbc_xa'
ELSE NULL
END AS LoadedModules,
COUNT(1) AS ModuleCount
FROM sys.dm_os_loaded_modules WITH (NOLOCK)
WHERE name like '%msdtcprx.dll%'
OR name like '%sqljdbc_xa.dll%'
GROUP BY
CASE WHEN name like '%msdtcprx.dll%' THEN 'msdtcprx'
WHEN name like '%sqljdbc_xa.dll%' THEN 'sqljdbc_xa'
ELSE NULL
END;
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Inventory</Category>
</PeriodicQuery>
</PeriodicQueries> <?xml version="1.0" encoding="utf-8"?>
<PeriodicQueries xmlns="http://tempuri.org/PeriodicQueries.xsd">
</PeriodicQueries> <?xml version="1.0" encoding="utf-8"?>
<PeriodicQueries xmlns="http://tempuri.org/PeriodicQueries.xsd">
<PeriodicQuery>
<PropertyName>DBCompatibilityType</PropertyName>
<SelectQuery>
SELECT [Compatibility_Level], [Type], 1 as [CountDBCompatibilityType] FROM [$system].[DBSCHEMA_CATALOGS] Order by [Compatibility_Level]
</SelectQuery>
<Frequency>Day</Frequency>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>ASInstanceDaily</PropertyName>
<SelectQuery>
XMLA:InstanceDay
</SelectQuery>
<Frequency>Day</Frequency>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>ASInstanceOnce</PropertyName>
<SelectQuery>
XMLA:InstanceOnce
</SelectQuery>
<Frequency>Day</Frequency>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>CurrentConnections</PropertyName>
<SelectQuery>
select 1 as [ConnectionCount] from [$SYSTEM].[DISCOVER_CONNECTIONS]
</SelectQuery>
<Frequency>Hour</Frequency>
</PeriodicQuery>
</PeriodicQueries> <?xml version="1.0" encoding="utf-8"?>
<PeriodicQueries xmlns="http://tempuri.org/PeriodicQueries.xsd">
<PeriodicQuery>
<PropertyName>SSISXeQuery</PropertyName>
<SelectQuery>
xequery
</SelectQuery>
<Frequency>Hour</Frequency>
</PeriodicQuery>
</PeriodicQueries> � <?xml version="1.0" encoding="utf-8"?>
<PeriodicQueries xmlns="http://tempuri.org/PeriodicQueries.xsd">
<PeriodicQuery>
<PropertyName>XeQuery</PropertyName>
<SelectQuery>
xequery
</SelectQuery>
<Frequency>Hour</Frequency>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>XeCollect</PropertyName>
<SelectQuery>
xecollect
</SelectQuery>
<Frequency>FiveMinute</Frequency>
</PeriodicQuery>
</PeriodicQueries> �� <?xml version="1.0" encoding="utf-8"?>
<XEvents xmlns="http://tempuri.org/XEventAggregations.xsd">
<XEvent Package="sqlserver" Name="error_reported" Version="1" Category="Errors">
<Predicate>severity >= 16
or (error_number = 18456
or error_number = 17803 or error_number = 701 or error_number = 802 or error_number = 8645 or error_number = 8651
or error_number = 8657 or error_number = 8902 or error_number = 41354 or error_number = 41355 or error_number = 41367
or error_number = 41384 or error_number = 41336 or error_number = 41309 or error_number = 41312 or error_number = 41313
or error_number = 33065 or error_number = 33066)</Predicate>
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>error_number</Field>
<Field>state</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="missing_column_statistics" Version="1" Category="QDS">
<Aggregates>
<Aggregate>
<GroupingFields />
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="missing_join_predicate" Version="1" Category="QDS">
<Aggregates>
<Aggregate>
<GroupingFields />
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="server_memory_change" Version="1" Category="Stretch DB">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>new_memory_size_mb</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="stretch_database_disable_completed" Version="1" Category="Stretch DB">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
<Field>error_number</Field>
<Field>error_state</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="stretch_database_enable_completed" Version="1" Category="Stretch DB">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
<Field>error_number</Field>
<Field>error_state</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="stretch_database_reauthorize_completed" Version="1" Category="Stretch DB">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
<Field>error_number</Field>
<Field>error_state</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="stretch_index_reconciliation_codegen_completed" Version="1" Category="Stretch DB">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
<Field>error_number</Field>
<Field>error_state</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
<Field>error_number</Field>
<Field>error_state</Field>
</GroupingFields>
<Aggregation Function="LAST" Field="message" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="stretch_remote_column_execution_completed" Version="1" Category="Stretch DB">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
<Field>error_number</Field>
<Field>error_state</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="stretch_remote_column_reconciliation_codegen_completed" Version="1" Category="Stretch DB">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
<Field>error_number</Field>
<Field>error_state</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="stretch_remote_index_execution_completed" Version="1" Category="Stretch DB">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
<Field>error_number</Field>
<Field>error_state</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="stretch_table_codegen_completed" Version="1" Category="Stretch DB">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
<Field>error_number</Field>
<Field>error_state</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
<Field>error_number</Field>
<Field>error_state</Field>
</GroupingFields>
<Aggregation Function="LAST" Field="message" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="stretch_table_alter_ddl" Version="1" Category="Stretch DB">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
<Field>error_number</Field>
<Field>error_state</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="stretch_table_create_ddl" Version="1" Category="Stretch DB">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
<Field>error_number</Field>
<Field>error_state</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="stretch_table_predicate_not_specified" Version="1" Category="Stretch DB">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
<Field>error_number</Field>
<Field>error_state</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="stretch_table_predicate_specified" Version="1" Category="Stretch DB">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
<Field>error_number</Field>
<Field>error_state</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="stretch_table_remote_creation_completed" Version="1" Category="Stretch DB">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
<Field>error_number</Field>
<Field>error_state</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="stretch_table_row_migration_results_event" Version="1" Category="Stretch DB">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
<Field>error_number</Field>
<Field>error_state</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="stretch_table_row_unmigration_results_event" Version="1" Category="Stretch DB">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
<Field>error_number</Field>
<Field>error_state</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="stretch_table_data_reconciliation_results_event" Version="1" Category="Stretch DB">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
<Field>error_number</Field>
<Field>error_state</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="stretch_table_unprovision_completed" Version="1" Category="Stretch DB">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
<Field>error_number</Field>
<Field>error_state</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="stretch_table_validation_error" Version="1" Category="Stretch DB">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
<Field>error_number</Field>
<Field>error_state</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
<Field>error_number</Field>
<Field>error_state</Field>
</GroupingFields>
<Aggregation Function="LAST" Field="message" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="stretch_table_hinted_admin_update_event" Version="1" Category="Stretch DB">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
<Field>error_number</Field>
<Field>error_state</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="stretch_table_hinted_admin_delete_event" Version="1" Category="Stretch DB">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
<Field>error_number</Field>
<Field>error_state</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="stretch_table_query_error" Version="1" Category="Stretch DB">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
<Field>error_number</Field>
<Field>error_state</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="stretch_remote_error" Version="1" Category="Stretch DB">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>error_number</Field>
<Field>error_state</Field>
<Field>stretch_operation_id</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="stretch_query_telemetry" Version="1" Category="Stretch DB">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>loop_joins</Field>
<Field>hash_joins</Field>
<Field>merge_joins</Field>
<Field>not_stretched_tables</Field>
<Field>stretched_tables</Field>
<Field>stretch_remote_tables</Field>
<Field>aggregates</Field>
<Field>query_type</Field>
<Field>elapsed_time</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="temporal_ddl_system_versioning" Version="1" Category="Temporal">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="temporal_dml_transaction_fail" Version="1" Category="Temporal">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="temporal_ddl_period_add" Version="1" Category="Temporal">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="temporal_ddl_period_drop" Version="1" Category="Temporal">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="temporal_ddl_schema_check_fail" Version="1" Category="Temporal">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="data_masking_ddl_column_definition" Version="1" Category="Data Masking">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="data_masking_traffic" Version="1" Category="Data Masking">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>component</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="data_masking_traffic_masked_only" Version="1" Category="Data Masking">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>component</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="data_classification_ddl_column_definition" Version="1" Category="Data Classification">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="data_classification_traffic" Version="1" Category="Data Classification">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="data_classification_auditing_traffic" Version="1" Category="Data Classification">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="feature_restriction_ddl" Version="1" Category="Feature Restrictions">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="feature_restriction_usage" Version="1" Category="Feature Restrictions">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="always_encrypted_query_count" Version="1" Category="Always Encrypted">
<Aggregates>
<Aggregate>
<GroupingFields />
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
<Aggregate>
<GroupingFields />
<Aggregation Function="LAST" Field="message" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="rls_query_count" Version="1" Category="RLS">
<Aggregates>
<Aggregate>
<GroupingFields />
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
<Aggregate>
<GroupingFields />
<Aggregation Function="LAST" Field="message" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="auto_stats" Version="1" Category="SQL Engine Performance">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="database_cmptlevel_change" Version="1" Category="SQL Engine Performance">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
<Field>previous_value</Field>
<Field>new_value</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="database_created" Version="1" Category="SQL Engine Performance">
<Aggregates>
<Aggregate>
<GroupingFields />
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="database_dropped" Version="1" Category="SQL Engine Performance">
<Aggregates>
<Aggregate>
<GroupingFields />
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="reason_many_foreign_keys_operator_not_used" Version="1" Category="SQL Engine Performance">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>number_of_fk_tables</Field>
<Field>reason_operator_not_used</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="interleaved_exec_status" Version="1" Category="SQL Engine Performance">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>operator_code</Field>
<Field>event_type</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="table_variable_deferred_compilation" Version="1" Category="SQL Engine Performance">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>event_type</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="graph_match_query_compiled" Version="1" Category="SQL Engine Performance">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="approximate_count_distinct_query_compiled" Version="1" Category="SQL Engine Performance">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="login_protocol_count" Version="1" Category="Login">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>protocol</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="column_store_index_build_low_memory" Version="1" Category="ColumnStore">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="column_store_index_build_throttle" Version="1" Category="ColumnStore">
<Aggregates>
<Aggregate>
<GroupingFields />
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="columnstore_delete_buffer_flush_failed" Version="1" Category="ColumnStore">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
<Field>error_number</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="columnstore_delta_rowgroup_closed" Version="1" Category="ColumnStore">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="columnstore_index_reorg_failed" Version="1" Category="ColumnStore">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
<Field>error_number</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="columnstore_log_exception" Version="1" Category="ColumnStore">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="columnstore_rowgroup_merge_failed" Version="1" Category="ColumnStore">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="columnstore_tuple_mover_delete_buffer_truncate_timed_out" Version="1" Category="ColumnStore">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="columnstore_tuple_mover_end_compress" Version="1" Category="ColumnStore">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="query_memory_grant_blocking" Version="1" Category="ColumnStore">
<Aggregates>
<Aggregate>
<GroupingFields />
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="natively_compiled_module_inefficiency_detected" Version="1" Category="Inventory">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
<Field>reason</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="natively_compiled_proc_slow_parameter_passing" Version="1" Category="Inventory">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
<Field>reason</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="xtp_alter_table" Version="1" Category="InMemory">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="xtp_db_delete_only_mode_updatedhktrimlsn" Version="1" Category="InMemory">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="xtp_stgif_container_added" Version="1" Category="InMemory">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="xtp_stgif_container_deleted" Version="1" Category="InMemory">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="xtpcompile" Name="cl_duration" Version="1" Category="InMemory">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
<Field>duration</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="xtpengine" Name="xtp_physical_db_restarted" Version="1" Category="InMemory">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="xtpengine" Name="xtp_db_delete_only_mode_enter" Version="1" Category="InMemory">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="xtpengine" Name="xtp_db_delete_only_mode_update" Version="1" Category="InMemory">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="xtpengine" Name="xtp_db_delete_only_mode_exit" Version="1" Category="InMemory">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="xtpengine" Name="parallel_alter_stats" Version="1" Category="InMemory">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
<Field>elapsed_time_ms</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="xtpengine" Name="serial_alter_stats" Version="1" Category="InMemory">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
<Field>elapsed_time_ms</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="json_function_compiled" Version="1" Category="JSON">
<Action>database_id</Action>
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
<Field>json_function_name</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="string_escape_compiled" Version="1" Category="JSON">
<Action>database_id</Action>
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
<Field>escape_type</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="window_function_used" Version="1" Category="Window / Ranking Functions">
<Action>database_id</Action>
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
<Field>execution_details</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="sequence_function_used" Version="1" Category="Window / Ranking Functions">
<Action>database_id</Action>
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
<Field>execution_details</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="qds" Name="query_store_db_diagnostics" Version="1" Category="QDS">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<!-- Index Build Telemetry Start -->
<XEvent Package="sqlserver" Name="index_defragmentation" Version="1" Category="IndexBuild">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>online</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="online" />
</Aggregate>
<Aggregate>
<GroupingFields>
<Field>index_type</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="index_type" />
</Aggregate>
<Aggregate>
<GroupingFields>
<Field>index_id</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="index_id" />
</Aggregate>
<Aggregate>
<GroupingFields>
<Field>partition_id</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="partition_id" />
</Aggregate>
<Aggregate>
<GroupingFields>
<Field>kill_lock_option</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="kill_lock_option" />
</Aggregate>
<Aggregate>
<GroupingFields>
<Field>max_duration</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="max_duration" />
</Aggregate>
<Aggregate>
<GroupingFields>
<Field>resumable</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="resumable" />
</Aggregate>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
</GroupingFields>
<Aggregation Function="MAX" Field="index_build_duration_sec" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="create_index_event" Version="1" Category="IndexBuild">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>index_type</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="index_type" />
</Aggregate>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
</GroupingFields>
<Aggregation Function="MAX" Field="index_build_duration_sec" />
</Aggregate>
<Aggregate>
<GroupingFields>
<Field>online</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="online" />
</Aggregate>
<Aggregate>
<GroupingFields>
<Field>max_duration</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="max_duration" />
</Aggregate>
<Aggregate>
<GroupingFields>
<Field>resumable</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="resumable" />
</Aggregate>
<Aggregate>
<GroupingFields>
<Field>is_clustered</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="is_clustered" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="index_build_error_event" Version="1" Category="IndexBuild">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>error_number</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
</GroupingFields>
<Aggregation Function="MAX" Field="index_build_duration_sec" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="alter_column_event" Version="1" Category="IndexBuild">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>online</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
</GroupingFields>
<Aggregation Function="MAX" Field="index_build_duration_sec" />
</Aggregate>
</Aggregates>
</XEvent>
<!-- Index Build Telemetry End -->
<XEvent Package="sqlserver" Name="cardinality_estimation_version_usage" Version="1" Category="Optimization">
<Aggregates>
<Aggregate>
<GroupingFields />
<Aggregation Function="SUM" Field="default_ce_count" />
</Aggregate>
<Aggregate>
<GroupingFields />
<Aggregation Function="SUM" Field="legacy_ce_from_queryhint_count" />
</Aggregate>
<Aggregate>
<GroupingFields />
<Aggregation Function="SUM" Field="default_ce_from_queryhint_count" />
</Aggregate>
<Aggregate>
<GroupingFields />
<Aggregation Function="SUM" Field="conflict_in_ce_request_count" />
</Aggregate>
<Aggregate>
<GroupingFields />
<Aggregation Function="SUM" Field="legacy_ce_from_dbscopedconfig_count" />
</Aggregate>
<Aggregate>
<GroupingFields />
<Aggregation Function="SUM" Field="legacy_ce_from_global_tf_count" />
</Aggregate>
<Aggregate>
<GroupingFields />
<Aggregation Function="SUM" Field="legacy_ce_from_session_tf_count" />
</Aggregate>
<Aggregate>
<GroupingFields />
<Aggregation Function="SUM" Field="ce_atleast120_from_global_tf_count" />
</Aggregate>
<Aggregate>
<GroupingFields />
<Aggregation Function="SUM" Field="ce_atleast120_from_session_tf_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="query_optimizer_compatibility_level_hint_usage" Version="1" Category="Optimization">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>compat_level_hint_value</Field>
<Field>current_db_compat_level</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="query_tsql_scalar_udf_inlined" Version="1" Category="SQL Engine Performance">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="tsql_scalar_udf_not_inlineable" Version="1" Category="SQL Engine Performance">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
<Field>stmt_type</Field>
<Field>blocked_reason</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="not_required_for_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="recovery_checkpoint_stats" Version="1" Category="SQL Engine Performance">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
<Field>dirty_page_mgr_config</Field>
<Field>target_recovery_time_sec</Field>
</GroupingFields>
<Aggregation Function="MAX" Field="dplist_lock_backoffs_per_min" />
</Aggregate>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
<Field>dirty_page_mgr_config</Field>
<Field>target_recovery_time_sec</Field>
</GroupingFields>
<Aggregation Function="MAX" Field="dplist_lock_collisions_per_min" />
</Aggregate>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
<Field>dirty_page_mgr_config</Field>
<Field>target_recovery_time_sec</Field>
</GroupingFields>
<Aggregation Function="MAX" Field="dplist_lock_spins_per_collision" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="multistep_execution" Version="1" Category="SQL Engine Performance">
<Action>database_id</Action>
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
<Field>step_count</Field>
</GroupingFields>
<Aggregation Function="COUNT" Field="Not required for count."/>
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="fulltext_filter_usage" Version="1" Category="SQL Engine Performance">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
<Field>filter_type</Field>
</GroupingFields>
<Aggregation Function="SUM" Field="filter_count" />
</Aggregate>
</Aggregates>
</XEvent>
<XEvent Package="sqlserver" Name="tx_commit_abort_stats" Version="1" Category="Accelerated Database Recovery">
<Aggregates>
<Aggregate>
<GroupingFields>
<Field>database_id</Field>
<Field>is_adr_enabled</Field>
<Field>current_abort_count</Field>
<Field>persisted_version_store_kb</Field>
</GroupingFields>
<Aggregation Function="MAX" Field="persisted_version_store_kb" />
</Aggregate>
</Aggregates>
</XEvent>
</XEvents>
� <?xml version="1.0" encoding="utf-8"?>
<PeriodicQueries xmlns="http://tempuri.org/PeriodicQueries.xsd">
<PeriodicQuery>
<PropertyName>CloudService</PropertyName>
<SelectQuery>
cloudservice
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Inventory</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>OsInfo</PropertyName>
<SelectQuery>
osinfo
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Inventory</Category>
</PeriodicQuery>
<PeriodicQuery>
<PropertyName>RegistryKeys</PropertyName>
<SelectQuery>
registrykeys
</SelectQuery>
<Frequency>Day</Frequency>
<Category>Inventory</Category>
</PeriodicQuery>
</PeriodicQueries> ����̨xA���@b���Fq
ެ�D�xj� !�eG��z݅O��a�`0�s�k���uhw�+dSdjN�tv ��Ŝ\
C�VJ)���0�?���f��Ş�Ű�}t&N ��=O E-\nT���쀠� �i RSDS�7�AA�v����� F:\dbs\sh\el1q\0415_151203\cmd\1p\obj\x64retail\sql\ntdbms\sqlceip\boxtelemetry.csproj\sqlceip.pdb D ^ P _CorExeMain mscoree.dll �% @ � P � 8 � � h � 8 � � �4 V S _ V E R S I O N _ I N F O �� z z? D V a r F i l e I n f o $ T r a n s l a t i o n � S t r i n g F i l e I n f o � 0 0 0 0 0 4 b 0 � : C o m m e n t s T h i s t o o l c o l l e c t s a n d u p l o a d s t e l e m e t r y f r o m S Q L S e r v e r . L C o m p a n y N a m e M i c r o s o f t C o r p o r a t i o n ` F i l e D e s c r i p t i o n S q l S e r v e r T e l e m e t r y C l i e n t 8 F i l e V e r s i o n 1 5 . 0 . 2 1 7 0 . 1 8 I n t e r n a l N a m e s q l c e i p . e x e d L e g a l C o p y r i g h t M i c r o s o f t . A l l r i g h t s r e s e r v e d . � I L e g a l T r a d e m a r k s M i c r o s o f t S Q L S e r v e r i s a r e g i s t e r e d t r a d e m a r k o f M i c r o s o f t C o r p o r a t i o n . @ O r i g i n a l F i l e n a m e s q l c e i p . e x e J P r o d u c t N a m e M i c r o s o f t S Q L S e r v e r < P r o d u c t V e r s i o n 1 5 . 0 . 2 1 7 0 . 1 : A s s e m b l y V e r s i o n 1 5 . 0 . 0 . 0 H% � <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<assembly xmlns="urn:schemas-microsoft-com:asm.v1" manifestVersion="1.0">
<assemblyIdentity version="1.0.0.0" name="MyApplication.app"/>
<trustInfo xmlns="urn:schemas-microsoft-com:asm.v2">
<security>
<requestedPrivileges xmlns="urn:schemas-microsoft-com:asm.v3">
<requestedExecutionLevel level="asInvoker" uiAccess="false"/>
</requestedPrivileges>
</security>
</trustInfo>
</assembly> p8 (( 0�( *�H��
��(
0�(10
`�He 0\
+�7�N0L0
+�70 ��� 010
`�He �ӧ��K-�~[Q�� ��e+, � �� �IEڠ�
v0��0�ܠ3 �^��Y/�� �0
*�H��
0~1 0 UUS10U
Washington10URedmond1 0 U
Microsoft Corporation1(0&U Microsoft Code Signing PCA 20110
250619182137Z
260617182137Z0t1 0 UUS10U
Washington10URedmond1 0 U
Microsoft Corporation1 0 UMicrosoft Corporation0�"0
*�H��
� 0�
� �JHur��R�۫�{��Hq�SA|Q8��E�k uA�x�Wg ?o0�哸��?��?�>Z��SҦq�e���x�$W$-�^��B�(t��Q$"��>� .]� ��M�2B��Z�YH�uB-��d~��p��O��$� ����, �}�@T'�VC�+JC� ���G�W��R��q�� ��o�*�p���I�g�u�
�Ee5�'� �����vY(�}j���� 5
l��ڞ u|^P��Z�t�^;�N$W
rO ��s0�o0 U %0
+�7L+0 U �&r �-�4iN��1jcNd��0EU >0<�:081 0 U Microsoft Corporation10U
230012+5053590 U #0�Hnd�Pӂ�77"�m��u�0TU M0K0I�G�E�Chttp://www.microsoft.com/pkiops/crl/MicCodSigPCA2011_2011-07-08.crl0a+U0S0Q+0�Ehttp://www.microsoft.com/pkiops/certs/MicCodSigPCA2011_2011-07-08.crt0 U �0 0
*�H��
� (�
v
.,Lv\�ꤴ@
�Y9 �F+%�ڱF^�{rӁ�S���� ���ﷂ; ˆ���#/.
Ĵ�ٰ�������Tb��V��<W~���&E���>�-������ ����r��%��,_�5���4}E�_��ɲ���Aᠹ��~�*��Y� ��쭄!Ot.ލ��3;�𝥷\��|�~�wf\ϒ )B�]�{L����l�'.=NN�����g�� ��|R
�������v�=
kނ���͆�)Yk|���1�Y�a�l�����@]5b�*WVYa$|� *�C &����m�Z Y�֝h[ Q#ȑ��F�鷥�� [�g2��1[�S�
�e[%�� u����e'��t�a�]����*�.�x=9��Ml����D�K�f3�s|����<��I*>}��g�p�qC�����k�l �pvF���S��6'��3,�a�Cd��K�G�]mP����6L��M�L��G� �L�I:���9��OC��8%Y0�z0�b�
a�� 0
*�H��
0��1 0 UUS10U
Washington10URedmond1 0 U
Microsoft Corporation1200U)Microsoft Root Certificate Authority 20110
110708205909Z
260708210909Z0~1 0 UUS10U
Washington10URedmond1 0 U
Microsoft Corporation1(0&U Microsoft Code Signing PCA 20110�"0
*�H��
� 0�
� ��r .��n��M4��X!�B*k�ZP��8I�� �7k�� �8��9�1BӉ
yd�~�`$l��I��h^�ߛS�
,ï٩+�z �זY�`�fv�2R&/�PϳD�]��.u�h��m�:\��F��8d�nd5x��c-�@����
�\y�I)�
��w��=��+Z MV(�zr�:�I^���C���{�{��>��]�O��/Y�;-�3Xŷ>�2ӳ=����8~ҝ�,�NV�!5%�9ndS���#������_��R������!t%_(��'(8%�9J6�|��� #��f�a j�(I�_��%]�!K>RĵW?$��z[/�#�p]QFw�� Ἤ�_����UK�9��#I��D|E��rz�r�$߿F���� Wۃ��MI0�����[���ݰf��{���K�I)�(��}g��bx_�/��W�\�w((��m�(�,�@7O��D�� L�ԥC/t��n�x X,]`��>O3�ڰ�ޞN�F�l���ֈ� ���0��0 +�7 0 U Hnd�Pӂ�77"�m��u�0 +�7
S u b C A0 U �0U �0�0 U #0�r-:1�C�N���1�#�40ZU S0Q0O�M�K�Ihttp://crl.microsoft.com/pki/crl/products/MicRooCerAut2011_2011_03_22.crl0^+R0P0N+0�Bhttp://www.microsoft.com/pki/certs/MicRooCerAut2011_2011_03_22.crt0��U ��0��0�� +�7.0��0?+3http://www.microsoft.com/pkiops/docs/primarycps.htm0@+04 2 L e g a l _ p o l i c y _ s t a t e m e n t . 0
*�H��
� g�Ty.��tg"� ��c��B�}�y ��e_.,>��r�m���?�
�;�G���i�c�"5��]e��}�FPU� �|�K �<B�Rа�k�>.)��=�Ե w�9��d�D=xz#�}��t����&F*��� ��h�h.��*?*kXIc inZ�����F+�;н5�n%��'������(��M= ��� �2���-�[��I9
�
�ƭ�����QEX82q'��'��,: i��Y�hno��t�@�*(>�?Mf ��M�� o}E�v�@*e��]Rb�� c6��������'�ͥ���]cA�[��>w��u �aa������A�(��e/��\�� ֡F�Y� KH�� � )ű��?Ew 5�Ң��zz"�H� ��G#�����k�K���ux��7�yK�ֳ#hu���� ��i;��0�L���umc�=ѝVNO��W"�x2!z�A
�?��̤]����WqVNHE�Bɛv[
�Hk�y���mmj�Rs
zP�1�0�0��0~1 0 UUS10U
Washington10URedmond1 0 U
Microsoft Corporation1(0&U Microsoft Code Signing PCA 20113 �^��Y/�� �0
`�He ���0 *�H��
1
+�70
+�7 10
+�70/ *�H��
1" kb�Ɵ�}�(��oZ/��.�Ycb0V"<�il�M0N
+�7 1@0>� � S Q L S e r v e r 2 0 1 9��http://www.microsoft.com0
*�H��
� �_�2MSю�= 7�&e�p.7���3X��?�Iw�5�Mՙ{��� �� \h@/?>�� ���e���"�Jء�6� L�{�+�uR�>�e���=B�Dkv����3��-�'3%����H�Չmv�j7\%��b��U� ���o�ɸ�Ou HX_�r�&$��S�P ^ �|7�f-���% �*6�Ɖ9IO�6b�~Ei���?m�Lxi�J���t���J�N���+$J���8g ��M�&|�#�W��<���0��
+�71��0�| *�H��
��m0�i10
`�He 0�R *�H��
��A�=0�9
+�Y
010
`�He �=�|#3��p ��7(���
1"�v�Hi�H��20260415223308.415Z0��Ѥ��0��1 0 UUS10U
Washington10URedmond1 0 U
Microsoft Corporation1%0#U Microsoft America Operations1'0%U nShield TSS ESN:7F00-05E0-D9471%0#U Microsoft Time-Stamp Service���0� 0��3 ���n9o|I 0
*�H��
0|1 0 UUS10U
Washington10URedmond1 0 U
Microsoft Corporation1&0$U Microsoft Time-Stamp PCA 20100
260219193949Z
270517193949Z0��1 0 UUS10U
Washington10URedmond1 0 U
Microsoft Corporation1%0#U Microsoft America Operations1'0%U nShield TSS ESN:7F00-05E0-D9471%0#U Microsoft Time-Stamp Service0�"0
*�H��
� 0�
� ��8�l<,G�^�:�^l�8mN�vj\�K�ѹ�d��sy$
CӪ�s�\�~���[ �Z0���!*��'����
aY< �� �0��/��/�L��z�X�(,�X�-tW�=$߯HN�����]�X�H�uR�ne����{�kbEE]����j�ᐗ��oA����Me��i.Y��F��<�[�\Z܋��0��I9�9��S�>��t � � �aċ�l�3�IԪ��+����&�U4�����o���.�5_oW&�?�4�:�k�O� �f�+|!Y����*OBN5ƹ�;xLb=�(�]��b�6�-%�ԑJn�4S����2�����y
�;L�Y�1��R��A�=���.]���f�V�T�]�o]����v�m�]O(%5�uJ��*+P�����������GD�3�5^�R�N�����8���hZj���<9՝����Nv��&sE�_�Ut�d�1��b�(]�sFՉ�S�*�Kw,+3{�+V'�[>�����- ��I0�E0 U �
�� fb\. <���d0 U #0���] ^b]����e�S5�r0_U X0V0T�R�P�Nhttp://www.microsoft.com/pkiops/crl/Microsoft%20Time-Stamp%20PCA%202010(1).crl0l+`0^0\+0�Phttp://www.microsoft.com/pkiops/certs/Microsoft%20Time-Stamp%20PCA%202010(1).crt0 U �0 0U %� 0
+0U ��0
*�H��
� ���y6rU�p)�Ѣy9�ƶLX��2������`�O6�H�|&zS��}�t�o�I35 3
�O��H� ��
Ik�\@,�&Noq쪥CY3ױ�v5�ٕ8 �4k�2�j$��.6)1f�X��b��}+��<([�4}�0?L'-G�(�jTՔK�}n_ G�$��5�S�dw��S8�����n����:-�t���xXZ��4�@�B���u8ۧw�߄�Tpu���~� jC��
��7(}\w��<�B`�PĴ����-� _y� ��>��E-I|��( -�}���x$�`B���ѣq�q���x�+*�:�p��mG������,����(:WFD�O0}
�Y$��^Ԋ>���I���5u1Z�y��)nw�
���d'�:2��7|(�|B>�%��N#����Yơ�\_���͑8�ߘ�vw�/�}E*^� �@ʋj%!f����q� �j�W�Uv�b[4��,�C�i\��k��M�����Z�0���!��6��0�q0�Y�3 ��k��I� 0
*�H��
0��1 0 UUS10U
Washington10URedmond1 0 U
Microsoft Corporation1200U)Microsoft Root Certificate Authority 20100
210930182225Z
300930183225Z0|1 0 UUS10U
Washington10URedmond1 0 U
Microsoft Corporation1&0$U Microsoft Time-Stamp PCA 20100�"0
*�H��
� 0�
� ��L�r! y���$y�Ղ��ҩlNu��5W�lJ�⽹>`3�\O�f��SqZ�~JZ��6g�F# ���w2��`}jR�D���Fk��v��P�D�q\Q17�
8n����&S|9azĪ�ri� ���6�5&dژ;�{3��[~� �R���b%�j�]�S���VM�ݼ��㑏�9,Q��pi
�6-p�1�5(�㴇$��ɏ~�T��U�mh;�F��z)7���E�Fn�2��0\O,�b�⍈䖬J��q�[g`��� =� �s}A�Fu��_4���� }~�ٞE߶r/�}_��۪~6�6L�+n�Q���s�M7t� 4���G��|?Lۯ^����s=CN�39L��Bh.�QF�ѽjZas�g�^�(v�3rק ��
�co �6d�[���!]_0t���عP� �a�65�G����� �k�\RQ]�%��Pzl� r�Rą��<�7�?x�E�� �^ڏ�riƮ{��>j�.� ���0��0 +�7 0# +�7*�R�dĚ���<F5)��/�0 U ��] ^b]����e�S5�r0\U U0S0Q +�7L�}0A0?+3http://www.microsoft.com/pkiops/Docs/Repository.htm0U % 0
+0 +�7
S u b C A0 U �0U �0�0 U #0��Vˏ�\bh�=��[�Κ�0VU O0M0K�I�G�Ehttp://crl.microsoft.com/pki/crl/products/MicRooCerAut_2010-06-23.crl0Z+N0L0J+0�>http://www.microsoft.com/pki/certs/MicRooCerAut_2010-06-23.crt0
*�H��
� �U}�*��, g1$[�rK��o�\�>NGdx���=13�9��q6?�dl|�u9m�1��lѡ�"��fg:SMݘ�� x�6.���V ����i� �{�jo�)�n�?Hu��m� �m#T�xSu$W�ݟ�=��h�e��V����(U'�$�@���]='�@�8���)�ü�T�B�� ����� j�BRu�6� �as.,k{n?, x鑲�[�I�t �쑀�=�J>f;O���2ٖ����t��Lro�u0�4�z�P�
X�@<�Tm�ctH,�NG-�q�d�$�smʎ ��WITd�s� [D�Z�k
��(�g($�8K�n�!TkjEG����^O���Lv�WT �iD~|�als�
��Af=i��AI~~���;����>�1Q������{ ��p���(� �6ںL���
�4�$5g+�
�挙��"��'B=%��tt[jў>�~�13}���{�8pDѐ�ȫ:�:b�pcSM��m��qj� U3X��pf�M0�50����Ѥ��0��1 0 UUS10U
Washington10URedmond1 0 U
Microsoft Corporation1%0#U Microsoft America Operations1'0%U nShield TSS ESN:7F00-05E0-D9471%0#U Microsoft Time-Stamp Service�#
0+ ��d(2�R�=�j�� ����0���~0|1 0 UUS10U
Washington10URedmond1 0 U
Microsoft Corporation1&0$U Microsoft Time-Stamp PCA 20100
*�H��
��0"20260415212133Z20260416212133Z0t0:
+�Y
1,0*0
�� 0 =0 l0
��] 06
+�Y
1(0&0
+�Y
�
0 � �
0 ��0
*�H��
� ��ۅ��R ����nb�_i�e�u ȡ������߁�
[
/w�P�/�H�Q�z/�6-U�9K��.玅$4 o�
[A6�M&
{K�z o���ٛ��7�A��#�<@�Q���%�Ľ-'@-�V�&N;�BI�������Ͼ8$Eo�a�H��
�� �a��'*=U��P���~xT��2�u6;U�CF/IA���%�c�g������y��#j���體'X�M��Д�8��PM��� �.�lk_�M�1�
0� 0��0|1 0 UUS10U
Washington10URedmond1 0 U
Microsoft Corporation1&0$U Microsoft Time-Stamp PCA 20103 ���n9o|I 0
`�He ��J0 *�H��
1
*�H��
0/ *�H��
1" [z��H D���ٚ�c_�B Q��C6Cbww��0�� *�H��
/1��0��0��0�� /�]j�������u����2#
��0��0���~0|1 0 UUS10U
Washington10URedmond1 0 U
Microsoft Corporation1&0$U Microsoft Time-Stamp PCA 20103 ���n9o|I 0" :��H4���Z0�2�ɮ1ޘW}�ݕI��16]#�0
*�H��
� C]�X�ut�ϳ���x��/쌭J+ ����V��9�]O)%� ��
q]KL]�uK]�)PŹ��{?7��Z����ule� u��U� �d�$ۉ6�'���]�Id')���
!C���#S��4&~Ρ�C�Kdy�|v�ė � ����i�W�Ï,���}wM2�����${7��D8� E��$x��W�F&��O.��%N��U�eKh�⾵I .j����S]�e�~��s9����� 0&�
�e�35o\J�~.JV��B�Iؖ:�^�5D�2��Jkf�;/��>��xv�}����exv�Yڍ5WY��34/�E�fb��,ϕͼ�V�3�Y�GQۓo�^�r� � ��)�Ѹ�� kQK�rJ�Z8 ��pŵ߰�Rϱ!���/o�t �����'y��|`��(M� x�F|/���`�]9�%:�ɵ��qU�#��"�'�r����ڴ��Y~�� \e�u� �W#a~�B���=G��r~���,d��]�s�ǂ�Z ��yG