Each engine’s freelock list is a portion of the global freelock list allocated to the engines, defined by the max engines freelocks configuration parameter as a percentage of the total number of locks. By default, SQL Server assigns 10 percent of the total number of locks to all the engines’ freelock lists; the remainder stays in the global freelock list. For example, if your server is configured with 5000 locks, 500 locks are distributed evenly between each engine freelock list, and 4500 remain in the global freelock list.
For most SQL Server configurations, you can double the percentage of locks assigned to the engine freelock lists and improve the performance of your applications.
