SQL Server Performance

Problem with Dual Core Processor...

Discussion in 'Performance Tuning for Hardware Configurations' started by JuanP, Sep 6, 2006.

  1. JuanP New Member

    Hi,
    I'm running a SQL Server 2000 in a server that has an AMD Athlon 64 Dual Core 4200+ Processor. When configuring SQL Server at Processor Control tab, if I assign both processors then I get a performance downgrade. Even sometimes one of the "cores" gets CPU Utilization at 100% while the other one is at an average rate of utilization.
    Hard disk has 50GB capacity with 41GB free.

    Do any of you have any idea of what might be happening?

    Thanx,

    JP
  2. Luis Martin Moderator

    What OS do you have?
    What SQL sp do you have?


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All in Love is Fair
    Stevie Wonder


    All postings are provided “AS IS” with no warranties for accuracy.



  3. JuanP New Member

    SO: W2K3
    SQL SERVER 2000 SP4

    JP
  4. Luis Martin Moderator

    Just a thougth.
    Did you try with one processor for paralelism?


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All in Love is Fair
    Stevie Wonder


    All postings are provided “AS IS” with no warranties for accuracy.



  5. joechang New Member

    i am thinking you have a very bad execution plan and parallelism makes it worse

Share This Page