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.

Vidya

Hi,

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

Thanks,
Vidya Harnal

AndrewWoody

Vidya,

I have not seen this on a SQL 2008 installation. Have you tried installing the latest SP and if this is stil not working the latest hotfix/updates?

Andrew

Vidya

Hi Andrew,

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

Thanks,
Vidya

Agile Sharepoint development by 21apps and Andrew Woodward MVP