Archives of the TeradataForum
Message Posted: Wed, 10 Sep 2003 @ 15:08:11 GMT
Subj: | | Re: CPU vs Disk IO |
|
From: | | Ferry, Craig |
I have 28 amps. How does this figure into the earlier calculation? I left the earlier numbers for reference.
Just to make sure I understand this ratio, using these numbers, the first 3 entries had questionable queries running and the next 3 were
fine.
Date TheHour UserName CpuTime DiskIO LH Ratio
9/3/2003 19 USERA 12197 262638 46.44034755
9/2/2003 20 USERA 11902 263475 45.17316633
9/2/2003 18 USERA 11524 1532749 7.518517383
9/3/2003 16 USERA 11569 1868715 6.19088518
9/3/2003 13 USERB 295 106476 2.770577407
|