0

In ResUsageSpma data is reported per node. The definition of column AwtInUseMax is given as:

Peak number of AWTs (Max) on this node. This is not the Peak or the Max value stored in the Priority Scheduler (sch) data structure and reported by the puma utility. The sch peak value is the Max value since startup is never set and Max is the maximum allowed value.

We don't know if this gives us the maximum AWT count from all the AMPs in the node OR sum of maximum AWT count from all AMPs

I'm asking this because we are thinking of dividing the AwtInUseMax by the number of AMPs in the node i.e. AwtInUseMax/Vproc1. Is it right to divide by the number of AMPs to determine the maximum AWT usage per node per AMP?

Can anyone please confirm?

Note: I have also posted this question on the official Teradata forums: http://bit.ly/bon8er

flag
I'm trying to get the admins to start collecting this AWT data so I can begin to analyze it. I'm sure Carrie will answer your question soon enough. :) – Rob Paller♦ May 20 at 12:15
thanks Rob :) We don't have enough nodes in our lab to have concrete results. I too am waiting to analyze a customer's data. Let's see who wins :D – Monis Iqbal May 20 at 15:43

1 Answer

0

Got the answer from a follow up on Carrie's blog post. http://developer.teradata.com/blog/carrie/2009/09/ more-on-resusagesawt-w...

AwtInUseMax gives us the value representing the max AWT in-use count for ALL the AMPs in the node.

This was also backed up by data from Spma and Sawt. Below is the data for a single node for the same date and time.

ResUsageSpma

AwtInUseMax
77.00

ResUsageSawt

VprId   InuseMax
1   74.00
3   75.00
5   74.00
7   74.00
9   73.00
11  74.00
13  70.00
15  73.00
17  74.00
19  74.00
21  74.00
23  70.00
25  73.00
27  74.00
29  73.00
31  74.00
33  68.00
35  74.00
37  69.00
39  74.00
41  74.00
43  74.00
45  74.00
47  72.00
49  74.00
51  77.00
53  74.00
55  74.00
57  75.00
59  74.00
61  74.00
63  68.00
65  73.00
67  74.00
69  70.00
71  74.00
73  74.00
75  75.00
77  75.00
79  74.00
link|flag

Your Answer

Get an OpenID
or

Not the answer you're looking for? Browse other questions tagged or ask your own question.