Archives of the TeradataForum

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

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

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