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