All Forums General
shruti1 3 posts Joined 05/14
06 Oct 2014
HIGH - SesAmpCpu

Hi All,
I have a system wherein a few hundred queries that were run under one session that overall had over 15000 CPU seconds used. Could something be done to help reduce CPU usage. I am new to teradata so please help me with this.

Raja_KT 1246 posts Joined 07/09
07 Oct 2014

Few things that come to mey mind:

You can check if there is any product join. Check if you can avoid redistribution, avoiding IO and CPU. If can use column-partitioning, also there is a chance that it may reduce CPU usage or it can be the other way round too, increasing more CPU usage, with autocompression.See if you have compression and decompression, needing to balance IO vs CPU . Single-amp operation will not attribute much to CPU.Conditional statements may increase CPU. Partitioning design fault can cause high CPU usage. How many duplicates NUPI per value, per row.It can be caused by checksum too.

Raja K Thaw
My wiki:
Street Children suffer not by their fault. We can help them if we want.

dnoeth 4628 posts Joined 11/04
07 Oct 2014

Depending on the actual queries 15,000 CPU seconds for a few hundred queries might be low.
I've seen single Selects using a way more than 100,000 seconds.


shruti1 3 posts Joined 05/14
07 Oct 2014

@Raja and @Dieter thank you for your suggestions.

You must sign in to leave a comment.