Do we have any Query to calculate DISKIO from resusage table for last two days?

Database
The Teradata Database channel includes discussions around advanced Teradata features such as high-performance parallel database technology, the optimizer, mixed workload management solutions, and other related technologies.
Teradata Employee

Do we have any Query to calculate DISKIO from resusage table for last two days?

Hello Forum,

 

Do we have any Query to calculate DISKIO from resusage table for last two days?

I understand the viewpoint metric analysis portlet calculates the disk IO at system level using the API call against monitorphysicalresource, but need the query to calculate from resusage tables for last two days.

 

Thanks,

Sandeep.

 

GANGA SANDEEP KUMAR

1 REPLY
Senior Apprentice

Re: Do we have any Query to calculate DISKIO from resusage table for last two days?

Hi,

Have a look at the macro DBC.ResNode. That contains a lot of high level data and calculations which should point you in the right direction.

Cheers,

Dave

Ward Analytics Ltd - information in motion
www: http://www.ward-analytics.com