Results 1 to 2 of 2

Thread: processor allocation

  1. #1
    Join Date
    Sep 2002
    Location
    MASS
    Posts
    79

    processor allocation

    I was wondering, is there a way to allocate processors to SQL2000. I have a server that has 4 processors, I would like to leave one just for the operating system and have SQL2000 use the other 3. Is this possible and do you think it would be recomended to do this? Or should i just leave the 4 processors for everything?

    thanks in advance

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Yes, you can do it in em -> server properties -> processors tab or with sp_configure.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •