spin counter Option

Use the spin counter option to specify the maximum number of attempts a process can make when trying to obtain a resource. On computers with only one processor, there should be no contention, and the run value for this option is always 0. On computers with multiple processors, the default value is 10000 and you can change the value.

spin counter is an advanced option. If you are using the sp_configure system stored procedure to change the setting, you can change spin counter only when show advanced options is set to 1. The setting takes effect immediately (without a server stop and restart).

To set the spin counter option

See Also