Search code examples
sap-asedatabase-deadlocks

What is the default number of locks available in Sybase


Sybase is throwing following error "a deadlock has occured or all locks were taken". So I wanted to check if the issue happened because of Sybase running out of available locks.

Does anyone know the default locks available, and also how to find the available number of locks


Solution

  • check..

    sp_helpconfig "number of locks: