The time stamp counter of CPU on scheduler id 5 is not synchronized with other CPUs.

• purushotham_vandamsetty

  Grasshopper

  Points: 20

  More actions

  November 5, 2008 at 9:57 am

  #124196

  Hi, I received the following error. The time stamp counter of CPU on scheduler id 5 is not synchronized with other CPUs.

  Server details

  HP ProLiant DL585 G2 (High Performance Server)

  Amd Processor.(8)

  120 GB ram

  Windows 2003 ,64 bit ,dual node (active passive cluster)

  SQL 2005 Sp2 .

  According to microsoft doc

  http://support.microsoft.com/kb/931279

  I enabled the affinity mask for 8 processors,I still get the same error . The server is new and I am in the verge of migrating databases from SQL2000 server.How to set affinity I/o mask and is it necessary to do so?

• DB_Newbie2007

  SSCarpal Tunnel

  Points: 4438

  More actions

  March 30, 2010 at 5:50 am

  #1142088

  This is an older post (I was researching a similar issue). Check the following URL:

  http://qa.sqlservercentral.com/blogs/sql_performance/archive/2010/2/5/microsoft-sql-server-2005-cpu-scheduler-id-is-not-synchronized-with-other-cpus.aspx

  Argue for your limitations, and sure enough they're yours (Richard Bach, Illusions)