Whoa. This is a cool paper.
- Database Maintenance for Microsoft® SharePoint® Products and Technologies
http://go.microsoft.com/fwlink/?LinkId=111531&clcid=0x409
I only found it because of this blog article, “SQL Index defrag and maintenance tasks for Search” that goes over various tasks to keep Sharepoint Server 2007 moving.
My goal for this was to follow the recommended SQL guidelines while minimizing the impact that these maintenance jobs have on Crawling and Queries. We know from the SQL Monitoring an I/O post that Search is extremely I/O intensive . As it turns out so is all of the regular maintenance that SQL recommends, so finding the right balance between the two is an interesting scheduling task.
…
Honestly, this is all database stuff that’s over my head but I assume that you Sharepoit & SQL Admins know what to do with this information. And there’s a lot of it.
Kurt Shintaku's Blog 