Skip to content

Instantly share code, notes, and snippets.

@swasheck

swasheck/event_data.xml

Created August 4, 2014 20:35
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save swasheck/4d08362f72c38a23e96e to your computer and use it in GitHub Desktop.
Save swasheck/4d08362f72c38a23e96e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
event_data.xml
<event name="query_post_execution_showplan" package="sqlserver" timestamp="2014-07-30T16:14:17.237Z">
<data name="source_database_id">
<value>2</value>
</data>
<data name="object_type">
<value>20801</value>
<text>ADHOC</text>
</data>
<data name="object_id">
<value>13245692</value>
</data>
<data name="nest_level">
<value>5</value>
</data>
<data name="cpu_time">
<value>0</value>
</data>
<data name="duration">
<value>0</value>
</data>
<data name="estimated_rows">
<value>1</value>
</data>
<data name="estimated_cost">
<value>0</value>
</data>
<data name="object_name">
<value>Dynamic SQL</value>
</data>
<data name="showplan_xml">
<value>
<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.2" Build="12.0.2000.8">
<BatchSequence>
<Batch>
<Statements>
<StmtSimple StatementSubTreeCost="0.0146455" StatementEstRows="1" StatementOptmLevel="TRIVIAL" QueryHash="0xAB75F47A1816E3AA" QueryPlanHash="0x16178AB2BE2DBCFD" CardinalityEstimationModelVersion="120">
<QueryPlan DegreeOfParallelism="1" MemoryGrant="1024" CachedPlanSize="16" CompileTime="1" CompileCPU="1" CompileMemory="104">
<MemoryGrantInfo SerialRequiredMemory="512" SerialDesiredMemory="544" RequiredMemory="512" DesiredMemory="544" RequestedMemory="1024" GrantWaitTime="0" GrantedMemory="1024" MaxUsedMemory="0" />
<OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="671078" EstimatedPagesCached="167769" EstimatedAvailableDegreeOfParallelism="2" />
<RelOp NodeId="0" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="1.1e-006" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0146455" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Column="Expr1003" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<StreamAggregate>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1003" />
<ScalarOperator ScalarString="STATMAN([tempdb].[dbo].[#temp_jobschedule___________________________________________________________________________________________________000000000015].[schedule_id])">
<Aggregate Distinct="0" AggType="STATMAN">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp_jobschedule___________________________________________________________________________________________________000000000015]" Column="schedule_id" />
</Identifier>
</ScalarOperator>
</Aggregate>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp NodeId="1" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="1" EstimateIO="0.0112613" EstimateCPU="0.000100011" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0146444" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp_jobschedule___________________________________________________________________________________________________000000000015]" Column="schedule_id" />
</OutputList>
<MemoryFractions Input="1" Output="1" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="1" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Sort Distinct="0">
<OrderBy>
<OrderByColumn Ascending="1">
<ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp_jobschedule___________________________________________________________________________________________________000000000015]" Column="schedule_id" />
</OrderByColumn>
</OrderBy>
<RelOp NodeId="2" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="1" EstimateIO="0.0032035" EstimateCPU="7.96e-005" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="1" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp_jobschedule___________________________________________________________________________________________________000000000015]" Column="schedule_id" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<TableScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp_jobschedule___________________________________________________________________________________________________000000000015]" Column="schedule_id" />
</DefinedValue>
</DefinedValues>
<Object Database="[tempdb]" Schema="[dbo]" Table="[#temp_jobschedule___________________________________________________________________________________________________000000000015]" IndexKind="Heap" Storage="RowStore" />
</TableScan>
</RelOp>
</Sort>
</RelOp>
</StreamAggregate>
</RelOp>
</QueryPlan>
</StmtSimple>
</Statements>
</Batch>
</BatchSequence>
</ShowPlanXML>
</value>
</data>
<data name="database_name">
<value />
</data>
</event>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment