Queue on CPU and Resusage Table

Tools & Utilities
Kks
Enthusiast

Queue on CPU and Resusage Table

Hi,

How can I find out the Queue on CPU from Resusage Table (SPMA)

like SAR of unix

Thanks
4 REPLIES
Kks
Enthusiast

Re: Queue on CPU and Resusage Table

Hi,

How can I find out the Queue on CPU from Resusage Table (SPMA)

like SAR of unix

Thanks
Teradata Employee

Re: Queue on CPU and Resusage Table

(ProcReadySum / CollectIntervals) should give you an "average CPU queue depth" by node by log interval. Or SUM(ProcReadySum)/SUM(CollectIntervals) it you want to aggregate...
Kks
Enthusiast

Re: Queue on CPU and Resusage Table

does this CPU queue is related to AWT queues
Teradata Employee

Re: Queue on CPU and Resusage Table

No, this would be processes (which might be AWTs) waiting in the OS dispatcher queue for their next CPU time slice. It's not directly related to messages waiting for an AWT to pick one up and start working on it.