Transaction timeout  Unexpected deadlock errors

Chapter 6: Database Access Tuning

Transaction memory table size

The transaction manager uses an internal table to track the status of pending transactions. You can tune the size of the table by setting the server property com.sybase.jaguar.server.jta.tranTableSize. The default is 1024.

This table provides cached storage of the transaction information. If the number of pending transactions exceeds the table size, new memory is allocated and deallocated as needed. For best performance, set the value to at least one-half the maximum number of simultaneous transactions expected in your application.





Copyright © 2005. Sybase Inc. All rights reserved. Unexpected deadlock errors

View this book as PDF