Archives of the TeradataForum
Message Posted: Fri, 19 Aug 2011 @ 20:35:54 GMT
<-- Anonymously Posted: Wednesday, August 17, 2011 06:04 -->
I have some questions about LOCKING LOGGER.
I only got the information below from previous posting.
Each AMP maintains a 32K buffer in which locking information is written. Once the buffers are full, new information replaces the oldest information within a given buffer.
1 - How much does this 32K buffer imapact on whole system?
ie.) It affects xx% on CPU or Memory..
ie.) A transaction will slow down by xx% compared to when LockLogger is off.
2 - And how can I tell if Locking Logger has impact on the system? I assume that impacts differ from each system , so I would like to make sure there is no impact on user transaction. (By looking at Resusage?)
If you have any experiences with Locking Logger I would appreciate your information.
6 Nodes (5500H)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|