<?xml version="1.0" encoding="utf-16"?>
<ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.2" Build="11.0.2218.0" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
<BatchSequence>
<Batch>
<Statements>
<StmtSimple StatementCompId="1" StatementEstRows="48696.8" StatementId="1" StatementOptmLevel="FULL" StatementSubTreeCost="1856810" StatementText="SELECT CAST (
 REPLACE (
 REPLACE (
 XEventData.XEvent.value ('(data/value)[1]', 'varchar(max)'),
 '<victim-list>', '<deadlock><victim-list>'),
 '<process-list>', '</victim-list><process-list>')
 AS XML) AS DeadlockGraph
FROM (SELECT CAST (target_data AS XML) AS TargetData
 FROM sys.dm_xe_session_targets st
 JOIN sys.dm_xe_sessions s ON s.address = st.event_session_address
 WHERE [name] = 'system_health') AS Data
CROSS APPLY TargetData.nodes ('//RingBufferTarget/event') AS XEventData (XEvent)
 WHERE XEventData.XEvent.value('@name', 'varchar(4000)') = 'xml_deadlock_report'
 OPTION (MAXDOP 1)" StatementType="SELECT" QueryHash="0x6C275B66E279A54B" QueryPlanHash="0x4D6C2A561737722C">
<StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
<QueryPlan DegreeOfParallelism="0" MemoryGrant="1328" CachedPlanSize="112" CompileTime="6" CompileCPU="6" CompileMemory="1336">
<RelOp AvgRowSize="4035" EstimateCPU="0.00486968" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="48696.8" LogicalOp="Compute Scalar" NodeId="0" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="1856810">
<OutputList>
<ColumnReference Column="Expr1023" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1023" />
<ScalarOperator ScalarString="CONVERT(xml,replace(replace([Expr1022],'<victim-list>',CONVERT_IMPLICIT(varchar(max),'<deadlock><victim-list>',0)),'<process-list>',CONVERT_IMPLICIT(varchar(max),'</victim-list><process-list>',0)),0)">
<Convert DataType="xml" Style="0" Implicit="false">
<ScalarOperator>
<Intrinsic FunctionName="replace">
<ScalarOperator>
<Intrinsic FunctionName="replace">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1022" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'<victim-list>'" />
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Column="ConstExpr1025">
<ScalarOperator>
<Convert DataType="varchar(max)" Length="2147483647" Style="0" Implicit="true">
<ScalarOperator>
<Const ConstValue="'<deadlock><victim-list>'" />
</ScalarOperator>
</Convert>
</ScalarOperator>
</ColumnReference>
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'<process-list>'" />
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Column="ConstExpr1024">
<ScalarOperator>
<Convert DataType="varchar(max)" Length="2147483647" Style="0" Implicit="true">
<ScalarOperator>
<Const ConstValue="'</victim-list><process-list>'" />
</ScalarOperator>
</Convert>
</ScalarOperator>
</ColumnReference>
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="4035" EstimateCPU="0.203552" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="48696.8" LogicalOp="Inner Join" NodeId="1" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="1856810">
<OutputList>
<ColumnReference Column="Expr1022" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<NestedLoops Optimized="false">
<OuterReferences>
<ColumnReference Column="Expr1000" />
<ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
</OuterReferences>
<RelOp AvgRowSize="4093" EstimateCPU="0.853574" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="48696.8" LogicalOp="Filter" NodeId="2" Parallel="false" PhysicalOp="Filter" EstimatedTotalSubtreeCost="1796820">
<OutputList>
<ColumnReference Column="Expr1000" />
<ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Filter StartupExpression="false">
<RelOp AvgRowSize="6095" EstimateCPU="7.43321" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1778280" LogicalOp="Inner Join" NodeId="3" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="1796820">
<OutputList>
<ColumnReference Column="Expr1000" />
<ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
<ColumnReference Column="Expr1008" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="3782" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<NestedLoops Optimized="false">
<OuterReferences>
<ColumnReference Column="Expr1000" />
<ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
</OuterReferences>
<RelOp AvgRowSize="4093" EstimateCPU="7.43321" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1778280" LogicalOp="Inner Join" NodeId="4" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="17863.1">
<OutputList>
<ColumnReference Column="Expr1000" />
<ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="3782" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<NestedLoops Optimized="false">
<OuterReferences>
<ColumnReference Column="Expr1000" />
</OuterReferences>
<RelOp AvgRowSize="4085" EstimateCPU="0.0504178" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="17782.8" LogicalOp="Inner Join" NodeId="5" Parallel="false" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="0.0516989">
<OutputList>
<ColumnReference Column="Expr1000" />
</OutputList>
<MemoryFractions Input="1" Output="1" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="2" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Hash>
<DefinedValues />
<HashKeysBuild>
<ColumnReference Table="[DM_XE_SESSIONS]" Column="address" />
</HashKeysBuild>
<HashKeysProbe>
<ColumnReference Table="[DM_XE_SESSION_TARGETS]" Column="event_session_address" />
</HashKeysProbe>
<ProbeResidual>
<ScalarOperator ScalarString="DM_XE_SESSION_TARGETS.[event_session_address]=DM_XE_SESSIONS.[address]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Table="[DM_XE_SESSION_TARGETS]" Column="event_session_address" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Table="[DM_XE_SESSIONS]" Column="address" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</ProbeResidual>
<RelOp AvgRowSize="15" EstimateCPU="0.000177985" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="177.828" LogicalOp="Table-valued function" NodeId="6" Parallel="false" PhysicalOp="Table-valued function" EstimatedTotalSubtreeCost="0.000177985">
<OutputList>
<ColumnReference Table="[DM_XE_SESSIONS]" Column="address" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<TableValuedFunction>
<DefinedValues>
<DefinedValue>
<ColumnReference Table="[DM_XE_SESSIONS]" Column="address" />
</DefinedValue>
</DefinedValues>
<Object Table="[DM_XE_SESSIONS]" />
<ParameterList>
<ScalarOperator ScalarString="(0)">
<Const ConstValue="(0)" />
</ScalarOperator>
<ScalarOperator ScalarString="NULL">
<Const ConstValue="NULL" />
</ScalarOperator>
<ScalarOperator ScalarString="(1)">
<Const ConstValue="(1)" />
</ScalarOperator>
<ScalarOperator ScalarString="N'system_health'">
<Const ConstValue="N'system_health'" />
</ScalarOperator>
</ParameterList>
</TableValuedFunction>
</RelOp>
<RelOp AvgRowSize="4091" EstimateCPU="0.0001" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1000" LogicalOp="Compute Scalar" NodeId="11" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.00110016">
<OutputList>
<ColumnReference Table="[DM_XE_SESSION_TARGETS]" Column="event_session_address" />
<ColumnReference Column="Expr1000" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1000" />
<ScalarOperator ScalarString="CONVERT(xml,DM_XE_SESSION_TARGETS.[target_data],0)">
<Convert DataType="xml" Style="0" Implicit="false">
<ScalarOperator>
<Identifier>
<ColumnReference Table="[DM_XE_SESSION_TARGETS]" Column="target_data" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="4091" EstimateCPU="0.00100016" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1000" LogicalOp="Table-valued function" NodeId="12" Parallel="false" PhysicalOp="Table-valued function" EstimatedTotalSubtreeCost="0.00100016">
<OutputList>
<ColumnReference Table="[DM_XE_SESSION_TARGETS]" Column="event_session_address" />
<ColumnReference Table="[DM_XE_SESSION_TARGETS]" Column="target_data" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="0" ActualRows="3" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<TableValuedFunction>
<DefinedValues>
<DefinedValue>
<ColumnReference Table="[DM_XE_SESSION_TARGETS]" Column="event_session_address" />
</DefinedValue>
<DefinedValue>
<ColumnReference Table="[DM_XE_SESSION_TARGETS]" Column="target_data" />
</DefinedValue>
</DefinedValues>
<Object Table="[DM_XE_SESSION_TARGETS]" />
<ParameterList>
<ScalarOperator ScalarString="(0)">
<Const ConstValue="(0)" />
</ScalarOperator>
<ScalarOperator ScalarString="NULL">
<Const ConstValue="NULL" />
</ScalarOperator>
</ParameterList>
</TableValuedFunction>
</RelOp>
</ComputeScalar>
</RelOp>
</Hash>
</RelOp>
<RelOp AvgRowSize="17" EstimateCPU="9.6E-05" EstimateIO="0" EstimateRebinds="17649.4" EstimateRewinds="132.352" EstimateRows="100" LogicalOp="Filter" NodeId="19" Parallel="false" PhysicalOp="Filter" EstimatedTotalSubtreeCost="17855.6">
<OutputList>
<ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRebinds="2" ActualRewinds="0" ActualRows="3782" ActualEndOfScans="2" ActualExecutions="2" />
</RunTimeInformation>
<Filter StartupExpression="true">
<RelOp AvgRowSize="17" EstimateCPU="1.004" EstimateIO="0" EstimateRebinds="17649.4" EstimateRewinds="132.352" EstimateRows="200" LogicalOp="Table-valued function" NodeId="20" Parallel="false" PhysicalOp="Table-valued function" EstimatedTotalSubtreeCost="17853.9">
<OutputList>
<ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRebinds="2" ActualRewinds="0" ActualRows="3782" ActualEndOfScans="2" ActualExecutions="2" />
</RunTimeInformation>
<TableValuedFunction>
<DefinedValues>
<DefinedValue>
<ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
</DefinedValue>
</DefinedValues>
<Object Table="[XML Reader with XPath filter]" />
<ParameterList>
<ScalarOperator ScalarString="[Expr1000]">
<Identifier>
<ColumnReference Column="Expr1000" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="(0)">
<Const ConstValue="(0)" />
</ScalarOperator>
<ScalarOperator ScalarString="NULL">
<Const ConstValue="NULL" />
</ScalarOperator>
<ScalarOperator ScalarString="NULL">
<Const ConstValue="NULL" />
</ScalarOperator>
</ParameterList>
</TableValuedFunction>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="[Expr1000] IS NOT NULL">
<Compare CompareOp="IS NOT">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1000" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="2011" EstimateCPU="3.37188E-06" EstimateIO="0" EstimateRebinds="1776950" EstimateRewinds="1332.52" EstimateRows="1" LogicalOp="Aggregate" NodeId="26" Parallel="false" PhysicalOp="Stream Aggregate" EstimatedTotalSubtreeCost="1778950">
<OutputList>
<ColumnReference Column="Expr1008" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="3782" ActualEndOfScans="0" ActualExecutions="3782" />
</RunTimeInformation>
<StreamAggregate>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1008" />
<ScalarOperator ScalarString="MIN(CASE WHEN [Expr1000] IS NULL THEN NULL ELSE CASE WHEN datalength(XML Reader with XPath filter.[value])>=(128) THEN CONVERT_IMPLICIT(varchar(4000),XML Reader with XPath filter.[lvalue],0) ELSE CONVERT_IMPLICIT(varchar(4000),XML Reader with XPath filter.[value],0) END END)">
<Aggregate AggType="MIN" Distinct="false">
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="IS">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1000" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="GE">
<ScalarOperator>
<Intrinsic FunctionName="datalength">
<ScalarOperator>
<Identifier>
<ColumnReference Table="[XML Reader with XPath filter]" Column="value" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(128)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Convert DataType="varchar" Length="4000" Style="0" Implicit="true">
<ScalarOperator>
<Identifier>
<ColumnReference Table="[XML Reader with XPath filter]" Column="lvalue" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Convert DataType="varchar" Length="4000" Style="0" Implicit="true">
<ScalarOperator>
<Identifier>
<ColumnReference Table="[XML Reader with XPath filter]" Column="value" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Aggregate>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="4057" EstimateCPU="1.224E-05" EstimateIO="0" EstimateRebinds="1776950" EstimateRewinds="1332.52" EstimateRows="4.78647" LogicalOp="Filter" NodeId="27" Parallel="false" PhysicalOp="Filter" EstimatedTotalSubtreeCost="1778940">
<OutputList>
<ColumnReference Table="[XML Reader with XPath filter]" Column="value" />
<ColumnReference Table="[XML Reader with XPath filter]" Column="lvalue" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="3782" ActualEndOfScans="3782" ActualExecutions="3782" />
</RunTimeInformation>
<Filter StartupExpression="false">
<RelOp AvgRowSize="4065" EstimateCPU="1.00036" EstimateIO="0" EstimateRebinds="1776950" EstimateRewinds="1332.52" EstimateRows="18" LogicalOp="Table-valued function" NodeId="28" Parallel="false" PhysicalOp="Table-valued function" EstimatedTotalSubtreeCost="1778920">
<OutputList>
<ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
<ColumnReference Table="[XML Reader with XPath filter]" Column="value" />
<ColumnReference Table="[XML Reader with XPath filter]" Column="lvalue" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRebinds="3782" ActualRewinds="0" ActualRows="3782" ActualEndOfScans="3782" ActualExecutions="3782" />
</RunTimeInformation>
<TableValuedFunction>
<DefinedValues>
<DefinedValue>
<ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
</DefinedValue>
<DefinedValue>
<ColumnReference Table="[XML Reader with XPath filter]" Column="value" />
</DefinedValue>
<DefinedValue>
<ColumnReference Table="[XML Reader with XPath filter]" Column="lvalue" />
</DefinedValue>
</DefinedValues>
<Object Table="[XML Reader with XPath filter]" />
<ParameterList>
<ScalarOperator ScalarString="[Expr1000]">
<Identifier>
<ColumnReference Column="Expr1000" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="(7)">
<Const ConstValue="(7)" />
</ScalarOperator>
<ScalarOperator ScalarString="XML Reader with XPath filter.[id]">
<Identifier>
<ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="getdescendantlimit(XML Reader with XPath filter.[id])">
<Intrinsic FunctionName="getdescendantlimit">
<ScalarOperator>
<Identifier>
<ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</ParameterList>
</TableValuedFunction>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="XML Reader with XPath filter.[id]=getancestor(XML Reader with XPath filter.[id],(1))">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Intrinsic FunctionName="getancestor">
<ScalarOperator>
<Identifier>
<ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
</StreamAggregate>
</RelOp>
</NestedLoops>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="[Expr1008]='xml_deadlock_report'">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1008" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'xml_deadlock_report'" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
<RelOp AvgRowSize="4035" EstimateCPU="0.0004325" EstimateIO="0" EstimateRebinds="48476.1" EstimateRewinds="219.673" EstimateRows="1" LogicalOp="Aggregate" NodeId="38" Parallel="false" PhysicalOp="Stream Aggregate" EstimatedTotalSubtreeCost="59990.3">
<OutputList>
<ColumnReference Column="Expr1022" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="0" ActualExecutions="1" />
</RunTimeInformation>
<StreamAggregate>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1022" />
<ScalarOperator ScalarString="MIN(CASE WHEN [Expr1000] IS NULL THEN NULL ELSE CASE WHEN datalength([Expr1019])>=(128) THEN CONVERT_IMPLICIT(varchar(max),[Expr1020],0) ELSE CONVERT_IMPLICIT(varchar(max),[Expr1019],0) END END)">
<Aggregate AggType="MIN" Distinct="false">
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="IS">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1000" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="GE">
<ScalarOperator>
<Intrinsic FunctionName="datalength">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1019" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(128)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Convert DataType="varchar(max)" Length="2147483647" Style="0" Implicit="true">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1020" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Convert DataType="varchar(max)" Length="2147483647" Style="0" Implicit="true">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1019" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Aggregate>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="8045" EstimateCPU="0.00072" EstimateIO="0" EstimateRebinds="48476.1" EstimateRewinds="219.673" EstimateRows="720" LogicalOp="UDX" NodeId="39" Parallel="false" PhysicalOp="UDX" EstimatedTotalSubtreeCost="59969.2">
<OutputList>
<ColumnReference Column="Expr1019" />
<ColumnReference Column="Expr1020" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Extension UDXName="XQUERY DATA">
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1017" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1018" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1019" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1020" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1021" />
</DefinedValue>
</DefinedValues>
<UsedUDXColumns>
<ColumnReference Table="[XML Reader]" Column="id" />
<ColumnReference Table="[XML Reader]" Column="nid" />
<ColumnReference Table="[XML Reader]" Column="tid" />
<ColumnReference Table="[XML Reader]" Column="value" />
<ColumnReference Table="[XML Reader]" Column="lvalue" />
<ColumnReference Table="[XML Reader]" Column="lvaluebin" />
<ColumnReference Column="Expr1013" />
<ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
<ColumnReference Table="[XML Reader]" Column="id" />
</UsedUDXColumns>
<RelOp AvgRowSize="8559" EstimateCPU="0.003762" EstimateIO="0" EstimateRebinds="48476.1" EstimateRewinds="219.673" EstimateRows="900" LogicalOp="Inner Join" NodeId="40" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="59934.1">
<OutputList>
<ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
<ColumnReference Column="Expr1013" />
<ColumnReference Table="[XML Reader]" Column="id" />
<ColumnReference Table="[XML Reader]" Column="nid" />
<ColumnReference Table="[XML Reader]" Column="tid" />
<ColumnReference Table="[XML Reader]" Column="value" />
<ColumnReference Table="[XML Reader]" Column="lvalue" />
<ColumnReference Table="[XML Reader]" Column="lvaluebin" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="124" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<NestedLoops Optimized="false">
<OuterReferences>
<ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
<ColumnReference Column="Expr1027" />
</OuterReferences>
<RelOp AvgRowSize="921" EstimateCPU="1E-07" EstimateIO="0" EstimateRebinds="48476.1" EstimateRewinds="219.673" EstimateRows="1" LogicalOp="Top" NodeId="41" Parallel="false" PhysicalOp="Top" EstimatedTotalSubtreeCost="10177.7">
<OutputList>
<ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
<ColumnReference Column="Expr1013" />
<ColumnReference Column="Expr1027" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Top RowCount="false" IsPercent="false" WithTies="false">
<TopExpression>
<ScalarOperator ScalarString="(1)">
<Const ConstValue="(1)" />
</ScalarOperator>
</TopExpression>
<RelOp AvgRowSize="921" EstimateCPU="4.78647E-07" EstimateIO="0" EstimateRebinds="48476.1" EstimateRewinds="219.673" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="42" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="10177.7">
<OutputList>
<ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
<ColumnReference Column="Expr1013" />
<ColumnReference Column="Expr1027" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1013" />
<ScalarOperator ScalarString="0x58">
<Const ConstValue="0x58" />
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="469" EstimateCPU="1.224E-05" EstimateIO="0" EstimateRebinds="48476.1" EstimateRewinds="219.673" EstimateRows="1" LogicalOp="Filter" NodeId="43" Parallel="false" PhysicalOp="Filter" EstimatedTotalSubtreeCost="10177.6">
<OutputList>
<ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
<ColumnReference Column="Expr1027" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="0" ActualExecutions="1" />
</RunTimeInformation>
<Filter StartupExpression="false">
<RelOp AvgRowSize="469" EstimateCPU="1.8E-06" EstimateIO="0" EstimateRebinds="48476.1" EstimateRewinds="219.673" EstimateRows="3.7606" LogicalOp="Compute Scalar" NodeId="44" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="10177.5">
<OutputList>
<ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
<ColumnReference Column="Expr1027" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1027" />
<ScalarOperator ScalarString="getdescendantlimit(XML Reader with XPath filter.[id])">
<Intrinsic FunctionName="getdescendantlimit">
<ScalarOperator>
<Identifier>
<ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="17" EstimateCPU="1.00036" EstimateIO="0" EstimateRebinds="48476.1" EstimateRewinds="219.673" EstimateRows="3.7606" LogicalOp="Table-valued function" NodeId="45" Parallel="false" PhysicalOp="Table-valued function" EstimatedTotalSubtreeCost="10177.5">
<OutputList>
<ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="0" ActualRows="1" ActualEndOfScans="0" ActualExecutions="1" />
</RunTimeInformation>
<TableValuedFunction>
<DefinedValues>
<DefinedValue>
<ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
</DefinedValue>
</DefinedValues>
<Object Table="[XML Reader with XPath filter]" />
<ParameterList>
<ScalarOperator ScalarString="[Expr1000]">
<Identifier>
<ColumnReference Column="Expr1000" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="(7)">
<Const ConstValue="(7)" />
</ScalarOperator>
<ScalarOperator ScalarString="XML Reader with XPath filter.[id]">
<Identifier>
<ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="getdescendantlimit(XML Reader with XPath filter.[id])">
<Intrinsic FunctionName="getdescendantlimit">
<ScalarOperator>
<Identifier>
<ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</ParameterList>
</TableValuedFunction>
</RelOp>
</ComputeScalar>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="XML Reader with XPath filter.[id]=getancestor(XML Reader with XPath filter.[id],(2))">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Intrinsic FunctionName="getancestor">
<ScalarOperator>
<Identifier>
<ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(2)" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
</ComputeScalar>
</RelOp>
</Top>
</RelOp>
<RelOp AvgRowSize="8099" EstimateCPU="1.018" EstimateIO="0" EstimateRebinds="48476.1" EstimateRewinds="219.673" EstimateRows="900" LogicalOp="Table-valued function" NodeId="58" Parallel="false" PhysicalOp="Table-valued function" EstimatedTotalSubtreeCost="49573.3">
<OutputList>
<ColumnReference Table="[XML Reader]" Column="id" />
<ColumnReference Table="[XML Reader]" Column="nid" />
<ColumnReference Table="[XML Reader]" Column="tid" />
<ColumnReference Table="[XML Reader]" Column="value" />
<ColumnReference Table="[XML Reader]" Column="lvalue" />
<ColumnReference Table="[XML Reader]" Column="lvaluebin" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="0" ActualRows="124" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<TableValuedFunction>
<DefinedValues>
<DefinedValue>
<ColumnReference Table="[XML Reader]" Column="id" />
</DefinedValue>
<DefinedValue>
<ColumnReference Table="[XML Reader]" Column="nid" />
</DefinedValue>
<DefinedValue>
<ColumnReference Table="[XML Reader]" Column="tid" />
</DefinedValue>
<DefinedValue>
<ColumnReference Table="[XML Reader]" Column="value" />
</DefinedValue>
<DefinedValue>
<ColumnReference Table="[XML Reader]" Column="lvalue" />
</DefinedValue>
<DefinedValue>
<ColumnReference Table="[XML Reader]" Column="lvaluebin" />
</DefinedValue>
</DefinedValues>
<Object Table="[XML Reader]" />
<ParameterList>
<ScalarOperator ScalarString="[Expr1000]">
<Identifier>
<ColumnReference Column="Expr1000" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="(7)">
<Const ConstValue="(7)" />
</ScalarOperator>
<ScalarOperator ScalarString="XML Reader with XPath filter.[id]">
<Identifier>
<ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="[Expr1027]">
<Identifier>
<ColumnReference Column="Expr1027" />
</Identifier>
</ScalarOperator>
</ParameterList>
</TableValuedFunction>
</RelOp>
</NestedLoops>
</RelOp>
</Extension>
</RelOp>
</StreamAggregate>
</RelOp>
</NestedLoops>
</RelOp>
</ComputeScalar>
</RelOp>
</QueryPlan>
</StmtSimple>
</Statements>
</Batch>
</BatchSequence>
</ShowPlanXML>