SQL Server Performance


Discussion in 'Performance Tuning for Hardware Configurations' started by Raulie, Jan 28, 2004.

  1. Raulie New Member

    I upgraded our server to 2 processors. SQL Server was originally installed to run under 1 processor. In the properties tab it still reads 1 processor. How can I make it read 2 processors?
  2. Twan New Member

    what type of server is it? On some servers you also need to run an upgrade on the driver software, since the hal is different for a uni-processor versus a multi-processor box. You'd have to check with the hardware vendor on what is required...

    are both processors showing up in Perfmon/task manager?

  3. Luis Martin Moderator

    If task manager see two processor, then try to reinstall last SP.

    Luis Martin
  4. Raulie New Member

    The processor is showing under perfmon. I think when SQL Server was installed it was under 1 processor license.
  5. Luis Martin Moderator

    That could be the razon. Check if was per processor or WS.

    Luis Martin
  6. Raulie New Member

    Per Processor. How do I reset it. He have licenses for each processor.
  7. Luis Martin Moderator

    In Windows 2000, Settings, Administrative tools, licensing.


    Luis Martin

Share This Page