SQL SERVER Scheduling Options


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