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.
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.