When you see a scaling problem due to a spinlock contention, use des_bind to improve the scalability of the server where object descriptors are reserved for hot objects. The descriptors for these hot objects are never reserved.
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.
