SQL Server 2008 has a special
algorithm for scheduling user processes using the SQLOS, which manages one
scheduler per logical processor and makes sure that only one process can run on
a scheduler at any given time. The SQLOS manages the assignment of user
connections to workers to keep the number of users per CPU as balanced as
possible. Five configuration options affect the behavior of the scheduler:
Lightweight Pooling, Affinity Mask, Affinity64 Mask, Priority Boost, and Max
Worker Threads.
http://www.mybasicknowledge.com/2012/09/sql-server-database-options-and.html
http://www.mybasicknowledge.com/2012/09/using-windows-system-monitor-for-sql.html
http://www.mybasicknowledge.com/2012/09/sql-server-database-options-and.html
http://www.mybasicknowledge.com/2012/09/using-windows-system-monitor-for-sql.html