SQL Server Performance

Only one CPU core is maxed out

Discussion in 'SQL Server 2008 Performance Tuning for DBAs' started by Narine, Jun 22, 2009.

  1. Narine New Member

    Hi experts,
    We've got 2-dual core AMD processor server running SQL server 2005 Standard SP3. OS is Windows 2003 Enterprise SP2.
    Only one CPU core is constantly pegged at 100% where as the other 3 are averaging 50-60%.
    SQL server is the only application installed so it does seem to utilize all cpu cores, however only one is maxed out.
    Affinity Mask is set to 0
    Any idea what might be chewing up that one core?
    Narine, Jun 22, 2009
    #2

  2. Luis Martin Moderator

    Is normal. I see that in severals servers. Now, what kind of AMD do you have?. Not all works fine with 2003.
    Luis Martin, Jul 13, 2009
    #3

  3. Narine New Member

    Thanks for the reply, Luis. It's got AMD Opteron /2.60GHz.
    Narine, Jul 13, 2009
    #4

  4. Luis Martin Moderator

    Luis Martin, Jul 14, 2009
    #5

  5. RickNZ New Member

    With some device drivers, all interrupts are handled by a single CPU core. That can cause the behavior you describe.
    I believe this issue was addressed/improved in Windows 2008.
    RickNZ, Jul 29, 2009
    #6

Share This Page