Killer queries: Track them, find them, fix them

Viewpoint
Teradata Viewpoint is Teradata's strategic and innovative SOV (single operational view) for Teradata DB, Aster, and HDP Hadoop systems management and monitoring that enables Teradata's Unified Data Architecture (UDA).
kvz
Enthusiast

Re: Killer queries: Track them, find them, fix them

Hi Shrity,

Need help for alert setup.

How can i set alert mail for PJI > 5 in viewpoint? If not, what is the other way to get alert for high PJI?

Teradata Employee

Re: Killer queries: Track them, find them, fix them

You cannot set alert on PJI but PJI is  calculated as "when ampcputime < HashAmp()+1 or TotalIOCount = 0 then 0  else (ampcputime *1000)/TotalIOCount"  and you can set alerts on AMP CPU  

kvz
Enthusiast

Re: Killer queries: Track them, find them, fix them

Thanks Shirty!

kvz
Enthusiast

Re: Killer queries: Track them, find them, fix them

Is there any way to schedule script which will send alert email for sessions which are in delayed state for more than 30 min ??

Junior Supporter

Re: Killer queries: Track them, find them, fix them

Hi Shrity,

Do queries in responding phase take cpu/AWT/any other resource and should we abort them if we see any query in responding phase for a very long time ? 

--Samir