SQL Maintenance Plans and MOSS give 100% CPU error

Saturday, July 7th, 2007

Posted in SharePoint | Comments

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 on Saturday, July 7th, 2007 at 10:09 am and is filed under SharePoint. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.