Within a single server TFS installation; application tier and data tier on a single server, how does SQL 2005's physical db storage design guidelines affect Team Foundation Server's performance?
In the below referenced article Microsoft gives the following recommendations for SQL 2005 servers:
RAID1 - Recommended use: Good for data that requires high fault tolerance at relatively low hardware cost (redundancy using parity requires more expensive hardware). Best for log files
RAID5 - Recommended use: Very good for Read only data.
RAID10 - Recommended use: Data requiring high performance for both read and write and excellent reliability while trading off storage efficiency and cost.
So, how I/O intensive are the needs of TFS for use at the team level supporting 50 to 100 users?