Ken Henderson profiles the User Mode Scheduler (UMS) in SQL Server 2000 that requires developers to write code that runs efficiently, and yields often enough in the appropriate places. UMS provides more control and allows the server to scale better than it could with the Windows scheduler.
Article: MSDN: Inside the SQL Server 2000 User Mode Scheduler
Posted - 03/08/2004 : 12:41:02
