Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

How to: Configure the locks Option (SQL Server Management Studio)

Use the locks option to set the maximum number of available locks, thereby limiting the amount of memory the Microsoft SQL Server Database Engine uses for them. The default setting is 0, which allows the Database Engine to allocate and deallocate lock structures dynamically, based on changing system requirements.

To configure the locks option

  1. In Object Explorer, right-click a server and select Properties.

  2. Click the Advanced node.

  3. Under Parallelism, type the desired value for the locks option.

    Use the locks option to set the maximum number of available locks, thereby limiting the amount of memory SQL Server uses for them. The default setting is 0, which allows SQL Server to allocate and deallocate locks dynamically based on changing system requirements.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.