SQL Server 2005 Performance optimiztion

344850 pts.
Tags:
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

Answer Wiki

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

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Kccrosser
    MrDenny - why the comment "SSRS won't ever fly."? We use SSRS very successfully against large databases.
    3,830 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following