Archives of the TeradataForum
Message Posted: Sat, 31 Jan 2009 @ 18:16:14 GMT
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.
Teradata Professional Services
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|