Error:120 Process threads waiting for more than 500ms

• jesijesijesi

  Right there with Babe

  Points: 761

  More actions

  July 11, 2010 at 4:16 am

  #141028

  Hi Guys,

  I am receiving the below error on my sql server error logs.

  Error:120 Process threads waiting for more than 500ms

  Its sql server 2005 9.00.4220.00 (X64), running on windows 2003 64bit.

  Thanks,

  jesi

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736270

  More actions

  July 11, 2010 at 8:55 am

  #1191216

  I haven't seen this, but it looks like a CPU bottleneck. Do you have parallelism enabled (MAXDOP)? Is the CPU saturated when this occurs?