Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » SQL Anywhere Server - Database Administration » Performance improvements, diagnostics, and monitoring » Performance » Tips for improving performance

Tip: Check for concurrency issues

Concurrent access of information stored in the database by other transactions is prevented by locks that maintain the reliability of information.

When the database server processes a transaction, it can lock one or more table rows. They also improve the accuracy of result queries by identifying information that is in the process of being updated.

When the database server processes a transaction, it can lock one or more table rows. The locks maintain the reliability of information stored in the database by preventing concurrent access by other transactions. They also improve the accuracy of result queries by identifying information that is in the process of being updated.

The database server places these locks automatically and needs no explicit instruction. It holds all the locks acquired by a transaction until the transaction is completed. The transaction that has access to the row is said to hold the lock. Depending on the type of lock, other transactions may have limited access to the locked row, or none at all.

Performance can be compromised if a row or rows are frequently accessed by several users simultaneously. If you suspect locking problems, consider using the sa_locks procedure to obtain information about locks in the database.

If lock issues are identified, information about the connection processes involved can be found using the AppInfo connection property.