SQL Maintenance Plans and MOSS give 100% CPU error

Posted on July 7, 2007 by Andrew Woodward

Andrew Bridgeman recently emailed me about an issue he had encountered with his internal MOSS 2007 deployment.    He had implemented the out of the box maintenance plans using the wizards and initially all was well with the world.  He only realised there may be a problem when the portal became unresponsive,and on investigation this was down to SQL Server running at 100% CPU and the crawler stuck on “crawling full”.

Other people have had this or similar problems and Mike Hanley found a solution to this here.

The good news is that this has been resolved with SQL 2005 SP2  – as detailed in the Microsoft KB article http://support.microsoft.com/kb/930887

The other benefit to using SP2 is the improved integration with Reporting Services as detailed by Lawrence

This entry was posted in SharePoint and tagged , . Bookmark the permalink.
  • Vidya

    Hi,

    We are having the same issue with SQL 2008, is there a solution for it?

    Thanks,
    Vidya Harnal

  • http://www.21apps.com AndrewWoody

    Vidya, The post details the KB article that solves this problem.

    Andrew

  • Vidya

    Hi Andrew,

    We have SP1 for SQL 2008, i will check if there are any hotfixes available after this.

    Thanks,
    Vidya