Home > Event Id > Event Id 17896 The Time Stamp Counter

Event Id 17896 The Time Stamp Counter

Also, could anybody from MS have any idea as to the release date of SP2 ( Non CTP) Saturday, February 17, 2007 1:12 AM Reply | Quote Answers 0 Sign in 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.aspxhttp://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 Skip to Content Open navigation Account Settings Notifications Followed Activities Logout Search Your browser does not support JavaScript. Could somebody tell me what is the impact of these on the performance? http://blackplanetsupport.com/event-id/event-id-17896-the-time-stamp-counter-of-cpu.html

However, the question is, can we live with that error in a production environment or should I try to Reinstall sql 2005 and SP1 to get rid of the error? This message appears in the SQL Server log every hour accross 3-4 diff scheduler ID's and it changes from 2 - 13.I've done some research and I'm familar withthe following.http://blogs.msdn.com/psssql/Default.aspx?p=2http://support.microsoft.com/kb/931279This is Posted by: Eric (Er…@discussions.microsoft.com) Date: Tue, 20 Nov 2007 server pop out same msg every hour, any idea ? x 5 Stefan Vogel See ME931279 for information about this event.

x 2 Private comment: Subscribers only. Any thoughts on doing this? You can also search on this site for several forums about HTIn *all* cases the real answer is TEST,TEST,TEST... Since dual procs don't share caches we shouldn't see this behavior.

Terms of Use. You cannot post HTML code. See example of private comment Links: ME931279, ME938448, Event ID 17895, SQL Server Pro Search: Google - Bing - Microsoft - Yahoo - EventID.Net Queue (0) - More links... Did you ever find a good answer?Thanks,Keith Post #380841 DB_AndrewDB_Andrew Posted Wednesday, July 11, 2007 12:39 PM Valued Member Group: General Forum Members Last Login: Friday, September 26, 2014 3:25 PM

You cannot post IFCode. In that case Affinity mask = decimal value of binary string ( 1111110000000000 ) = 64512 Affinity I/O Mask = decimal value of binary string ( 0000001111111111 ) = 1023 Every Enable Network Connection for MSDE View MAC Address(es) and IP Address of devices con... Regards Gavin McMillan 0 Comment Question by:gavinandrewmcmillan Facebook Twitter LinkedIn https://www.experts-exchange.com/questions/23118367/The-time-stamp-counter-of-CPU-on-scheduler-id-2-is-not-synchronized-with-other-CPUs-MSSQL-Event-ID-17896.htmlcopy LVL 39 Best Solution byBrandonGalderisi Check out this: 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 Go to Solution 2 2 3 Participants BrandonGalderisi(2 comments) LVL 39

Sunday, February 25, 2007 6:55 AM Reply | Quote 0 Sign in to vote Appreciate your feedback, you might have know SP2 for SQL 2005 is released now. You cannot delete other events. A12: That is correct. Maybe someone else can jump in here.--Merv Porter [SBS-MVP]============================Post by EricHi Merv,1.

Thursday, July 26, 2007 6:33 PM Reply | Quote 0 Sign in to vote I found the same error on the production servers. All Rights Reserved. SQL Server Detailed Memory Usage Information. You cannot delete other posts.

During Abap import - out of 28 package 26 of them have been completed. weblink but how do we fix the error?   I have a Quad 64IA server with the affinities set correctly and see this happen almost like clockwork. Index(es): Date Thread Flag as inappropriate (AWS) Windows Science Usenet ArchiveAboutPrivacyImprint www.tech-archive.net >Archive >Windows >microsoft.public.windows.server.sbs >2007-11 Log in :: Register :: Not logged in Home Tags Articles Editorials It's informational message.

CPU(s) operating at reduced performance level due ... Post #380876 noeldnoeld Posted Wednesday, July 11, 2007 2:28 PM SSCertifiable Group: General Forum Members Last Login: Wednesday, October 19, 2016 9:27 AM Points: 6,262, Visits: 2,048 Great. Thanks for any help.. ---------------------------------------------------------------------- Event Type:Information Event Source:MSSQL$MICROSOFT##SSEE Event Category:(2) Event ID:17896 Date:11/20/2007 Time:5:47:19 AM User:N/A Computer:HQ Description: The time stamp counter of CPU on scheduler id 1 is not http://blackplanetsupport.com/event-id/win32-time-event-id-29.html it's not an AMD issue.

I need to have some good evidence to convince our Sys admins to make any changes to the server configuration. Privacy Policy. This issue seems to have corrected itself.

x 10 Anonymous Users of AMD processors may wish to read ME938448 before ME931279.

SQL Server timing values may be incorrect when you use utilities or technologies that change CPU frequencies http://support.microsoft.com/default.aspx?scid=kb;en-us;931279 -- Merv Porter [SBS-MVP] ============================ "Eric" wrote in message news:[email protected] server pop You cannot post topic replies. All rights reserved. Tuesday, July 17, 2007 8:20 AM Reply | Quote 0 Sign in to vote To set the affinity for your server goto the "Processors" section of that server's "Server Properties" in

PRTG is easy to set up &use. However, the HP Dynamic Power Savings Mode and the OS Control Mode (a.k.a Disabled on some servers) settings might cause such symptoms. Wednesday, March 26, 2008 3:32 PM Reply | Quote 0 Sign in to vote Information from HP on the issue:   http://h20000.www2.hp.com/bizsupport/TechSupport/Document.jsp?lang=en&cc=us&objectID=c01111801&jumpid=reg_R1002_USEN   HP ProLiant ML/DL/BL Servers - "The Time Stamp his comment is here Glossary Terms CPU ID POP 4D File Types .c .o Terms Explained 45 Event Scheduler Time CPU on scheduler id 1 is not synchronized with other CPUs.

Learn more about SAP Q&A. Sunday, February 18, 2007 2:15 PM Reply | Quote Moderator 0 Sign in to vote Thanks for your response. I even see these message in the SQL logs when I start up SQL server like after an update re-boot. Is anyway can use stored procedures to control cpu synchronizeThanks for the help.EricPost by Merv Porter [SBS-MVP]Any help here?SQL Server timing values may be incorrect when you use utilities ortechnologies that

Hopefully SP3 will fix this, although I have CU10 so I'll wait a bit to upgrade. Wednesday, February 11, 2009 10:43 PM Reply | Quote Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. You cannot post new polls. Wednesday, March 28, 2007 2:17 PM Reply | Quote 0 Sign in to vote We are also seeing this message on our server and have the following configuration.   OS -

Afinity Mask and Affinity I/O mask are Mutually exclusive. Comments: Anonymous See the link to SQL Server Pro website for a short article about this issue.