Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I've been reading up on how to tune SQL Server 2005 for a machine in a test environment. I came across this article on technet which suggests how to configure "server tasking" and says I should refer to the Windows 2003 docs for more info.

I have googled Windows 2003 "server tasking" (with and without the quotes) but all I can find is more similar articles on SQL server telling me that it should be configured, not how/where you do it.

I know I'm probably searching for the wrong thing - can someone please tell me how to configure it in Windows or SQL server, whichever it is?

share|improve this question
add comment

2 Answers

up vote 1 down vote accepted

Whoever wrote that used the wrong (or an uncommon) term. It's "processor scheduling."

share|improve this answer
    
It's also called server tasking: technet.microsoft.com/en-us/library/ms176012(SQL.90).aspx –  joeqwerty Mar 2 '11 at 14:51
    
But is it called that anywhere outside of the SQL documentation? I only ask because I've never heard that term until reading this question and the linked docs. –  mfinni Mar 2 '11 at 14:55
1  
Lol - In that case I know exactly what it is! The line "When you run SQL Server Setup, server tasking is set to none in Windows Server 2003" confused me, because there is no "none" in the processor scheduling settings. I take it this is wrong? –  simon Mar 2 '11 at 15:12
    
Like you, I've never seen it referenced anywhere outside of SQL. –  joeqwerty Mar 2 '11 at 15:41
    
And they all look like different revisions of the same document. I bet the person who first wrote this SQL doc in the NT 4.0 days translated something into English incorrectly, and the term was never corrected. –  mfinni Mar 2 '11 at 15:48
add comment

I can't really answer your question directly but when I use Help and Support on one a Server 2003 machine and search for server tasking it locates 25 Knowledge Base articles, so I'm guessing some of those might have your answers.

The following 24 KB articles were found through Help and Support (the 25th was about Win98). I don't know how many are really relevant but I'll leave that up to you to determine.

  • KB121594
  • KB102061
  • KB101709
  • KB970821
  • KB118677
  • KB109228
  • KB111405
  • KB107245
  • KB2272146
  • KB103810
  • KB124838
  • KB101781
  • KB102987
  • KB140372
  • KB135899
  • KB293513
  • KB86290
  • KB90227
  • KB103435
  • KB72182
  • KB71300
  • KB85394
  • KB85419
  • KB96418
share|improve this answer
    
Unfortunately my test rig is not allowed to have any connection to the internet at present (not my rules). Is it possible you could figure out the links to a couple of these and post them? –  simon Mar 2 '11 at 11:51
    
@simon, I'll have a look in the morning (it's 11:06PM here), although by then someone else may already have answered you question. –  John Gardeniers Mar 2 '11 at 12:06
    
@Simon, answer updated. –  John Gardeniers Mar 2 '11 at 20:42
    
Come on man - this site can't be linkdump-and-run :-) –  mfinni Mar 2 '11 at 21:01
    
@mfinni, if I understood the problem (not my area) and had the time to delve deeply into those articles I would do so. As it is I'm merely trying to offer a pointer in a direction that might be useful. It's not like this question has been overwhelmed with better answers. –  John Gardeniers Mar 3 '11 at 3:42
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.