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.
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,.