Thursday, May 28, 2009

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 numberStatements to enable processor affinity
02 CPUsexec sp_configure 'affinity mask', 0x00000003
GO
reconfigure
GO
04 CPUsexec sp_configure 'affinity mask', 0x0000000F
GO
reconfigure
GO
08 CPUsexec sp_configure 'affinity mask', 0x000000FF
GO
reconfigure
GO
16 CPUsexec sp_configure 'affinity mask', 0x0000FFFF
GO
reconfigure
GO
32 CPUsexec sp_configure 'affinity mask', 0xFFFFFFFF
GO
reconfigure
GO

1 comment:

  1. Hey There. I found your blog using msn. This is a very well
    written article. I'll be sure to bookmark it and come back to read more of your useful info.
    Thanks for the post. I'll certainly return.

    my web blog: please click for source []

    ReplyDelete

 
span.fullpost {display:inline;}