HIGH - SesAmpCpu

General

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.

3 REPLIES
Enthusiast

Re: HIGH - SesAmpCpu

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.

Senior Apprentice

Re: HIGH - SesAmpCpu

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.

Re: HIGH - SesAmpCpu

@Raja and @dieter thank you for your suggestions.