Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 19 Jun 2009 @ 09:39:08 GMT


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


Subj:   Question about Pmon - (increasing cpu, io's etc)
 
From:   Anomy Anom

<-- Anonymously Posted: Friday, June 19, 2009 05:27 -->

Dave

  To check a query whilst it is running use Teradata Manager, PMON or (if you're on TD 12) you can use the MonitorSession command. These will show you if the query is doing anything (increasing cpu, io's etc and changing spool space).  


How many cpusecs or I/O indicates a query is not performing good ? Is there a upper limit ?

Can you elaborate more on this ?

(increasing cpu, io's etc and changing spool space).


It will remain constant if query is peforming good?


Thanks !!



     
  <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