Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003
    Location
    san francisco
    Posts
    14

    Unanswered: multiprocessor environment

    Folks,
    We're running Microsoft SQL-2000 server
    in a multiprocessor environment. (quad processor box)
    Can we force different jobs that are
    scheduled concurrently to use a particular
    processor.
    What we would like to do is run 4 separate
    jobs, scheduled for the same time, and force
    each job to use a different processor on a
    quad processor database server host.
    Is it possible to do this at all with SQL-2000.

    Thanks in advance

  2. #2
    Join Date
    Dec 2002
    Location
    Antwerp, Belgium
    Posts
    227
    I think you can only configure which processors will be used by SQL Server. The server itself will assign every thread that runs to a processor based on the priority.
    Johan

Posting Permissions

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