Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 07 May 2003 @ 15:19:22 GMT


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


Subj:   Re: CPU in Real-Time
 
From:   David Wellman

Depends on your definition of 'real-time'. But the answer is probably "you can't".

Using SQL, the only way to get CPU usage is by querying the Resusage tables. But typically a system will be set up to only have Resusage Logging run every 10 minutes, so the data you retrieve this way is up to 10 minutes old. That is probably not your definition of real-time. You can get Resusage Logging down to 6 seconds, but that will potentially write a LOT of data to disk.

To get 'real-time' data you really need to use the PM/API, but you have to write a program you can't use SQL. Otherwise, use a tool like PMON to show the data. There are other tools available if you're interested in this data, contact me off-list and I'll tell you about them.


Cheers,

Dave



     
  <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: 15 Jun 2023