Home > IT Answers > SQL Server > SQL Server 2005 Performance optimiztion
ITKE
16,755 pts.
 SQL Server 2005 Performance optimiztion
SQL 2005 Reporting Services, SQL Server 2005, SQL Server performance, Windows Server 2003
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. Disk configuration: 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
ASKED: December 3, 2009  4:24 PM
UPDATED: December 4, 2009  4:47 PM
RELATED QUESTIONS
Answer Wiki:
How big are your databases? First SSRS won't ever fly. Generating the reports takes a lot of time, especially with a lot of data. Do you only have a single dual core CPU? If so 1-2 files per filegroup is fine. Same for tempdb.
Last Wiki Answer Submitted:  December 3, 2009  10:14 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

MrDenny – why the comment “SSRS won’t ever fly.”? We use SSRS very successfully against large databases.

Kccrosser
 3,830 pts.