Solved

SQL Server 2008 installation

Posted on 2011-09-13
3
187 Views
Last Modified: 2012-05-12
Installing MS Sql server 2008. Need advice on the disk partition and how to split up the tempdb, userdb and log files.

I currently have 4 partitions on the server. the C:\ drive has the OS and I don't plan to store anything else there. the D:\ drive would have the SQL server application installed. I would like the optimal performance and would like tempdb and log files separated if that's necessary.

Please advise.
Thanks.
0
Comment
Question by:electric4us
  • 2
3 Comments
 
LVL 13

Accepted Solution

by:
dwkor earned 250 total points
ID: 36533529
Partitions don't really matter. Drives/Raids - are.

Move tempdb to the fastest drive possible.
Move database files to RAID 10 (or 5) if possible - goal is fastest random IO
Move log files to RAID 1 - goal is fast sequential IO with maximum redundancy

Check best practices articles:
http://technet.microsoft.com/en-us/library/cc966412.aspx
http://technet.microsoft.com/en-us/library/cc966534.aspx
0
 

Author Comment

by:electric4us
ID: 36533688
dwkor,
the server has 8 sas drives that is configured with raid 10. the partitions are located there. so are you suggesting I have 2 different configurations with that disk set? raid 10 and 1?
0
 
LVL 13

Assisted Solution

by:dwkor
dwkor earned 250 total points
ID: 36535928
In such case put data files to Raid 10 and log files to Raid 1. You can keep log files on Raid 10 but Raid 1 would work just fine (again - log requires sequential access only)

Optionally you can put tempdb to another partition - even Raid-0. If you don't want to configure it, split it between Raid 10 and raid 1. TempDb is not critical for recovery process - SQL Server recreates it every time on startup but you'd like to have fastest IO throughput for tempdb as possible. Take a look at best tempdb practices as well - http://blogs.msdn.com/b/cindygross/archive/2009/11/20/compilation-of-sql-server-tempdb-io-best-practices.aspx
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question