All Forums Database
san28 20 posts Joined 01/14
28 Oct 2015
Teradata performance impacted due to CPU overload

Hi all,
We are experiencing a slow teradata performance due to increase in CPU usage. The data as such has not really increased and neither has the scheduled jobs. Can you please give me some pointers as to where should we begin to start investigating the issue? We have the top 4 ids which consume over 3% of cpu each. Thank you so much for your time and help.
Regards,
San

dins2k2 51 posts Joined 05/13
23 Nov 2015

Hi,
You can get the queries run by top 4 user ids and check for
1. Product join, PJ consumes more CPU. 
2. Statistics information of the tables that are involed in the queries by those users, due to stale stats optimizer is good enough to create the execution plan.
3. Table and session skewness.
3. Hardware issue migh be one of the reasons like slow drives, faulty CPU, etc,.
 
Thanks,
Dinesh
 

You must sign in to leave a comment.