MSDN: Inside the SQL Server 2000 User Mode Scheduler

By Bill Graziano on 8 March 2004 | 0 Comments | Tags: Performance Tuning


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. Follow the link to MSDN: Inside the SQL Server 2000 User Mode Scheduler...

Discuss this article: 0 Comments so far. Print this Article.

If you like this article you can sign up for our weekly newsletter. There's an opt-out link at the bottom of each newsletter so it's easy to unsubscribe at any time.

Email Address:

Related Articles

Which is Faster: SAN or Directly-Attached Storage? (21 January 2008)

Benchmarking Disk I/O Performance: Size Matters! (30 October 2007)

What I Wish Developers Knew About SQL Server (Presentation) (11 October 2007)

Introduction to Parameterization in SQL Server (7 August 2007)

Using Indexed Computed Columns to Improve Performance (16 January 2007)

SQL Server Storage Engine Team Blog (7 June 2006)

Statistics Used by the Query Optimizer in Microsoft SQL Server 2005 (1 June 2005)

Improving .NET Application Performance and Scalability (29 April 2004)

Other Recent Forum Posts

select with Header and detail (0 Replies)

Help with string (4 Replies)

SQL server installation issues (6 Replies)

SPROC paging and sorting issue (0 Replies)

Error: 9003, Severity: 20, State: 1. (2 Replies)

SQL named instance cannot be connected (3 Replies)

SQL SERVER 2014 & VS2013 instance issues (1 Reply)

When and How to create a New SQL Server Instance ? (2 Replies)

Subscribe to SQLTeam.com

Weekly SQL Server newsletter with articles, forum posts, and blog posts via email. Subscribers receive our white paper with performance tips for developers.

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -