Archives of the TeradataForum

Message Posted: Tue, 22 Dec 2015 @ 07:28:34 GMT

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

Hi,

Does anyone have a query that will show CPU & I/O consumption by workload? We can't use DBQL as we don't have full logging on batch workloads.

The aim is to show of the resource being consumed, what the breakdown was across the TDWM workloads. The Ampusage could give a partial picture, but is no good where a workload is allocated not only on profile/accountstring, but on the expected query performance.

Can dbc.ResUsageSps be used for this purpose or even PDCRINFO.TDWMSummaryLog_Hst?

Thanks,

Martin

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