Disk IOs in Teradata 14.10

Database
Enthusiast

Disk IOs in Teradata 14.10

I am very concerned with the Disk IOs of my Teradata server.

I have ran the following query

SELECT SUM(CPUTIME), SUM(Diskio)
FROM DBC.AMPusage
WHERE AccountName='TEST_ACC'
GROUP BY AccountName;

and i got the following result

Sum(CpuTime) = 48408556.15

Sum(DiskIO) = 25706444525.10

Based on the DiskIO/CpuTime formula i get a value of ~ 531 Disk I/Os per CPU second.

From what i know an acceptable value would be about 50 Disk I/Os.

I am suspecting that the problem might be created because we use a lot of DROP statements for TMP tables that are physically create during the run of our ETL process.

If anyone can help i will appreciate it. Thanks.

Tags (3)
1 REPLY
Enthusiast

Re: Disk IOs in Teradata 14.10

You can get more infor by including username too and then  drill further to dbql tables...