Archives of the TeradataForum
Message Posted: Tue, 22 Dec 2015 @ 07:28:34 GMT
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?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|