Node Memory optimization

Database
Kks
Enthusiast

Node Memory optimization

Hi,

I am looking for Node Memory Optimization for Operating System

is there any SQL or tool to do and check it .

Thanks for all the replies

3 REPLIES
Kks
Enthusiast

Re: Node Memory optimization

Request your replies
Enthusiast

Re: Node Memory optimization

I'm not a TD DBA, so i dont have real time experience on handling memory issues.

But Please check the following link where Carrie has answered a question on issues with memory.

http://www.teradata.com/tdmo/v06n04/Tech2Tech/TechSupport/ExpertAnswers.aspx

The answer gives details at a very high level and not in a detailed manner.
You can probably refer the Adminstration/Performance Management document for more details.

Regards,
Annal T

Re: Node Memory optimization

Hi,

Following is the hyperlink to presentation/procedure for "Memory Management – A Balancing Act ".

This article addresses Memory Balancing/efficient utilization among different components of the PDE/DBS. If you need more specific help, please raise query.

Move on to the hyperlink:
https://www.allmydata.com/webdrive/tiny/ue73dmdpo243jdh7f0rsbckp3qt7

If you do not have account already on this website, just create your account by clicking "click here" in the popup window. Account creation is fairly simple, just give ur email ID and choose a new password.

Again paste the above link. After logging in by your new account, you will get the "memory management.zip" file moved into your account.

The Agenda is as follows:

Node Memory
Memory Partitioning
-- Between OS and FSG Cache
--FSG Cache Percent
OS Managed Memory
--Free Memory
PDE Managed Memory
FSG Cache.
Monitoring memory
--Free memory availability
--Memory allocation failures
--Paging/Swapping.
--Cache Effectiveness Rate
Adjusting FSG Cache
DBS Cache Threshold
Hash Join - HtMemAlloc
Redistribution Buffer

Thanks & Regards,