Settting up Alerts policy first time on Teradata Manager 13.0 alert action sending email

Tools
Enthusiast

Settting up Alerts policy first time on Teradata Manager 13.0 alert action sending email

Our client is useing Teradata 13.0 and no ViewPoint.

We are trying to set up some system alerts on Dev and Prod boxes for some critical events like CPU Skew, run out of space .

I have configured SMTP for Email alert on dev box and tested server sent me the test mail and success.

I created a alert policy for CPU skew > 60% and to send a email to DBA action, but we have couple of jobs ran with high cpu skew more than

70% but i did not get any email alert. I have seen the corresponding Alert table it is active please help me in this .

Is there any thing i miss please help me in this,

Thank You.

3 REPLIES
Enthusiast

Re: Settting up Alerts policy first time on Teradata Manager 13.0 alert action sending email

There could be other issues as well but remember that CPU skew is a session level alert, one query skewing more than the alert threshold is not a guarantee that an alert will be triggered.

It's better to test the alerts by creating a blocking alert and manually getting a session blocked for the threshold number of minutes. It's quite easy to do that.

Regards,

Umair

Enthusiast

Re: Settting up Alerts policy first time on Teradata Manager 13.0 alert action sending email

I will try that and let you know.

Thank you alive.

Enthusiast

Re: Settting up Alerts policy first time on Teradata Manager 13.0 alert action sending email

hi alvie,

Now i set alert for number of sessions.

If no.of sessions per user more than 2 it suppose to send a email.

But the alert policy is not triggered even there are users more than 2 sessions.

And also i am not seeing any thing on the Alter viewer.

Please suugest if i miss any thing this is on dev box.

Thank You.