SQL Server 2005 Performance optimiztion

1152335 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: Last updated:
Related Questions
1

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.
  • 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.

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

Following

Share this item with your network: