CPU Skew / IO Skew

Database

CPU Skew / IO Skew

Hi,

Is there any way i can find out the CPU skew and IO skew of a query from dbql tables. If yes can u tell me which tables and which columns..

Thanks in advance.

2 REPLIES

Re: CPU Skew / IO Skew

Query select * from dbc.dbqlogtbl where condition client id or timstamp casted with date.

You may have to query the history database u created for this for old queries
Teradata Employee

Re: CPU Skew / IO Skew

Typical calculation for skew factor is (1 - (AVG/MAX))*100.

QryLog has MAX and Total values; to get "AVG", divide total by NumOfActiveAMPs.