tempdb data files and transaction logs on the fastest disks
Content database data files
Search databases, except for the Search administration database
Content database transaction log files
* updated the post as per the guidance from the technet article http://technet.microsoft.com/en-us/library/cc298801.aspx (Storage and SQL Server capacity planning and configuration)
"Do not enable auto-create statistics on a SQL Server that is supporting SharePoint Server."
I don't understand this point. That is enabled by database, not server. Also, doesn't SharePoint set that by database when it creates them?
Yes, true, this is a database-level option, and it can be set on an index-level as well, and what is meant here is: don't enable auto-create statistics for SharePoint databases, I guess. I went through the list of SharePoint databases for a basic installation and found out that some databases have the option set to True by default and some to False. As per the guidance, what I would do is set this option to False for all SharePoint databases (Service Applications, Content, and Admin) - I believe that the purpose of this is to leave SharePoint manage the statistics on its own - and this is a guess as well. The source of the recommended practice is the technet article technet.microsoft.com/.../hh292622.aspx