Export (0) Print
Expand All
Expand Minimize

Keep the Locks Configuration Option Default Value

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

This rule checks the value of the locks configuration option. This option determines the maximum number of available locks. This limits how much memory the SQL Server Database Engine uses for locks. The default setting of 0 enables the Database Engine to allocate and deallocate lock structures dynamically based on changing system requirements. 

If locks is nonzero, batch jobs will stop, and an "out of locks" error message will be generated, if the value specified is exceeded.

Use the sp_configure system stored procedure to change the value of locks to its default setting by using the following statement:

EXEC sp_configure 'locks', 0;
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft