"When you see a scaling problem resulting from spinlock contention, use des_bind to improve the scalability of the server where object descriptors are reserved for hot objects. Descriptors for bound objects are never released. Binding the descriptors for even a few commonly used objects may reduce the overall metadata spinlock contention and improve performance.
dbcc tune(des_bind, <dbid>, <objname>)
To remove the binding, use:
dbcc tune(des_unbind, <dbid>, <objname>)
To unbind an object from the database, the database must
be in single user mode.
Do not use des_bind:
On objects in system databases such as master and tempdb
On system tables
Since des_bind is not persistent, you must reissue any binding commands each time you restart the server.
