MyQuery portlet and Skew

Viewpoint
Supporter

MyQuery portlet and Skew

Hi all,

we run TD 13 on a coexisting system.
I observe that many queries of in viewpoint show high skew values but the data has good distributions.
Does Viewpoint calculate the skew on the normalized CPU or on the non normalized CPU?

3 REPLIES
Teradata Employee

Re: MyQuery portlet and Skew

Viewpoint does not normalize any CPU values for coexistence systems. How would you want Viewpoint to handle this? Would you want it to account for the number of CPUs on each node? Or something more complicated than that?
Supporter

Re: MyQuery portlet and Skew

DBQL does provide normed CPU information. Main reason is that otherwise skew is a regular pattern in coexsisting systems and skew reporting becomes very difficult to read. So question remain. Is Viewpoint reporting the CPU and normed CPU in respect to CPU skeq?
Teradata Employee

Re: MyQuery portlet and Skew

While Viewpoint does not do anything to account for coexistence systems, the API that is called to retrieve session CPU usage does account for it. If you have the MonSesCPUNormalization field, a DBS Control General Record field, set to TRUE, then the session skew data in Viewpoint will be normalized.