AWT exhausion

Database
Highlighted
Enthusiast

AWT exhausion

Hi

 

We are always facing AWT exhausion on daily basis .Is there anyway we can identify how many AWTS are being used per session ? 

 

Help is very much appreciated .

 

Thanks,

1 REPLY 1
Teradata Employee

Re: AWT exhausion

Not directly, you have to infer from the nature of the work being processed.

 

Load utilities are the first place to check, since those hold multiple AWT per AMP for the duration of the load. Long duration query steps would be next; particularly those that include a redistribution (since those need a sender AWT and a receiver AWT) or are doing insert/update/delete (need AWTs for Fallback maintenance).