Identify resource intensive queries and restrict requests that exceed a defined processing time.

General
Teradata Employee

Identify resource intensive queries and restrict requests that exceed a defined processing time.

Hello Forum,

 

I would like to identify and report resource intensive queries and associated Developers user id on weekly basis, any ideas ?
Also, Is it possble to Restrict request that exceed a processing time or result set that exceed a defined rows size threshold?

 

Thanks,

Sandeep.

 

GANGA SANDEEP KUMAR

1 REPLY
Enthusiast

Re: Identify resource intensive queries and restrict requests that exceed a defined processing time.

You should talk to your DBA.

If you are a DBA, you should read about TASM.