SQL Server 2005 Performance optimiztion

ITKE

1068105 pts.

Tags:

Microsoft Windows Server 2003

SQL 2005

SQL Server 2005

SQL Server performance

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 Last updated: December 4, 2009 4:47 PM

Answer Wiki

Last updated: December 3, 2009 10:14 PM GMT

Denny Cherry68,390 pts.
History
Contributors
- Ordered by most recent
- Denny Cherry68,390 pts.

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1 Reply

Kccrosser Dec 4, 2009 4:47 PM GMT

MrDenny - why the comment "SSRS won't ever fly."? We use SSRS very successfully against large databases.

3,830 pointsBadges:

report