Using dbcc tune on spinlocks

When you see a scaling problem due to a spinlock contention on the "des manager" you can use the des_bind command to improve the scalability of the server where object descriptors are reserved for hot objects. The descriptors for these hot objects are never scavenged.

dbcc tune(des_bind, <dbid>, <objname>)

To remove the binding use:

dbcc tune(des_unbind, <dbid>, <objname>)

NoteTo unbind an object from the database, the database has to be in "single user mode"