Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 05 Apr 2010 @ 13:13:06 GMT


     
  <Prev Next>   <<First <Prev
Next>
Last>>
 


Subj:   Re: CPU Skew/IO Skew/Hot AMP Cpu
 
From:   Anderson, Dirk

1. CPU and IO skew are usually inter-related, but depending upon the type of work being performed, sometimes CPU usage will be high on one amp, whereas I/O (block reads/writes) will be in the normal range, or vice versa.

2. It means the hot amp is doing 19.6 times as much work as the average amp. This is very skewed, but may be acceptable for a very small query (for example, less than 5 CPU seconds). You always have to consider CPU skewing in relation to the size of the query. The larger the query, the greater the impact of skew on the system.


Thanks.

Dirk Anderson
Architect Manager
Enterprise Information Management



     
  <Prev Next>   <<First <Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019