Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Sat, 31 Jan 2009 @ 18:16:14 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Memfails - who is the culprit?
From:   Woodrow, Steven

Looking past the memfails, you can see you are running out of memory on the nodes at these times. Your MinMB Mem Free is approaching zero.

This is probably the cause of the Mem Fails.

So, what can cause your memory to drop at certain time of day?

More times than not when I have seen this, it has been caused by load utilities coming into the box and flooding it with too many sessions.

Many times this is due to not specifying a Sessions parameter on the load jobs, and then Teradata defaulting to 1 per Amp on your system. Or specifying a sessions parameter that is way too high.

Do these drops in memory, and subsequent memfails, coordinate with load jobs?

And regarding your last question, should you care? I would say yes. Running out of memory isn't a preferred situation.

If you are unable to find a specific cause, you may wish to talk to your CSR or the GSC to discuss if lowering FSG cache is a possible consideration to ease the memory issue.

Steve Woodrow

Teradata Professional Services
Performance & Workload Management COE

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016