Archives of the TeradataForum

Message Posted: Fri, 29 Oct 2010 @ 19:48:41 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

The duplicate entries are because of the change in dbql logging which was introduced via DR127236; Applications generate SQLPrepare function followed by SQLExecute.

The Prepare part of it logs one row with everything zero to DBQL, followed by another row with actual cpu,spool, IO etc...that will be consumed by SQL Execute function which actually runs query.

To get correct query counts you may ignore the rows which have ampcputime=0,WDID is null for a particular statement Type.

For more information pls check KAP1A1C16.

Regards,

Abhishek Jadhav

	<Prev	Next>		<<First	<Prev	Next>	Last>>