I have the following setup, would like to know what's best for log files, data files, indexes, tempdb files.
Also, since the server is used solely for SQL 2005 Reporting Services, how many tempdb data files and tempdb log files
should I create, also how many userdb data files and userdb log files. Want to make reports fly.
C: (135GB), RAID 1 - Operating System.
D: (1.35TB), RAID 5 - SQL Data files.
E: (556GB) RAID 5 - SQL Log files.
G: (999GB) RAID 5 (on SAN) - SQL Index files.
MEMORY = 8GB DDR2, Processor = Intel Xeon Dual 3.60GHz.
Windows Server 2003 Enterprise, SQL Server 2005 Enterprise Edition
Software/Hardware used: SQL Server 2005, Windows Server 2003