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,

Thanks!!

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!!

Regards,

Sravan.