I was recently looking over the settings for a server (Windows 2003 SP2) that is used exclusively as the DB host for a Sql Server 2005 install that is used on a website. I saw that for all three drives on the machine (one for system/program files, one for data and one for logs) the Indexing Service was turned ON.
In my experience (mostly with desktop, not server setups), the performance hit of the indexing service doing its job has always cost much more in terms of performance than any speed gains in finding files (for me, turning it off has always resulted in a big performance gain).
So is there any reason why this should be turned on for a Sql Server Box (or any server, for that matter)? Assume that no tables use Full Text Indexing (would that make a difference)?