Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Thu, 16 Oct 2008 @ 14:12:33 GMT


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


Subj:   Re: Getting a session's own resource info
 
From:   Dieter Noeth

Levai Akos wrote:

  I would like to get a session's consumed resource info (CPU, IOand so on...), within the session through SQL.  


  It would be important for me the the session sould get these informations itself, and write it to the output.  


  I would not like to use the DBQL, because the overhead, and the offline postprocessing (matching the query with the DBQL log)  


If you run TD12 there's a new set of UDFs to access all the data provided by the PMon-API through SQL.

Of course you'll need another session to access that data for a currently running query.

And if a query is finished you still have to access DBQL, but in TD12 there's a new feature "querybanding" which helps to locate that query within DBQL.


Dieter



     
  <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: 28 Jun 2020