The goal of this presentation is to give answers on following questions:

Why did Sybase implement page level lock?
What are the pros and cons for Allpage lock clustered index?
Why do we have concurrency issues with Allpage locks?
How to solve concurrency problem?
Why do row level locking help to increase performance?
Why is it necessary to have fixed row ID inside data page in order to reduce lock contention?
How does row level locking impact SQL ?
What is the impact of row level locking on performance?
What are the pros and cons of tables with row level locking schemes?


Download the presentation on Sybase Performance and Locking Schemes