Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 02 Jan 2004 @ 19:26:43 GMT


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


Subj:   Resourse Usage
 
From:   Hassinger, Bill

We have a 4 node 4800 system with 80 AMPs and V2R3. Using sar when the system is at 100% CPU, there is usually about 50-50 allocation of resources between % user and % system. Since I understand that % user is a reflection of awt work, I would hope that % user would be at 65-75% when the system is 100%. Am I being optimistic? Should 50-50 be expected when most of the work during daytime hours is being done by DSS queries with lots of joins and spool files?

Using Session Information in Teradata Manager, Delta CPU for the active sessions totals about 150-200 CPU sec each 10 seconds for a system with 16 processors, does this seem low?

We are somewhat frustrated because when we have more than about a dozen active sessions, response times goes in the pits, and I would think TD could effectively support many more users than that.



     
  <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: 27 Dec 2016