I have a SharePoint 2010 farm consisting of front end (for users to access), a back end (for backups and crawling) and a dedicated SQL 2005 server with four processors. When the crawl occurs, the processor utilization for the SQL server goes to 100% or near 100% and will stay there until the crawl is done. When we had SharePoint 2007, the SQL server rarely got above 30%. What can I do to adjust this so that it does not consume so much on the SQL Server.
View Complete Post