Viewpoint and Corresponding DBC Table

Database
Enthusiast

Viewpoint and Corresponding DBC Table

Hi

In Viewpoint Query-Monitor, for a particular session we can check the cpu skew and also the highest and average cpu.

If I want to check this from database, then which table and column shall I refer, is it DBQLogTbl or AMPUsageV view or anything else?

Thanks

Santanu

3 REPLIES
Enthusiast

Re: Viewpoint and Corresponding DBC Table

Hi

Anyone, any guidance ?

Santanu

Teradata Employee

Re: Viewpoint and Corresponding DBC Table

Hi Santanu,

for the near-real-time data, you might want to check MonitorSession:

 SELECT * FROM TABLE (SYSLIB.MonitorSession(-1,'*',0));

for the history data, the DBQL is the most probable choice.

Regards,

Vlad.

Teradata Employee

Re: Viewpoint and Corresponding DBC Table

p.s. forgot the alias, it is SELECT * FROM TABLE (SYSLIB.MonitorSession(-1,'*',0)) as t1;

Both MonitorSession and DBQL do not have skew column pre-calculated, but it can be calculated based on high/low AMP CPU and the number of participating AMPs.