Archives of the TeradataForum

Message Posted: Fri, 03 Apr 2015 @ 14:00:03 GMT

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

Hi Sravan,

Do not concentrate on CPU consumption only. Look at IOs, AWT usage, Disk and CPU skew...

You can also try to get as much information as you can about the canary query itself from DBQL:

Was the canary query long at some particular step?

Was there a bottleneck at parsing time?

Was the query not blocked by some other transaction?

Regards,

Tomas

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