none
CPU spikes RRS feed

  • Question

  •  We have a new server running sql 2008, SP1 (WindowsServer2008 R2). When the instance is running, the cpu usage bounces from 1-4 percent to 85-90 percent. This is a new instance, no one is running any queries on it and there aren't any jobs running on it. If the instance is stopped, the cpu usage drops to and stays around 0-1 percent. Why would just having the instance started cause these spikes?

    Tuesday, March 23, 2010 1:53 PM

Answers

All replies

  • Hello,

    Please install CU2 for SQL Server 2008 SP1. That cumulative update has a fix for memory usage increase. See the following link for more information:

    http://support.microsoft.com/kb/961811

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Wednesday, March 24, 2010 3:43 AM
    Moderator
  • I tried CU7, wouldn't that have included this fix also?
    Wednesday, March 24, 2010 1:37 PM
  • Hello,

    Yes, it is included. Every new cumulative contains all the hot fixes and security fixes that were included in previous cumulative updates for that service pack.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Wednesday, March 24, 2010 2:59 PM
    Moderator
  • Hi sqlguy10,

    Does that issue occurs again?

    If you see it again, please try using SQL Server Profiler from "Tools" menu item of SQL Server Management Studio to trace what happened.

    Regards,
    Tom Li - MSFT
    Thursday, March 25, 2010 6:08 AM
    Moderator
  • I tried the SQL Server Profiler and it showed no activity.   But as long as the database was started, the CPU had spikes (stop the database and the spikes stopped).    We're reloading to a previous OS (prior to R2, it's only the R2 release that we are having problems with, other Windowserver2008 servers aren't having this problem).
    Thursday, April 1, 2010 2:12 PM
  • we moved to a different server and that appeared to resolve the issue.  
    • Marked as answer by sqlguy10 Monday, April 19, 2010 1:00 PM
    Monday, April 19, 2010 1:00 PM