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.

See Also

Concepts