Sybase has run out of LOCKS – ASE Error SQL1204

Sometimes in Your Sybase environment You can see error like “ASE has run out of LOCKS. Re-run your command when there are fewer active users, or contact a user with System Administrator (SA) role to reconfigure SQL Server with more LOCKS.” This error occurs when Adaptive Server runs out of locks…

Solution

Determine the number of locks currently configured for Adaptive Server:

1> use master
2> go
1> sp_configure "number of locks"
2> go
Parameter Name Default Memory Used Config Value Run Value Unit Type
---------------- ----------- ------------- -------------- ------------ ------ -------
number of locks 10000 1172288 5000000 5000000 number dynamic

(1 row affected)
(return status = 0)

 

Choose the number of locks You want to configure. Normally the new values should be around 10%-25% higher than the current used value, to set this:

1> sp_configure "number of locks", <new_value>
2> go

If You need monitor the usage of the locks use the procedure sp_monitorconfig like below:

1> sp_monitorconfig "number of locks"
2> go

-- Or You can check whole config:
1> sp_monitorconfig "all"
2> go