Welcome to MSDN Blogs Sign in | Join | Help

10 Things To Optimize your SharePoint Server Indexing

1) Put your Search db and on separate disks transaction logs, both the fastest most optimized disks with fast optimized spindles for writing (dedicated disks are essential)
2) Optimize your temp db: grow it, give it space, you can even split it into multiple dbs and ensure it is on the most optimized disks  (dedicated disks are essential).  Don’t forget to optimize the transaction logs of the temp db either!
3) Optimize the network between the servers you are indexing and the index server (GB NIC speed is preferred within a farm)
4) Consider topology changes to optimize network throughput and eliminate double hops (Index server crawling a separate front end (shared by user traffic) to pull changes.  Adding the WFE role to your Index server and adding applicable host files is a great way to optimize the indexing and optimize your traffic at the same time.
5) Increase the your RAM on your x64 SQL Servers (8 GB is really a good place to start, 16 GB or more is looking better and better.)
6) Defragment your databases, and applicable drives (if fragmented) and run relevant dbcc consistency checks - Refer to KB on SharePoint Safe DBCC commands
7) Increase the # of crawl threads (you’ll have to watch this, it is the easiest way to speed up your crawls, but watch the box it is "attacking" it can be heavy handed.)
8) Reduce the maximum index file size (optional)
9) Remove any unused, single threaded and poor performing ifilters
10) Reduce the amount of full indexes, run incremental crawls on a schedule where they can complete, and remove non essentials such as every 5 minute incremental jobs these will simply cause unnecessary churn.

Bonus: Install the public update or the service pack when it comes out (includes a few SharePoint Indexing related fixes). 

More on disk optimization on a post I did a while back...   Also there's a great paper that just got posted on storage and performance optimization.  It is a MUST READ.  Performance recommendations for storage planning and monitoring.

Getting crawled and you don't want to?  Here's a recent KB on how to configure the robots.txt in your SharePoint deployment.  There is some more info in this post from the field.  It is very easy to have 50% of traffic as the crawl account.  Optimizing the indexing by reducing even authentication traffic is a big deal.  Use accounts that are in the same domain and where the DCs are fast and local if using NTLM.  Kerberos might end up being slightly faster, but does add complexity.

Published Wednesday, December 05, 2007 11:54 AM by Joel Oleson

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

Thursday, December 06, 2007 2:48 PM by Victor Shamanovsky

# re: 10 Things To Optimize your SharePoint Server Indexing

"Increase the your RAM on your x64 SQL Servers (8 GB is really a good place to start, 16 GB or more is looking better and better.)"

Is there a good reference for this assertion anywhere? I am having a hard time convincing my dba to allocate more ram, currently stuck at 2 gigs (x86)

Thursday, December 06, 2007 5:32 PM by Joel Oleson

# re: 10 Things To Optimize your SharePoint Server Indexing

2GB is tight.  Is it a small environment?  4GB will allow SQL to breath a little.  At that size with a bit of load the SQL error logs should say out of memory if you upload a huge file.  I want to get back into the -g startup switch for SQL recommendations, but at 2GB it's tough.  Look for a storage whitepaper coming out very soon.

Saturday, December 08, 2007 4:17 PM by imorrish

# re: 10 Things To Optimize your SharePoint Server Indexing

With regard to #6, also look at

How to defragment Windows SharePoint Services 3.0 databases and SharePoint Server 2007 databases

http://support.microsoft.com/kb/943345/  

Monday, December 10, 2007 8:50 AM by Liam

# re: 10 Things To Optimize your SharePoint Server Indexing

To optimize indexing performance, does it help by moving the index file from say C drive (System drive) to D drive (data drive)? Does it make any sense by installing SharePoint directly on D drive? Thanks.

Tuesday, December 11, 2007 12:03 PM by SharePoint, SharePoint and stuff

# SharePoint Kaffeetasse 35

OT: Dateiverzeichnisse synchronisieren mit SyncToy Microsoft SyncToy 2.0 Beta Artikel zu den Dokument-Konvertern

Tuesday, December 11, 2007 12:07 PM by Joel Oleson

# re: 10 Things To Optimize your SharePoint Server Indexing

It is a good practice to split your logs from your system drive.  They get very large and optimization would help your crawl speed by optimizing those disks.  Whether this means disk speeds or more spindles or ... optimizing for fast writes will help your disk speeds.

Tuesday, December 11, 2007 12:08 PM by Joel Oleson

# re: 10 Things To Optimize your SharePoint Server Indexing

It is a good practice to split your index from your system drive.  They get very large and optimization would help your crawl speed by optimizing those disks.  Whether this means disk speeds or more spindles or ... optimizing for fast writes will help your disk speeds.

Don't worry so much about the binaries, but the index is a priority to put on not just a different partition, but separate disks if possible.

Sunday, December 23, 2007 5:06 PM by Blog del CIIN

# WSS 3.0 & MOSS: Recopilación de enlaces interesantes (XII)

Una vez más, en esta nueva entrega recogemos el recopilatorio de enlaces, recursos y diferentes elementos

Thursday, December 27, 2007 6:19 AM by Zlatan's Blog

# Merry Christmas and Happy New 2008...My gift is some great SharePoint articles to read over the holidays

First of all Merry Christmas to everyone who reads this blog and happy upcoming New 2008 from me and

Saturday, December 29, 2007 8:25 AM by Owner Blog

# Merry Christmas and Happy New 2008...My gift is some great SharePoint articles to read over the holidays

First of all Merry Christmas to everyone who reads this blog and happy upcoming New 2008 from me and

# Some interesting Resources for SharePoint Planning...

I would like to share with you some interesting links about SharePoint Planning...Most of them from Joel's

Tuesday, February 19, 2008 11:32 AM by jpbaker81

# re: 10 Things To Optimize your SharePoint Server Indexing

Hello;

I had a question regarding this suggestion

7) Increase the # of crawl threads (you’ll have to watch this, it is the easiest way to speed up your crawls, but watch the box it is "attacking" it can be heavy handed.)

Is this a setting in IIS, or a web.config file?

Wednesday, October 22, 2008 7:06 AM by Alex blog about Microsoft

# Top SharePoint Storage Resources by Joel Oleson

Thanks to Joel we have a resource list for SharePoint storage. A part of the blog article contains whitepapers

Leave a Comment

(required) 
required 
(required) 

  
Enter Code Here: Required
 
Page view tracker