Post reply

SQL Server 2005 not using all CPU in multiprocessor (peak on 1 cpu alternatively)

  • August 12, 2010 at 6:56 am

    #1205970

    Hi this is interesting.

    I looked at a database today, the DB is around 4gb in size, running on a physical box.

    It has a single database, 8 CPU and 16Gb of memory.

    Only 1 cpu is being used by SQL Server. performance is pegged at 13% ie 1 cpu in use.

    This sounds like your problem, if memory was reduced the other cpus might be used.

  • April 6, 2011 at 1:35 am

    #1307838

    Hi...

    I'm having similiar problem with this...

    My server using 4 core CPU & 8 GB memory

    using windows server 2003 std edition x64

    SQL Server 2005 SP 2

    but why when i run long running SP, they only use 1 core CPU that peak 100%

    and the other cpu is idle, max cpu usage only 25% ??

    I've check the server affinity is checked & all procesor core already checked..

    what's wrong with this ? why it only use 1 core procesor ?

    any insight ?

  • April 6, 2011 at 2:16 am

    #1307851

    Please post new questions in a new thread. Thank you.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 3 posts - 16 through 17 (of 17 total)

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