Hello,
i'm running 7 same HW&SW configured servers with the same load with SQL Ex 2005 SP1 installed. I'm executing SP over 200.000 times a day. And here comes the problem, every server got different average response time, the quickest executes the SP in 1 ms, the slowlest in 50 ms, that's 50x slower!
Have you any performance hint, please Thank you.
Performance difference
haryindsfjdbf
Are they containing the same data
You can check the execution plan and compare where the extra time is spent.
zensunni
YES! This is it. Thank you Jerome for your perfect help.
It's interesting that execution plan in xml differs only in ParameterCompiledValue on fast system there's (0) on slow one there's (1). Do you have any idea what it is, please
Even more interesting is difference in average reads, cpu and duration. My stored procedure consists of 3 commands: (fast system/slow system)
select reads: 2/2
select cpu: 45/59
select duration: 46/59
insert reads: 4/4
insert cpu: 240/78
insert duration: 257/122
update reads: 2/2
update cpu: 49/52
update duration: 55/118
update reads: 2/2
update cpu: 39/49
update duration: 40/150
I see that there's no difference between reads, BUT! on fast system is duration only slightly longer (eg cpu:45 dur: 46)than CPU, on slow system there're big differences (eg cpu: 78 dur: 122) am i right
What does this mean, please
Ganeshkumar S
Sure, here we go...
Both systems are: MS Windows Server 2003, 1 GB RAM, dual XEONs 3 GHz, HDD Raid 5
Fast system:
<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.0" Build="9.00.2047.00">
<BatchSequence>
<Batch>
<Statements>
<StmtSimple StatementText="
CREATE PROCEDURE Ulo _Snimek
	-- definice vstupnich parametr 
	@ID int,
	@TIMESTAMPMARK datetime,
	@DBTIME datetime,
	@EXCHANGEID int,
	@RECPCM smallint,
	@DURATION bit,
	@OBJECT bit,
	@O_NUMBER bit,
	@O_IMSI bit,
	@O_IMEI bit,
	@O_CELL bit,
	@PROTOCOLID smallint,
	@SMS bit,
	@NELZE_ZJISTIT bit,
	@PRODLEVA int,
	@VS bit	

AS
DECLARE
	-- definice prom nnych
	@Ust edna int,
	@Trasa int,
	@OLD_P_Prodleva int,
	@OLD_P_Celkem smallint,
	@OLD_P_nelze_zjistit smallint,
	@OLD_P_DURATION smallint,
	@OLD_P_OBJECT smallint,
	@OLD_P_SMS smallint,
	@OLD_P_O_NUMBER smallint,
	@OLD_P_O_IMSI smallint,
	@OLD_P_O_IMEI smallint,
	@OLD_P_O_CELL smallint,
	@OLD_P_HI1 smallint,
	@OLD_P_HI2 smallint,
	@OLD_P_HI3 smallint,
	@OLD_P_VS smallint,
	@HI1 bit,
	@HI2 bit,
	@HI3 bit,
	@OLD_Trasa_P_Celkem smallint
	
BEGIN
 -- volba nevraci po et zahrnutych adk jako sou ast vysledkove mno iny
	SET NOCOUNT ON;

	-- napln ni HI, dle PROTOCOLID
	" StatementId="1" StatementCompId="2" StatementType="SET ON/OFF" />
<StmtSimple StatementText="	SELECT @HI1 = 0;
	" StatementId="2" StatementCompId="3" StatementType="ASSIGN" />
<StmtSimple StatementText="	SELECT @HI2 = 0;
	" StatementId="3" StatementCompId="4" StatementType="ASSIGN" />
<StmtSimple StatementText="	SELECT @HI3 = 0;

	" StatementId="4" StatementCompId="5" StatementType="ASSIGN" />
<StmtCond StatementText="	IF (@PROTOCOLID = 1)
		" StatementId="5" StatementCompId="6" StatementType="COND">
<Condition />
<Then>
<Statements>
<StmtSimple StatementText="	SELECT @HI1 = 1;

	" StatementId="6" StatementCompId="7" StatementType="ASSIGN" />
</Statements>
</Then>
</StmtCond>
<StmtCond StatementText="	IF (@PROTOCOLID = 2)
		" StatementId="7" StatementCompId="9" StatementType="COND">
<Condition />
<Then>
<Statements>
<StmtSimple StatementText="	SELECT @HI2 = 1;

	" StatementId="8" StatementCompId="10" StatementType="ASSIGN" />
</Statements>
</Then>
</StmtCond>
<StmtCond StatementText="	IF (@PROTOCOLID = 3)
		" StatementId="9" StatementCompId="12" StatementType="COND">
<Condition />
<Then>
<Statements>
<StmtSimple StatementText="	SELECT @HI3 = 1;

	-- projekce ust edny
" StatementId="10" StatementCompId="13" StatementType="ASSIGN" />
</Statements>
</Then>
</StmtCond>
<StmtSimple StatementText="	SELECT @Ust edna = CASE
		-- ET 01OS CCI&IRI
		WHEN (@EXCHANGEID = 330022) THEN 1
		-- ET 02OS CCI&IRI
		WHEN (@EXCHANGEID = 330023) THEN 2
		-- TM 03OS CCI
		WHEN (@EXCHANGEID = 7199) THEN 3
		-- T 30OS CCI
		WHEN (@EXCHANGEID = 203) and (@PROTOCOLID = 3) THEN 4
		-- T 30OS IRI
		WHEN (@EXCHANGEID = 203) and (@PROTOCOLID < 3) THEN 5
		-- neur eno
		ELSE 0
	END

	-- projekce trasy
" StatementId="11" StatementCompId="15" StatementType="ASSIGN" />
<StmtSimple StatementText="	SELECT @Trasa = 0

	-- na teni starych hodnot, pokud adek existuje
" StatementId="12" StatementCompId="16" StatementType="ASSIGN" />
<StmtSimple StatementText="	SELECT
		@OLD_P_Prodleva = P_Prodleva,
		@OLD_P_Celkem = P_Celkem + 1,
		@OLD_P_nelze_zjistit = P_nelze_zjistit,
		@OLD_P_DURATION = P_DURATION,
		@OLD_P_OBJECT = P_OBJECT,
		@OLD_P_SMS = P_SMS,
		@OLD_P_O_NUMBER = P_O_NUMBER,
		@OLD_P_O_IMSI = P_O_IMSI,
		@OLD_P_O_IMEI = P_O_IMEI,
		@OLD_P_O_CELL = P_O_CELL,
		@OLD_P_HI1 = P_HI1,
		@OLD_P_HI2 = P_HI2,
		@OLD_P_HI3 = P_HI3,
		@OLD_P_VS = P_VS
	FROM
		Snimky
	WHERE
		(Datum as = @TIMESTAMPMARK) and (Ust edna = @Ust edna)

	-- zji t ni zda adek neexistuje (pak INSERT), i nikoliv (pak UPDATE)
" StatementId="13" StatementCompId="17" StatementType="SELECT" StatementSubTreeCost="0.0032832" StatementEstRows="1" StatementOptmLevel="TRIVIAL">
<QueryPlan CachedPlanSize="19">
<RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-007" AvgRowSize="38" EstimatedTotalSubtreeCost="0.0032832" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
<OutputList>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_Prodleva" />
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_nelze_zjistit" />
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_DURATION" />
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_OBJECT" />
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_SMS" />
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_O_NUMBER" />
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_O_IMSI" />
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_O_IMEI" />
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_O_CELL" />
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_HI1" />
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_HI2" />
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_HI3" />
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_VS" />
<ColumnReference Column="Expr1003" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1003" />
<ScalarOperator ScalarString="CONVERT_IMPLICIT(smallint,CONVERT_IMPLICIT(int,[IRIX].[dbo].[Snimky].[P_Celkem],0)+(1),0)">
<Convert DataType="smallint" Style="0" Implicit="1">
<ScalarOperator>
<Arithmetic Operation="ADD">
<ScalarOperator>
<Convert DataType="int" Style="0" Implicit="1">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_Celkem" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp NodeId="1" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="38" EstimatedTotalSubtreeCost="0.0032831" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
<OutputList>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_Prodleva" />
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_Celkem" />
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_nelze_zjistit" />
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_DURATION" />
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_OBJECT" />
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_SMS" />
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_O_NUMBER" />
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_O_IMSI" />
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_O_IMEI" />
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_O_CELL" />
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_HI1" />
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_HI2" />
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_HI3" />
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_VS" />
</OutputList>
<IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" NoExpandHint="0">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_Prodleva" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_Celkem" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_nelze_zjistit" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_DURATION" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_OBJECT" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_SMS" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_O_NUMBER" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_O_IMSI" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_O_IMEI" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_O_CELL" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_HI1" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_HI2" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_HI3" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_VS" />
</DefinedValue>
</DefinedValues>
<Object Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Index="[PK__Snimky__0519C6AF]" />
<SeekPredicates>
<SeekPredicate>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="Datum as" />
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="Ust edna" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[@TIMESTAMPMARK]">
<Identifier>
<ColumnReference Column="@TIMESTAMPMARK" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="[@Ust edna]">
<Identifier>
<ColumnReference Column="@Ust edna" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekPredicate>
</SeekPredicates>
</IndexScan>
</RelOp>
</ComputeScalar>
</RelOp>
<ParameterList>
<ColumnReference Column="@TIMESTAMPMARK" ParameterCompiledValue="'2006-06-17 04:23:00.000'" />
</ParameterList>
</QueryPlan>
</StmtSimple>
<StmtCond StatementText="	IF (@OLD_P_Celkem is null)
" StatementId="14" StatementCompId="18" StatementType="COND">
<Condition />
<Then>
<Statements>
<StmtSimple StatementText="	BEGIN
		-- adek neexistuje, provadim INSERT na zaklad vstupnich parametr 
		INSERT INTO
			Snimky
			(
			Datum as,
			Ust edna,
			P_Prodleva,
			P_Celkem,
			P_nelze_zjistit,
			P_DURATION,
			P_OBJECT,
			P_SMS,
			P_O_NUMBER,
			P_O_IMSI,
			P_O_IMEI,
			P_O_CELL,
			P_HI1,
			P_HI2,
			P_HI3,
			P_VS
			)
		VALUES
			(
			@TIMESTAMPMARK,
			@Ust edna,
			@PRODLEVA,
			1,
			@NELZE_ZJISTIT,
			@DURATION,
			@OBJECT,
			@SMS,
			@O_NUMBER,
			@O_IMSI,
			@O_IMEI,
			@O_CELL,
			@HI1,
			@HI2,
			@HI3,
			@VS
			)
" StatementId="15" StatementCompId="19" StatementType="INSERT" StatementSubTreeCost="0.0132896" StatementEstRows="1" StatementOptmLevel="TRIVIAL">
<QueryPlan CachedPlanSize="35">
<RelOp NodeId="1" PhysicalOp="Assert" LogicalOp="Assert" EstimateRows="1" EstimateIO="0" EstimateCPU="1.8e-007" AvgRowSize="9" EstimatedTotalSubtreeCost="0.0132896" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
<OutputList />
<Assert StartupExpression="0">
<RelOp NodeId="2" PhysicalOp="Nested Loops" LogicalOp="Left Semi Join" EstimateRows="1" EstimateIO="0" EstimateCPU="4.18e-006" AvgRowSize="9" EstimatedTotalSubtreeCost="0.0132894" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
<OutputList>
<ColumnReference Column="Expr1021" />
</OutputList>
<NestedLoops Optimized="0">
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1021" />
</DefinedValue>
</DefinedValues>
<OuterReferences>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="Ust edna" />
</OuterReferences>
<ProbeColumn>
<ColumnReference Column="Expr1021" />
</ProbeColumn>
<RelOp NodeId="3" PhysicalOp="Clustered Index Insert" LogicalOp="Insert" EstimateRows="1" EstimateIO="0.01" EstimateCPU="1e-006" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0100022" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
<OutputList>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="Ust edna" />
</OutputList>
<ScalarInsert>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1003" />
<ScalarOperator ScalarString="CONVERT_IMPLICIT(smalldatetime,[@TIMESTAMPMARK],0)">
<Convert DataType="smalldatetime" Style="0" Implicit="1">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@TIMESTAMPMARK" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1004" />
<ScalarOperator ScalarString="(1)">
<Const ConstValue="(1)" />
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1005" />
<ScalarOperator ScalarString="CONVERT_IMPLICIT(smallint,[@NELZE_ZJISTIT],0)">
<Convert DataType="smallint" Style="0" Implicit="1">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@NELZE_ZJISTIT" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1006" />
<ScalarOperator ScalarString="CONVERT_IMPLICIT(smallint,[@DURATION],0)">
<Convert DataType="smallint" Style="0" Implicit="1">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@DURATION" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1007" />
<ScalarOperator ScalarString="CONVERT_IMPLICIT(smallint,[@OBJECT],0)">
<Convert DataType="smallint" Style="0" Implicit="1">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@OBJECT" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1008" />
<ScalarOperator ScalarString="CONVERT_IMPLICIT(smallint,[@SMS],0)">
<Convert DataType="smallint" Style="0" Implicit="1">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@SMS" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1009" />
<ScalarOperator ScalarString="CONVERT_IMPLICIT(smallint,[@O_NUMBER],0)">
<Convert DataType="smallint" Style="0" Implicit="1">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@O_NUMBER" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1010" />
<ScalarOperator ScalarString="CONVERT_IMPLICIT(smallint,[@O_IMSI],0)">
<Convert DataType="smallint" Style="0" Implicit="1">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@O_IMSI" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1011" />
<ScalarOperator ScalarString="CONVERT_IMPLICIT(smallint,[@O_IMEI],0)">
<Convert DataType="smallint" Style="0" Implicit="1">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@O_IMEI" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1012" />
<ScalarOperator ScalarString="CONVERT_IMPLICIT(smallint,[@O_CELL],0)">
<Convert DataType="smallint" Style="0" Implicit="1">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@O_CELL" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1013" />
<ScalarOperator ScalarString="CONVERT_IMPLICIT(smallint,[@HI1],0)">
<Convert DataType="smallint" Style="0" Implicit="1">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@HI1" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1014" />
<ScalarOperator ScalarString="CONVERT_IMPLICIT(smallint,[@HI2],0)">
<Convert DataType="smallint" Style="0" Implicit="1">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@HI2" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1015" />
<ScalarOperator ScalarString="CONVERT_IMPLICIT(smallint,[@HI3],0)">
<Convert DataType="smallint" Style="0" Implicit="1">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@HI3" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1016" />
<ScalarOperator ScalarString="CONVERT_IMPLICIT(smallint,[@VS],0)">
<Convert DataType="smallint" Style="0" Implicit="1">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@VS" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1017" />
<ScalarOperator ScalarString="(0)">
<Const ConstValue="(0)" />
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<Object Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Index="[PK__Snimky__0519C6AF]" />
<SetPredicate>
<ScalarOperator ScalarString="[IRIX].[dbo].[Snimky].[Datum as] = RaiseIfNull([Expr1003]),[IRIX].[dbo].[Snimky].[Ust edna] = RaiseIfNull([@Ust edna]),[IRIX].[dbo].[Snimky].[P_Prodleva] = RaiseIfNull([@PRODLEVA]),[IRIX].[dbo].[Snimky].[P_Celkem] = [Expr1004],[IRIX].[dbo].[Snimky].[P_nelze_zjistit] = RaiseIfNull([Expr1005]),[IRIX].[dbo].[Snimky].[P_DURATION] = RaiseIfNull([Expr1006]),[IRIX].[dbo].[Snimky].[P_OBJECT] = RaiseIfNull([Expr1007]),[IRIX].[dbo].[Snimky].[P_SMS] = RaiseIfNull([Expr1008]),[IRIX].[dbo].[Snimky].[P_O_NUMBER] = RaiseIfNull([Expr1009]),[IRIX].[dbo].[Snimky].[P_O_IMSI] = RaiseIfNull([Expr1010]),[IRIX].[dbo].[Snimky].[P_O_IMEI] = RaiseIfNull([Expr1011]),[IRIX].[dbo].[Snimky].[P_O_CELL] = RaiseIfNull([Expr1012]),[IRIX].[dbo].[Snimky].[P_HI1] = RaiseIfNull([Expr1013]),[IRIX].[dbo].[Snimky].[P_HI2] = RaiseIfNull([Expr1014]),[IRIX].[dbo].[Snimky].[P_HI3] = RaiseIfNull([Expr1015]),[IRIX].[dbo].[Snimky].[P_VS] = RaiseIfNull([Expr1016]),[IRIX].[dbo].[Snimky].[P_RDIS] = [Expr1017]">
<ScalarExpressionList>
<ScalarOperator>
<MultipleAssign>
<Assign>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="Datum as" />
<ScalarOperator>
<Intrinsic FunctionName="RaiseIfNull">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1003" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="Ust edna" />
<ScalarOperator>
<Intrinsic FunctionName="RaiseIfNull">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@Ust edna" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_Prodleva" />
<ScalarOperator>
<Intrinsic FunctionName="RaiseIfNull">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@PRODLEVA" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_Celkem" />
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1004" />
</Identifier>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_nelze_zjistit" />
<ScalarOperator>
<Intrinsic FunctionName="RaiseIfNull">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1005" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_DURATION" />
<ScalarOperator>
<Intrinsic FunctionName="RaiseIfNull">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1006" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_OBJECT" />
<ScalarOperator>
<Intrinsic FunctionName="RaiseIfNull">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1007" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_SMS" />
<ScalarOperator>
<Intrinsic FunctionName="RaiseIfNull">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1008" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_O_NUMBER" />
<ScalarOperator>
<Intrinsic FunctionName="RaiseIfNull">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1009" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_O_IMSI" />
<ScalarOperator>
<Intrinsic FunctionName="RaiseIfNull">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1010" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_O_IMEI" />
<ScalarOperator>
<Intrinsic FunctionName="RaiseIfNull">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1011" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_O_CELL" />
<ScalarOperator>
<Intrinsic FunctionName="RaiseIfNull">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1012" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_HI1" />
<ScalarOperator>
<Intrinsic FunctionName="RaiseIfNull">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1013" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_HI2" />
<ScalarOperator>
<Intrinsic FunctionName="RaiseIfNull">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1014" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_HI3" />
<ScalarOperator>
<Intrinsic FunctionName="RaiseIfNull">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1015" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_VS" />
<ScalarOperator>
<Intrinsic FunctionName="RaiseIfNull">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1016" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_RDIS" />
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1017" />
</Identifier>
</ScalarOperator>
</Assign>
</MultipleAssign>
</ScalarOperator>
</ScalarExpressionList>
</ScalarOperator>
</SetPredicate>
</ScalarInsert>
</RelOp>
<RelOp NodeId="4" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="9" EstimatedTotalSubtreeCost="0.0032831" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
<OutputList />
<IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" NoExpandHint="0">
<DefinedValues />
<Object Database="[IRIX]" Schema="[dbo]" Table="[Ust edny]" Index="[PK__Ust edny__7F60ED59]" />
<SeekPredicates>
<SeekPredicate>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Ust edny]" Column="Ust edna" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[IRIX].[dbo].[Snimky].[Ust edna]">
<Identifier>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="Ust edna" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekPredicate>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="CASE WHEN [Expr1021] IS NULL THEN (0) ELSE NULL END">
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="IS NULL">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1021" />
</Identifier>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(0)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Predicate>
</Assert>
</RelOp>
<ParameterList>
<ColumnReference Column="@VS" ParameterCompiledValue="(0)" />
<ColumnReference Column="@O_CELL" ParameterCompiledValue="(0)" />
<ColumnReference Column="@O_IMEI" ParameterCompiledValue="(0)" />
<ColumnReference Column="@O_IMSI" ParameterCompiledValue="(0)" />
<ColumnReference Column="@O_NUMBER" ParameterCompiledValue="(0)" />
<ColumnReference Column="@SMS" ParameterCompiledValue="(0)" />
<ColumnReference Column="@OBJECT" ParameterCompiledValue="(0)" />
<ColumnReference Column="@DURATION" ParameterCompiledValue="(0)" />
<ColumnReference Column="@NELZE_ZJISTIT" ParameterCompiledValue="(0)" />
<ColumnReference Column="@PRODLEVA" ParameterCompiledValue="(1)" />
<ColumnReference Column="@TIMESTAMPMARK" ParameterCompiledValue="'2006-06-17 04:23:00.000'" />
</ParameterList>
</QueryPlan>
</StmtSimple>
</Statements>
</Then>
<Else>
<Statements />
</Else>
</StmtCond>
<StmtSimple StatementText="	END
	ELSE
	BEGIN
		-- adek existuje, provadim UPDATE na zaklad starych dat a vstupnich parametr 
		UPDATE
			Snimky
		SET
			P_Prodleva = @OLD_P_Prodleva + @PRODLEVA,
			P_Celkem = @OLD_P_Celkem,
			P_nelze_zjistit = @OLD_P_nelze_zjistit + @NELZE_ZJISTIT,
			P_DURATION = @OLD_P_DURATION + @DURATION,
			P_OBJECT = @OLD_P_OBJECT + @OBJECT,
			P_SMS = @OLD_P_SMS + @SMS,
			P_O_NUMBER = @OLD_P_O_NUMBER + @O_NUMBER,
			P_O_IMSI = @OLD_P_O_IMSI + @O_IMSI,
			P_O_IMEI = @OLD_P_O_IMEI + @O_IMEI,
			P_O_CELL = @OLD_P_O_CELL + @O_CELL,
			P_HI1 = @OLD_P_HI1 + @HI1,
			P_HI2 = @OLD_P_HI2 + @HI2,
			P_HI3 = @OLD_P_HI3 + @HI3,
			P_VS = @OLD_P_VS + @VS
		WHERE
			(Datum as = @TIMESTAMPMARK) and (Ust edna = @Ust edna)		
" StatementId="16" StatementCompId="22" StatementType="UPDATE" StatementSubTreeCost="0.0132842" StatementEstRows="1" StatementOptmLevel="TRIVIAL">
<QueryPlan CachedPlanSize="40">
<RelOp NodeId="0" PhysicalOp="Clustered Index Update" LogicalOp="Update" EstimateRows="1" EstimateIO="0.01" EstimateCPU="1e-006" AvgRowSize="9" EstimatedTotalSubtreeCost="0.0132842" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
<OutputList />
<SimpleUpdate>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1003" />
<ScalarOperator ScalarString="[@OLD_P_Prodleva]+[@PRODLEVA]">
<Arithmetic Operation="ADD">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@OLD_P_Prodleva" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Column="@PRODLEVA" />
</Identifier>
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1004" />
<ScalarOperator ScalarString="[@OLD_P_nelze_zjistit]+CONVERT_IMPLICIT(smallint,[@NELZE_ZJISTIT],0)">
<Arithmetic Operation="ADD">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@OLD_P_nelze_zjistit" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Convert DataType="smallint" Style="0" Implicit="1">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@NELZE_ZJISTIT" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1005" />
<ScalarOperator ScalarString="[@OLD_P_DURATION]+CONVERT_IMPLICIT(smallint,[@DURATION],0)">
<Arithmetic Operation="ADD">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@OLD_P_DURATION" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Convert DataType="smallint" Style="0" Implicit="1">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@DURATION" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1006" />
<ScalarOperator ScalarString="[@OLD_P_OBJECT]+CONVERT_IMPLICIT(smallint,[@OBJECT],0)">
<Arithmetic Operation="ADD">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@OLD_P_OBJECT" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Convert DataType="smallint" Style="0" Implicit="1">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@OBJECT" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1007" />
<ScalarOperator ScalarString="[@OLD_P_SMS]+CONVERT_IMPLICIT(smallint,[@SMS],0)">
<Arithmetic Operation="ADD">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@OLD_P_SMS" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Convert DataType="smallint" Style="0" Implicit="1">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@SMS" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1008" />
<ScalarOperator ScalarString="[@OLD_P_O_NUMBER]+CONVERT_IMPLICIT(smallint,[@O_NUMBER],0)">
<Arithmetic Operation="ADD">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@OLD_P_O_NUMBER" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Convert DataType="smallint" Style="0" Implicit="1">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@O_NUMBER" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1009" />
<ScalarOperator ScalarString="[@OLD_P_O_IMSI]+CONVERT_IMPLICIT(smallint,[@O_IMSI],0)">
<Arithmetic Operation="ADD">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@OLD_P_O_IMSI" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Convert DataType="smallint" Style="0" Implicit="1">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@O_IMSI" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1010" />
<ScalarOperator ScalarString="[@OLD_P_O_IMEI]+CONVERT_IMPLICIT(smallint,[@O_IMEI],0)">
<Arithmetic Operation="ADD">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@OLD_P_O_IMEI" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Convert DataType="smallint" Style="0" Implicit="1">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@O_IMEI" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1011" />
<ScalarOperator ScalarString="[@OLD_P_O_CELL]+CONVERT_IMPLICIT(smallint,[@O_CELL],0)">
<Arithmetic Operation="ADD">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@OLD_P_O_CELL" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Convert DataType="smallint" Style="0" Implicit="1">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@O_CELL" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1012" />
<ScalarOperator ScalarString="[@OLD_P_HI1]+CONVERT_IMPLICIT(smallint,[@HI1],0)">
<Arithmetic Operation="ADD">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@OLD_P_HI1" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Convert DataType="smallint" Style="0" Implicit="1">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@HI1" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1013" />
<ScalarOperator ScalarString="[@OLD_P_HI2]+CONVERT_IMPLICIT(smallint,[@HI2],0)">
<Arithmetic Operation="ADD">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@OLD_P_HI2" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Convert DataType="smallint" Style="0" Implicit="1">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@HI2" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1014" />
<ScalarOperator ScalarString="[@OLD_P_HI3]+CONVERT_IMPLICIT(smallint,[@HI3],0)">
<Arithmetic Operation="ADD">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@OLD_P_HI3" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Convert DataType="smallint" Style="0" Implicit="1">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@HI3" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1015" />
<ScalarOperator ScalarString="[@OLD_P_VS]+CONVERT_IMPLICIT(smallint,[@VS],0)">
<Arithmetic Operation="ADD">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@OLD_P_VS" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Convert DataType="smallint" Style="0" Implicit="1">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@VS" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<Object Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Index="[PK__Snimky__0519C6AF]" />
<SeekPredicate>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="Datum as" />
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="Ust edna" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[@TIMESTAMPMARK]">
<Identifier>
<ColumnReference Column="@TIMESTAMPMARK" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="[@Ust edna]">
<Identifier>
<ColumnReference Column="@Ust edna" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekPredicate>
<SetPredicate>
<ScalarOperator ScalarString="[IRIX].[dbo].[Snimky].[P_Prodleva] = RaiseIfNull([Expr1003]),[IRIX].[dbo].[Snimky].[P_Celkem] = RaiseIfNull([@OLD_P_Celkem]),[IRIX].[dbo].[Snimky].[P_nelze_zjistit] = RaiseIfNull([Expr1004]),[IRIX].[dbo].[Snimky].[P_DURATION] = RaiseIfNull([Expr1005]),[IRIX].[dbo].[Snimky].[P_OBJECT] = RaiseIfNull([Expr1006]),[IRIX].[dbo].[Snimky].[P_SMS] = RaiseIfNull([Expr1007]),[IRIX].[dbo].[Snimky].[P_O_NUMBER] = RaiseIfNull([Expr1008]),[IRIX].[dbo].[Snimky].[P_O_IMSI] = RaiseIfNull([Expr1009]),[IRIX].[dbo].[Snimky].[P_O_IMEI] = RaiseIfNull([Expr1010]),[IRIX].[dbo].[Snimky].[P_O_CELL] = RaiseIfNull([Expr1011]),[IRIX].[dbo].[Snimky].[P_HI1] = RaiseIfNull([Expr1012]),[IRIX].[dbo].[Snimky].[P_HI2] = RaiseIfNull([Expr1013]),[IRIX].[dbo].[Snimky].[P_HI3] = RaiseIfNull([Expr1014]),[IRIX].[dbo].[Snimky].[P_VS] = RaiseIfNull([Expr1015])">
<ScalarExpressionList>
<ScalarOperator>
<MultipleAssign>
<Assign>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_Prodleva" />
<ScalarOperator>
<Intrinsic FunctionName="RaiseIfNull">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1003" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_Celkem" />
<ScalarOperator>
<Intrinsic FunctionName="RaiseIfNull">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@OLD_P_Celkem" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_nelze_zjistit" />
<ScalarOperator>
<Intrinsic FunctionName="RaiseIfNull">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1004" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_DURATION" />
<ScalarOperator>
<Intrinsic FunctionName="RaiseIfNull">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1005" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_OBJECT" />
<ScalarOperator>
<Intrinsic FunctionName="RaiseIfNull">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1006" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_SMS" />
<ScalarOperator>
<Intrinsic FunctionName="RaiseIfNull">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1007" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_O_NUMBER" />
<ScalarOperator>
<Intrinsic FunctionName="RaiseIfNull">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1008" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_O_IMSI" />
<ScalarOperator>
<Intrinsic FunctionName="RaiseIfNull">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1009" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_O_IMEI" />
<ScalarOperator>
<Intrinsic FunctionName="RaiseIfNull">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1010" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_O_CELL" />
<ScalarOperator>
<Intrinsic FunctionName="RaiseIfNull">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1011" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_HI1" />
<ScalarOperator>
<Intrinsic FunctionName="RaiseIfNull">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1012" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_HI2" />
<ScalarOperator>
<Intrinsic FunctionName="RaiseIfNull">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1013" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_HI3" />
<ScalarOperator>
<Intrinsic FunctionName="RaiseIfNull">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1014" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="P_VS" />
<ScalarOperator>
<Intrinsic FunctionName="RaiseIfNull">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1015" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Assign>
</MultipleAssign>
</ScalarOperator>
</ScalarExpressionList>
</ScalarOperator>
</SetPredicate>
</SimpleUpdate>
</RelOp>
<ParameterList>
<ColumnReference Column="@VS" ParameterCompiledValue="(0)" />
<ColumnReference Column="@O_CELL" ParameterCompiledValue="(0)" />
<ColumnReference Column="@O_IMEI" ParameterCompiledValue="(0)" />
<ColumnReference Column="@O_IMSI" ParameterCompiledValue="(0)" />
<ColumnReference Column="@O_NUMBER" ParameterCompiledValue="(0)" />
<ColumnReference Column="@SMS" ParameterCompiledValue="(0)" />
<ColumnReference Column="@OBJECT" ParameterCompiledValue="(0)" />
<ColumnReference Column="@DURATION" ParameterCompiledValue="(0)" />
<ColumnReference Column="@NELZE_ZJISTIT" ParameterCompiledValue="(0)" />
<ColumnReference Column="@PRODLEVA" ParameterCompiledValue="(1)" />
<ColumnReference Column="@TIMESTAMPMARK" ParameterCompiledValue="'2006-06-17 04:23:00.000'" />
</ParameterList>
</QueryPlan>
</StmtSimple>
<StmtCond StatementText="	END

	-- pokud byla ztoto n na trasa
	IF (@Trasa <> 0)
" StatementId="17" StatementCompId="24" StatementType="COND">
<Condition />
<Then>
<Statements>
<StmtSimple StatementText="	BEGIN
		-- na teni starych hodnot, pokud adek existuje
		SELECT
			@OLD_Trasa_P_Celkem = P_Celkem + 1
		FROM
			Snimky_Tras
		WHERE
			(Datum as = @TIMESTAMPMARK) and (Ust edna = @Ust edna) and (Trasa = @Trasa)
 
		-- zji t ni zda adek neexistuje (pak INSERT), i nikoliv (pak UPDATE)
	" StatementId="18" StatementCompId="25" StatementType="SELECT" StatementSubTreeCost="0.0032832" StatementEstRows="1" StatementOptmLevel="TRIVIAL">
<QueryPlan CachedPlanSize="8">
<RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-007" AvgRowSize="9" EstimatedTotalSubtreeCost="0.0032832" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
<OutputList>
<ColumnReference Column="Expr1003" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1003" />
<ScalarOperator ScalarString="CONVERT_IMPLICIT(smallint,CONVERT_IMPLICIT(int,[IRIX].[dbo].[Snimky_Tras].[P_Celkem],0)+(1),0)">
<Convert DataType="smallint" Style="0" Implicit="1">
<ScalarOperator>
<Arithmetic Operation="ADD">
<ScalarOperator>
<Convert DataType="int" Style="0" Implicit="1">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky_Tras]" Column="P_Celkem" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp NodeId="1" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="9" EstimatedTotalSubtreeCost="0.0032831" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
<OutputList>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky_Tras]" Column="P_Celkem" />
</OutputList>
<IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" NoExpandHint="0">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky_Tras]" Column="P_Celkem" />
</DefinedValue>
</DefinedValues>
<Object Database="[IRIX]" Schema="[dbo]" Table="[Snimky_Tras]" Index="[PK__Snimky_Tras__1A14E395]" />
<SeekPredicates>
<SeekPredicate>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky_Tras]" Column="Datum as" />
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky_Tras]" Column="Ust edna" />
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky_Tras]" Column="Trasa" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[@TIMESTAMPMARK]">
<Identifier>
<ColumnReference Column="@TIMESTAMPMARK" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="[@Ust edna]">
<Identifier>
<ColumnReference Column="@Ust edna" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="[@Trasa]">
<Identifier>
<ColumnReference Column="@Trasa" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekPredicate>
</SeekPredicates>
</IndexScan>
</RelOp>
</ComputeScalar>
</RelOp>
<ParameterList>
<ColumnReference Column="@TIMESTAMPMARK" ParameterCompiledValue="'2006-06-17 04:23:00.000'" />
</ParameterList>
</QueryPlan>
</StmtSimple>
<StmtCond StatementText="	IF (@OLD_Trasa_P_Celkem is null)
	" StatementId="19" StatementCompId="26" StatementType="COND">
<Condition />
<Then>
<Statements>
<StmtSimple StatementText="	BEGIN
			-- adek neexistuje, provadim INSERT na zaklad vstupnich parametr 
			INSERT INTO
				Snimky_Tras
				(
				Datum as,
				Ust edna,
				Trasa,
				P_Celkem
				)
			VALUES
				(
				@TIMESTAMPMARK,
				@Ust edna,
				@Trasa,
				1
				)
	" StatementId="20" StatementCompId="27" StatementType="INSERT" StatementSubTreeCost="0.0165769" StatementEstRows="1" StatementOptmLevel="TRIVIAL">
<QueryPlan CachedPlanSize="19">
<RelOp NodeId="1" PhysicalOp="Assert" LogicalOp="Assert" EstimateRows="1" EstimateIO="0" EstimateCPU="1.8e-007" AvgRowSize="9" EstimatedTotalSubtreeCost="0.0165769" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
<OutputList />
<Assert StartupExpression="0">
<RelOp NodeId="2" PhysicalOp="Nested Loops" LogicalOp="Left Semi Join" EstimateRows="1" EstimateIO="0" EstimateCPU="4.18e-006" AvgRowSize="9" EstimatedTotalSubtreeCost="0.0165767" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
<OutputList>
<ColumnReference Column="Expr1011" />
<ColumnReference Column="Expr1012" />
</OutputList>
<NestedLoops Optimized="0">
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1012" />
</DefinedValue>
</DefinedValues>
<OuterReferences>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky_Tras]" Column="Trasa" />
</OuterReferences>
<ProbeColumn>
<ColumnReference Column="Expr1012" />
</ProbeColumn>
<RelOp NodeId="3" PhysicalOp="Nested Loops" LogicalOp="Left Semi Join" EstimateRows="1" EstimateIO="0" EstimateCPU="4.18e-006" AvgRowSize="12" EstimatedTotalSubtreeCost="0.0132894" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
<OutputList>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky_Tras]" Column="Trasa" />
<ColumnReference Column="Expr1011" />
</OutputList>
<NestedLoops Optimized="0">
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1011" />
</DefinedValue>
</DefinedValues>
<OuterReferences>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky_Tras]" Column="Datum as" />
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky_Tras]" Column="Ust edna" />
</OuterReferences>
<ProbeColumn>
<ColumnReference Column="Expr1011" />
</ProbeColumn>
<RelOp NodeId="4" PhysicalOp="Clustered Index Insert" LogicalOp="Insert" EstimateRows="1" EstimateIO="0.01" EstimateCPU="1e-006" AvgRowSize="19" EstimatedTotalSubtreeCost="0.0100022" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
<OutputList>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky_Tras]" Column="Datum as" />
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky_Tras]" Column="Ust edna" />
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky_Tras]" Column="Trasa" />
</OutputList>
<ScalarInsert>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1003" />
<ScalarOperator ScalarString="CONVERT_IMPLICIT(smalldatetime,[@TIMESTAMPMARK],0)">
<Convert DataType="smalldatetime" Style="0" Implicit="1">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@TIMESTAMPMARK" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1004" />
<ScalarOperator ScalarString="(1)">
<Const ConstValue="(1)" />
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<Object Database="[IRIX]" Schema="[dbo]" Table="[Snimky_Tras]" Index="[PK__Snimky_Tras__1A14E395]" />
<SetPredicate>
<ScalarOperator ScalarString="[IRIX].[dbo].[Snimky_Tras].[Datum as] = RaiseIfNull([Expr1003]),[IRIX].[dbo].[Snimky_Tras].[Ust edna] = RaiseIfNull([@Ust edna]),[IRIX].[dbo].[Snimky_Tras].[Trasa] = RaiseIfNull([@Trasa]),[IRIX].[dbo].[Snimky_Tras].[P_Celkem] = [Expr1004]">
<ScalarExpressionList>
<ScalarOperator>
<MultipleAssign>
<Assign>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky_Tras]" Column="Datum as" />
<ScalarOperator>
<Intrinsic FunctionName="RaiseIfNull">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1003" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky_Tras]" Column="Ust edna" />
<ScalarOperator>
<Intrinsic FunctionName="RaiseIfNull">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@Ust edna" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky_Tras]" Column="Trasa" />
<ScalarOperator>
<Intrinsic FunctionName="RaiseIfNull">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@Trasa" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky_Tras]" Column="P_Celkem" />
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1004" />
</Identifier>
</ScalarOperator>
</Assign>
</MultipleAssign>
</ScalarOperator>
</ScalarExpressionList>
</ScalarOperator>
</SetPredicate>
</ScalarInsert>
</RelOp>
<RelOp NodeId="5" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="9" EstimatedTotalSubtreeCost="0.0032831" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
<OutputList />
<IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" NoExpandHint="0">
<DefinedValues />
<Object Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Index="[PK__Snimky__0519C6AF]" />
<SeekPredicates>
<SeekPredicate>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="Datum as" />
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky]" Column="Ust edna" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[IRIX].[dbo].[Snimky_Tras].[Datum as]">
<Identifier>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky_Tras]" Column="Datum as" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="[IRIX].[dbo].[Snimky_Tras].[Ust edna]">
<Identifier>
<ColumnReference Database="[IRIX]" Schema="[dbo]" Table="[Snimky_Tras]" Column="Ust edna" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekPredicate>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp NodeId="6" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="9" EstimatedTotalSubtreeCost="0.0032831" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
<OutputList />
<IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" NoExpandHint="0">