Archives of the TeradataForum

Message Posted: Thu, 28 Sep 2006 @ 17:43:09 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Re: RAM Increase

From:		John Graas

Bil Hassinger wrote:

Newer MP-RAS systems can have 4GB RAM vs the older 2 GB standard. I believe I remember some presentation stating that the 4 GB is not necessary for increased TD performance. Does anyone know the advantage of the additional RAM? We are strictly a DSS system, so caching of queries or results would not likely be affected. Is it useful for more data block retrieval? Memory allocation to hardware tasks? Read/write queuing?

IMHO, increased RAM (2GB to 4GB) is good for versions V2R5.x and above.

Taking a look at the Teradata "Performance Management" manual, Ch. 13, there is a list of newer memory using features:

- External Stored Procedures and table functions, available in Teradata Database V2R6.x.

- Large objects (LOBs) and user-defined functions (UDFs), available in Teradata Database V2R5.1

- PPI and value-list compression, available in Teradata Database V2R5.x

- Join index, hash-join, stored procedures and 128K datablocks, available prior to Teradata Database V2R5.0.

As always, your mileage may vary.

jdg

www.jgraas.com


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Attachments

Library

Quick Reference