Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Location
    AR, USA
    Posts
    2

    Question Unanswered: 2nd Processor not detected.

    I have MS SQL 2000 Standard edition licensed in "per device" mode on a dual xeon. However the properties->Processor tab on EM only list 1 cpu (CPU 0) and has "use all available processors" selected and the use [#] is greyed out.

    Anybody else experience this? Is it really using both processors? Or do I have some limited product key? I called MS tech support but they were like, "um that'll be $295 to open a support instance" <*click*>.

    SQL 2000 Standard Ed. SP3a

    Thanks!

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    You sure your looking at the right box?

    Even if they limited you, how would they know which CPU you wanted to use?

    Let say you had a different process dedicated to CPU 0...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Sep 2003
    Location
    Columbia, MD USA
    Posts
    95
    first thing to look at is that your Windows actually sees both processors, if you added the processor after installing Windows you may be using the Uniprocessor kernel, in which case Windows and SQL Server would only see one proc... kind of hard to say without knowing more about your system
    drew
    ------------------
    http://wjtechnologies.com

Posting Permissions

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