I am in the midst of configuring our new database servers and I am curious about how to place tempdb's files. We have seperate arrays for data, logs, backup and tempdb. My question is should I put tempdb's log file with the logs or with tempdb data? According to SQL Server this is our read/write ratios: Data: 92% read / 8% write Log: 13% read / 87% write Tempdb data: 35% read / 65% write Tempdb log: 5% read / 95% write Based on that I thought perhaps we could put the tempdb log with the rest of the logs. Also, would you configure your array controller cache settings with regards to the ratio or read/write to match the ratios above?
That is why I asked. I suggest to put log in the same place than data (tempdb), but 4 in one array and 4 in other.
