Amount of data read from disk

Database

Amount of data read from disk

Is there any table which I could use to estimate the amount of data that we read from disk per minute(or any time frame) on Teradata ?

I did a quick read on the ResourceUsage Tables documentation and was able to find the following table :

   1.  HostReadKB   from   dbc.ResUsageShst

   2.  (Total Reads per Second) * (KB per I/O) by running the macro dbc.ResNetByNode

I would like to know if these provide me with the right figures or is there another place I can find this information..

Thanks.

Regards,

Nishanth

1 REPLY
Teradata Employee

Re: Amount of data read from disk

Start with the ResLdvByNode macro.

"host" refers to network traffic in and out of the Teradata platform.

"net" refers to BYnet traffic.

"ldv" refers to the logical devices over which the IO to disk are performed.