SQL Server Performance Forum – Threads Archive

Clean Install..

Hi, we are adding disk and freshly installing SQL/OS and converting to RAID 10. My question is, I would like to utilize the exisiting disk because that is now going to be on its own SCSI channel. What would be best:
1) Put the transaction logs on the existing drive, that is alread in place, and put the DB on the newly created volume..? (Breaking them apart and onto seperate channels.) 2) put master/tempdb onto the existing volume, to break it off from the main channel, and get some traffic off of it.. 3) or do something different…???? -David Roesch
San Diego, Ca

---

Check this link http://www.sql-server-performance.com/sql_server_performance_audit3.asp which covers most of the information required. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

---

I would go with your first option, putting Tlogs on the existing drive. As Tlogs acess the disk sequentially, it is better to dedicate the disk for Tlogs, which gives better performance with Updates, inserts Or anything that acceses Tlogs.

---

Thank you for all that info.. I will go that route.. <img src=’/community/emoticons/emotion-1.gif’ alt=’‘ /><br /><br />-David Roesch<br />San Diego, Ca

---

]]>