Thursday 3 January 2008

Reporting of CPU Drift (SQL 2005 SP2)

From the sql logs of a standalone AMD Operteron 2218 server running SQL 2005 SP2.

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

Really not much we can do about this.
The answer appears to be to prevent changes in CPU frequency by disabling the power saving options on the box.
Not a very GREEN solution, and not one conducive to saving money on data center power consumption.

http://blogs.msdn.com/psssql/archive/2006/11/27/sql-server-2005-sp2-will-introduce-new-messages-to-the-error-log-related-to-timing-activities.aspx

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

No comments: