Post reply

Howto Add Processor on MSSQL

  • March 15, 2004 at 8:00 pm

    #359302

    Please, Anyone help me. I want to add processor to enterprise manager . In case I checked Processor on enterprise manager (MSSQL Server Enterprise) have 1 processor but on machine have 2 processor.

    thank you for advise me.

  • March 16, 2004 at 3:05 am

    #498916

    Are you in version 7?

    If yes, check PSS ID Number: 273880 on MSDN.

  • March 16, 2004 at 7:09 pm

    #499056

    I'm use MSSQL2000 enterprise

  • March 17, 2004 at 9:16 am

    #499143

    First, make sure the OS is seeing it correctly.  If you added the second processor after the OS was installed, you may need to update HAL so that it correctly sees the second processor.  

    NOTE:  Some of the new processors are hyperthreaded and the OS reports that as two processors when in fact there is only one physical processor.  (I have a dual processor box and when I pull up the Task Manager and look at the Performance tab--it shows 4 CPU's)   

    In Enterprise Manager, if you select your SQL server and choose Properties and go to the Processor tab, do you see more than one processor listed?  If so, do they have check marks in the boxes?

    Also, in the section just below this which item is checked:

    a) Use all available processors or b) use X processors?

    Shawn

    Accepting all invites

  • March 17, 2004 at 6:58 pm

    #499239

    Hi, swjohnson

    on office setup mssql2000 enterprise  2 site and all both site use cpu pentium III Xeon 2 cpu (physical) and performance to show 2 processor. I suspect on enterprise mssql2000 one site to show 2 processor and other site to show 1 processor (machine have 2 processor). I want to add cpu to enterprise mssql2000 manager to show 2 processor.

    thank you everyone to advise me.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply