Skip to Content

SQL message The time stamp counter of CPU on scheduler id 5 is not synchron

Hello.

I receive the following message in the SQL error log few times a day:

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

There are quite a few posts on the internet @SQL community forum and look like this is not an error message, it is an information message and have no impact on SQL system performance. Any comments from anyone!!!!!

BTW I am running SQL2005 with SP02 on ECC 6.0 platform.

Best regards,

Phuong.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Sep 19, 2008 at 02:28 PM

    Hi,

    this message means that the high performance counter on the CPUs are out of sync. These counters are controlled by the HAL of your system. Ask your hardware vendor for an updated version.

    You might ignore this message, as it has no direct impact on the performance of the system. But the performance counter, that the system and SQL Server are collecting, are no longer trustworthy. We have seen negative query runtimes caused by this, as the query starts on one CPU and ends on the other CPU. If the query runtime now is smaller than the time gap, the runtime might become negative.

    You can see this in the R/3 as well. Check ST06 -> detailed analysis -> Hardware info -> system.

    Regards

    Clas

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Phuong Luu

      Hi.

      I'm facing the same problem after applying SP2 for SQL2005.

      I've also applied affinity mask but it didn't work. If your processor AMD Opteron processors, it's said to be a solution from AMD...