SharePoint 2010: crawl database is too large

SharePoint 2010: crawl database is too large

This Wiki page contains best practices regarding the size of the crawl database. The crawl database stores the crawl data (time/status, etc.) about all items that have been crawled. Use the following formula to calculate it's average size:

Crawl: 0.046 × (sum of content databases)

For more info: http://thebitsthatbyte.com/calculating-sharepoint-2010-search-administration-crawl-and-property-database-sizes/

There are some built in heath analyzer rules that can assist you in reducing the size of your crawl database. Run the health analyzer rule Search - One or more crawl databases may have fragmented indices. If it reports that you have a high percentage of fragmented indices then you can have the health rule fix the fragmented indicies automatically.

For more info: http://technet.microsoft.com/en-us/library/cc262731.aspx

The crawl database can contain huge amounts (literally 10s of GBs) of empty space. You need to truncate the log file, restore the crawl database or possibly rebuild the crawl database.

For more info: http://www.aiim.org/community/blogs/expert/Is-your-search-database-bloated

 

Leave a Comment
  • Please add 2 and 5 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • Maheshkumar S Tiwari edited Revision 5. Comment: Added Tag

  • Gokan Ozcifci edited Revision 4. Comment: http insert  

  • bass_player edited Revision 3. Comment: Removed the "turn on Auto Shrink" after rebuilding the crawl database

  • Margriet Bruggeman edited Revision 2. Comment: added

  • Margriet Bruggeman edited Revision 1. Comment: added

  • Margriet Bruggeman edited Original. Comment: added

Page 1 of 1 (6 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Margriet Bruggeman edited Original. Comment: added

  • Margriet Bruggeman edited Revision 1. Comment: added

  • Margriet Bruggeman edited Revision 2. Comment: added

  • bass_player edited Revision 3. Comment: Removed the "turn on Auto Shrink" after rebuilding the crawl database

  • Gokan Ozcifci edited Revision 4. Comment: http insert  

  • Maheshkumar S Tiwari edited Revision 5. Comment: Added Tag

Page 1 of 1 (6 items)