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

  • Question

  •  

    The following error messages is logged in the SQL Server error log in the production serve.Please let me know when these problems occur:

    The Version is : SQL Server 2005 Service Pack 2 (SP2)

     

    2010-12-10 18:23:28.11 Server      CPU time stamp frequency has changed from 301671 to 2401278 ticks per millisecond. The new frequency will be used.
    ////////

    2010-12-11 00:07:32.36 Server      The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs.
    2010-12-11 01:07:34.87 Server      The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs.
    2010-12-11 02:07:36.01 Server      The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs.
    2010-12-11 03:11:37.21 Server      The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs.
    2010-12-11 04:13:39.67 Server      The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs.
    2010-12-11 05:18:24.86 Server      The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs.
    2010-12-11 06:19:04.87 Server      The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs.
    2010-12-11 07:07:12.58 Server      The time stamp counter of CPU on scheduler id 1 is not synchronized with other CPUs.
    2010-12-11 07:23:45.08 Server      The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs.
    2010-12-11 08:28:24.06 Server      The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs.
    2010-12-11 09:28:49.80 Server      The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs.
    2010-12-11 10:25:16.15 Server      The time stamp counter of CPU on scheduler id 3 is not synchronized with other CPUs.
    2010-12-11 10:29:16.75 Server      The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs.
    2010-12-11 11:01:21.54 Server      The time stamp counter of CPU on scheduler id 4 is not synchronized with other CPUs.
    2010-12-11 11:34:18.64 Server      The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs.
    2010-12-11 11:48:03.24 spid1s      A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 0 seconds. Working set (KB): 103852, committed (KB): 32266496, memory utilization: 0%.
    2010-12-11 11:53:37.28 spid1s      A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 329 seconds. Working set (KB): 1941304, committed (KB): 24744688, memory utilization: 7%.
    2010-12-11 11:59:06.94 spid1s      A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 656 seconds. Working set (KB): 2105660, committed (KB): 11650664, memory utilization: 18%.
    2010-12-11 12:02:36.16 Server      The time stamp counter of CPU on scheduler id 3 is not synchronized with other CPUs.
    2010-12-11 12:38:58.85 Server      The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs.
    2010-12-11 13:43:14.93 Server      The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs.
    2010-12-11 14:48:18.44 Server      The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs.
    2010-12-11 15:48:44.23 Server      The time stamp counter of CPU on scheduler id 3 is not synchronized with other CPUs.
    2010-12-11 15:52:44.84 Server      The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs.
    2010-12-11 16:13:06.80 Server      The time stamp counter of CPU on scheduler id 4 is not synchronized with other CPUs.
    2010-12-11 16:53:32.60 Server      The time stamp counter of CPU on scheduler id 3 is not synchronized with other CPUs.
    2010-12-11 16:57:34.75 Server      The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs.
    2010-12-11 18:02:06.80 Server      The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs.
    2010-12-11 18:22:09.81 Server      The time stamp counter of CPU on scheduler id 3 is not synchronized with other CPUs.
    2010-12-11 18:34:32.97 Server      The time stamp counter of CPU on scheduler id 1 is not synchronized with other CPUs.
    2010-12-11 19:06:54.49 Server      The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs.
    2010-12-11 19:31:06.74 Server      The time stamp counter of CPU on scheduler id 3 is not synchronized with other CPUs.
    2010-12-11 20:11:28.63 Server      The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs.
    2010-12-11 21:04:05.16 Server      The time stamp counter of CPU on scheduler id 4 is not synchronized with other CPUs.
    2010-12-11 21:16:10.54 Server      The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs.
    2010-12-11 21:48:29.79 Server      The time stamp counter of CPU on scheduler id 3 is not synchronized with other CPUs.
    2010-12-11 22:16:48.91 Server      The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs.
    2010-12-11 22:24:50.90 Server      The time stamp counter of CPU on scheduler id 4 is not synchronized with other CPUs.
    2010-12-11 22:52:55.34 Server      The time stamp counter of CPU on scheduler id 3 is not synchronized with other CPUs.
    2010-12-11 23:25:30.14 Server      The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs.
    2010-12-11 23:45:41.60 Server      The time stamp counter of CPU on scheduler id 4 is not synchronized with other CPUs.
    2010-12-12 00:30:09.67 Server      The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs.
    2010-12-12 01:34:46.14 Server      The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs.
    2010-12-12 02:39:25.88 Server      The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs.
    2010-12-12 02:51:34.72 Server      The time stamp counter of CPU on scheduler id 3 is not synchronized with other CPUs.
    2010-12-12 03:44:04.33 Server      The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs.
    2010-12-12 04:24:28.77 Server      The time stamp counter of CPU on scheduler id 3 is not synchronized with other CPUs.
    2010-12-12 04:44:41.01 Server      The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs.
    2010-12-12 05:49:05.17 Server      The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs.
    2010-12-12 06:41:51.66 Server      The time stamp counter of CPU on scheduler id 3 is not synchronized with other CPUs.
    2010-12-12 06:54:00.62 Server      The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs.
    2010-12-12 07:58:26.93 Server      The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs.
    2010-12-12 08:02:27.53 Server      The time stamp counter of CPU on scheduler id 3 is not synchronized with other CPUs.
    2010-12-12 08:14:43.73 Server      The time stamp counter of CPU on scheduler id 14 is not synchronized with other CPUs.
    2010-12-12 08:59:14.65 Server      The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs.
    2010-12-12 09:15:24.70 Server      The time stamp counter of CPU on scheduler id 4 is not synchronized with other CPUs.
    2010-12-12 09:51:46.02 Server      The time stamp counter of CPU on scheduler id 3 is not synchronized with other CPUs.
    2010-12-12 10:03:48.14 Server      The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs.
    2010-12-12 11:04:20.39 Server      The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs.
    2010-12-12 11:08:29.83 Server      The time stamp counter of CPU on scheduler id 4 is not synchronized with other CPUs.
    2010-12-12 12:09:09.72 Server      The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs.
    2010-12-12 12:17:11.42 Server      The time stamp counter of CPU on scheduler id 3 is not synchronized with other CPUs.
    2010-12-12 12:29:13.35 Server      The time stamp counter of CPU on scheduler id 21 is not synchronized with other CPUs.
    2010-12-12 13:13:43.41 Server      The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs.
    2010-12-12 14:18:24.28 Server      The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs.
    2010-12-12 14:46:43.70 Server      The time stamp counter of CPU on scheduler id 14 is not synchronized with other CPUs.
    2010-12-12 15:10:58.25 Server      The time stamp counter of CPU on scheduler id 3 is not synchronized with other CPUs.
    2010-12-12 15:19:03.68 Server      The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs.
    2010-12-12 15:35:07.20 Server      The time stamp counter of CPU on scheduler id 1 is not synchronized with other CPUs.
    2010-12-12 16:23:30.10 Server      The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs.
    2010-12-12 16:43:33.10 Server      The time stamp counter of CPU on scheduler id 1 is not synchronized with other CPUs.
    2010-12-12 17:16:15.68 Server      The time stamp counter of CPU on scheduler id 4 is not synchronized with other CPUs.
    2010-12-12 17:24:18.82 Server      The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs.
    2010-12-12 18:08:47.71 Server      The time stamp counter of CPU on scheduler id 1 is not synchronized with other CPUs.
    2010-12-12 18:33:00.62 Server      The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs.
    2010-12-12 19:01:05.24 Server      The time stamp counter of CPU on scheduler id 3 is not synchronized with other CPUs.
    2010-12-12 19:13:07.04 Server      The time stamp counter of CPU on scheduler id 1 is not synchronized with other CPUs.

    could anybody have any idea to resolve this

     

    Thank you

    • Moved by Hengzhe Li Wednesday, April 20, 2011 2:23 AM Forum Cleanup (From:MSDN, TechNet, and Expression Profile and Recognition System Discussions)
    Wednesday, December 15, 2010 10:23 AM

Answers

  • This was moved out of the Profile forum.

    You could ask this question at www.answers.microsoft.com or in a SQL forum.

    Or I can move it to a specific forum if you'd like.

    This is regarding your error log:

    2010-12-10 18:23:28.11 Server CPU time stamp frequency has changed from 301671 to 2401278 ticks per millisecond. The new frequency will be used. //////// 2010-12-11 00:07:32.36 Server The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs. 2010-12-11 01:07:34.87 Server The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs. 2010-12-11 02:07:36.01 Server The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs. 2010-12-11 03:11:37.21 Server The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs. 2010-12-11 04:13:39.67 Server The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs. 2010-12-11 05:18:24.86 Server The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs. 2010-12-11 06:19:04.87 Server The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs. 2010-12-11 07:07:12.58 Server The time stamp counter of CPU on scheduler id 1 is not synchronized with other CPUs. 2010-12-11 07:23:45.08 Server The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs. 2010-12-11 08:28:24.06 Server The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs. 2010-12-11 09:28:49.80 Server The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs. 2010-12-11 10:25:16.15 Server The time stamp counter of CPU on scheduler id 3 is not synchronized with other CPUs. 2010-12-11 10:29:16.75 Server The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs. 2010-12-11 11:01:21.54 Server The time stamp counter of CPU on scheduler id 4 is not synchronized with other CPUs. 2010-12-11 11:34:18.64 Server The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs. 2010-12-11 11:48:03.24 spid1s A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 0 seconds. Working set (KB): 103852, committed (KB): 32266496, memory utilization: 0%. 2010-12-11 11:53:37.28 spid1s A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 329 seconds. Working set (KB): 1941304, committed (KB): 24744688, memory utilization: 7%. 2010-12-11 11:59:06.94 spid1s A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 656 seconds. Working set (KB): 2105660, committed (KB): 11650664, memory utilization: 18%. 2010-12-11 12:02:36.16 Server The time stamp counter of CPU on scheduler id 3 is not synchronized with other CPUs. 2010-12-11 12:38:58.85 Server The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs. 2010-12-11 13:43:14.93 Server The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs. 2010-12-11 14:48:18.44 Server The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs. 2010-12-11 15:48:44.23 Server The time stamp counter of CPU on scheduler id 3 is not synchronized with other CPUs. 2010-12-11 15:52:44.84 Server The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs. 2010-12-11 16:13:06.80 Server The time stamp counter of CPU on scheduler id 4 is not synchronized with other CPUs. 2010-12-11 16:53:32.60 Server The time stamp counter of CPU on scheduler id 3 is not synchronized with other CPUs. 2010-12-11 16:57:34.75 Server The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs. 2010-12-11 18:02:06.80 Server The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs. 2010-12-11 18:22:09.81 Server The time stamp counter of CPU on scheduler id 3 is not synchronized with other CPUs. 2010-12-11 18:34:32.97 Server The time stamp counter of CPU on scheduler id 1 is not synchronized with other CPUs. 2010-12-11 19:06:54.49 Server The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs. 2010-12-11 19:31:06.74 Server The time stamp counter of CPU on scheduler id 3 is not synchronized with other CPUs. 2010-12-11 20:11:28.63 Server The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs. 2010-12-11 21:04:05.16 Server The time stamp counter of CPU on scheduler id 4 is not synchronized with other CPUs. 2010-12-11 21:16:10.54 Server The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs. 2010-12-11 21:48:29.79 Server The time stamp counter of CPU on scheduler id 3 is not synchronized with other CPUs. 2010-12-11 22:16:48.91 Server The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs. 2010-12-11 22:24:50.90 Server The time stamp counter of CPU on scheduler id 4 is not synchronized with other CPUs. 2010-12-11 22:52:55.34 Server The time stamp counter of CPU on scheduler id 3 is not synchronized with other CPUs. 2010-12-11 23:25:30.14 Server The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs. 2010-12-11 23:45:41.60 Server The time stamp counter of CPU on scheduler id 4 is not synchronized with other CPUs. 2010-12-12 00:30:09.67 Server The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs. 2010-12-12 01:34:46.14 Server The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs. 2010-12-12 02:39:25.88 Server The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs. 2010-12-12 02:51:34.72 Server The time stamp counter of CPU on scheduler id 3 is not synchronized with other CPUs. 2010-12-12 03:44:04.33 Server The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs. 2010-12-12 04:24:28.77 Server The time stamp counter of CPU on scheduler id 3 is not synchronized with other CPUs. 2010-12-12 04:44:41.01 Server The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs. 2010-12-12 05:49:05.17 Server The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs. 2010-12-12 06:41:51.66 Server The time stamp counter of CPU on scheduler id 3 is not synchronized with other CPUs. 2010-12-12 06:54:00.62 Server The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs. 2010-12-12 07:58:26.93 Server The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs. 2010-12-12 08:02:27.53 Server The time stamp counter of CPU on scheduler id 3 is not synchronized with other CPUs. 2010-12-12 08:14:43.73 Server The time stamp counter of CPU on scheduler id 14 is not synchronized with other CPUs. 2010-12-12 08:59:14.65 Server The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs. 2010-12-12 09:15:24.70 Server The time stamp counter of CPU on scheduler id 4 is not synchronized with other CPUs. 2010-12-12 09:51:46.02 Server The time stamp counter of CPU on scheduler id 3 is not synchronized with other CPUs. 2010-12-12 10:03:48.14 Server The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs. 2010-12-12 11:04:20.39 Server The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs. 2010-12-12 11:08:29.83 Server The time stamp counter of CPU on scheduler id 4 is not synchronized with other CPUs. 2010-12-12 12:09:09.72 Server The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs. 2010-12-12 12:17:11.42 Server The time stamp counter of CPU on scheduler id 3 is not synchronized with other CPUs. 2010-12-12 12:29:13.35 Server The time stamp counter of CPU on scheduler id 21 is not synchronized with other CPUs. 2010-12-12 13:13:43.41 Server The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs. 2010-12-12 14:18:24.28 Server The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs. 2010-12-12 14:46:43.70 Server The time stamp counter of CPU on scheduler id 14 is not synchronized with other CPUs. 2010-12-12 15:10:58.25 Server The time stamp counter of CPU on scheduler id 3 is not synchronized with other CPUs. 2010-12-12 15:19:03.68 Server The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs. 2010-12-12 15:35:07.20 Server The time stamp counter of CPU on scheduler id 1 is not synchronized with other CPUs. 2010-12-12 16:23:30.10 Server The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs. 2010-12-12 16:43:33.10 Server The time stamp counter of CPU on scheduler id 1 is not synchronized with other CPUs. 2010-12-12 17:16:15.68 Server The time stamp counter of CPU on scheduler id 4 is not synchronized with other CPUs. 2010-12-12 17:24:18.82 Server The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs. 2010-12-12 18:08:47.71 Server The time stamp counter of CPU on scheduler id 1 is not synchronized with other CPUs. 2010-12-12 18:33:00.62 Server The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs. 2010-12-12 19:01:05.24 Server The time stamp counter of CPU on scheduler id 3 is not synchronized with other CPUs. 2010-12-12 19:13:07.04 Server The time stamp counter of CPU on scheduler id 1 is not synchronized with other CPUs.

     

    Thanks!


    Ed Price a.k.a User Ed, Microsoft Experience Program Manager (Blog, Twitter, Wiki)
    Wednesday, November 30, 2011 9:00 AM