Sharepoint indexing and 100% cpu sqlservr.exe

Turns out indexing for sharepoint search was set to reindex every 5 minutes, causing 100% cpu on sqlservr.exe. This in turn slowed down the sharepoint portal significantly.

To set reindexing of sharepoint search to a more sensible time (out of hours) open up sharepoint central administration on your sharepoint server. In “Farm Topology” click on the server name that is running “Windows SharePoint Services Search”. Now click on “Windows SharePoint Services Search” in the list that pops up. Now go to the “Indexing Schedule” section and set the indexing schedule to something sensible, like daily between 12am and 12:15am (or whenever the server is not being heavily used).

2 thoughts on “Sharepoint indexing and 100% cpu sqlservr.exe

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>