SQL Server Performance Forum – Threads Archive
Rebuilding SQL server – options for data and logs
IF poss please move to the hardware forum – posting error [<img src=’/community/emoticons/emotion-5.gif’ alt=’![Wink ;) ;)](styles/default/xenforo/smilies/wink.png)
If you can’t buy more disks, I’d put the OS and Logs on the Raid 1 mirror and put the data on Raid 5. If poss buy 2 more disks so you can add another mirror and keep the logs separate from the OS. Tom Pullen
DBA, Oxfam GB
I agree with Thomas on this. That 3 disk RAID 5 array will never perform well though. The company needs to choke up some money if they really need a big performance increase on disk IO. MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.
I have found a bunch of 36GB SCSI discs – 6 in total. I am thinking of proposing that they buy an external disc enclosure, stick the databases on that and move two of the discs from the server into the enclosure for RAID-1 logs. Seem reasonable enough? The server is running 4 instances of SQL at the moment – I might try and cut that down a bit by moving development to a pc as they don’t really need it. To me this seems a good solution giving space to grow by adding more discs.
Just makes sure you have a good enclosure. It sounds like a good solution though without spending a lot of money. Most enclosures will support 14 or 15 drices. Getting rid of instances will always help because you won’t have disk contention with the multipls tempdb databases, etc and you have more memory resources free. MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.
]]>