I am seeking questions for followings question:
Q1. If we have TASM activated on system with around 3 resource partitions and each having 5 Allocation group, is there any way we can calculate CPU seconds for a query for a particular AG in a particular Resource Partition? THE relative/known PS formula can gives us CPU share but how we can calculate CPU seconds from that?
Q2. If we have 3 active resource partitions (RP1,RP2 and RP3) and lets’ say on RP3 there is a CPU cap limit of (70%) will it, how we will calculate the CPU share for RP3 allocation groups and RP1 or RP2 allocation groups? Will it be the same formula to calculate CPU share or it will differ somewhat?
Q3. At what point of time we shall decide to increase the number of AWTs considering we have Reserved AWTs for Tactical Workload and we are facing circular queue situation continuously and quite often?
Q4. If we have to increase the AWTs then how we calculate this thing?
Q5. While doing capacity planning how we judge that how many nodes client need to buy more. Currently if its 60% data on all Amps and the perm space is expected to finish in 8 months’ time.
Q6. How we can calculate that client needs new nodes and how many?
Request: If some has capacity planning and forcasting material please share.
Thanks Raja for your response and time :)
But I am currently looking for answers in TD 12.
I would request if you can share some Capacity on demand and forecasting material with me on firstname.lastname@example.org.
That would be a great help thanks.
If you have some material on Capacity Planning & forecasting Data, can you please share with me. You can mail me -
I you have any material on the following, could you please send met at email@example.com
1. Performance Management and Query Optimization
2. Configuration/Space Management and Capacity Planning
Shahzad Salam Kasi