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

• John Reidy

  SSC Rookie

  Points: 40

  More actions

  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.

• hendra-880128

  Valued Member

  Points: 58

  More actions

  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 ?

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  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