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
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!