Archives of the TeradataForum
Message Posted: Fri, 03 Apr 2015 @ 14:00:03 GMT
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?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|