Event ID: 17896

Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17896
Description:

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







Check the Links Below;
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/default.aspx?scid=kb;en-us;931279

CPU number	Statements to enable processor affinity
02 CPUs	exec sp_configure 'affinity mask', 0x00000003 GO reconfigure GO
04 CPUs	exec sp_configure 'affinity mask', 0x0000000F GO reconfigure GO
08 CPUs	exec sp_configure 'affinity mask', 0x000000FF GO reconfigure GO
16 CPUs	exec sp_configure 'affinity mask', 0x0000FFFF GO reconfigure GO
32 CPUs	exec sp_configure 'affinity mask', 0xFFFFFFFF GO reconfigure GO