Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Sat, 17 Mar 2012 @ 19:30:54 GMT

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

Subj:   Re: To find the CPU Usage of the system
From:   Bodla, Sravan Kumar

Hi Manish, Sobhan,


We dont have PDCR setup in the environment. @Sobhan, the query provided by you gives the cpu utilization of each vproc that was fine, but I was looking for few more details.

Hi all,

Can I ask you to help me in finding the system usage.

Like, username, query submitted by each user, query runtime, total rows processed, sum(Cpu time), Sum(IO) for a particular day(So that , I can identify bad queries).

Thanks in Advance!!



  <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