| Author |
Topic |
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
 Posted - 2005-07-12 : 09:59:54
|
| I have just acquired some new hard discs for my production server so that I can (finally) put the transaction logs onto a seperate physical drive. My question is, what level of RAID is the optimum for storing the transaction logs on and why?thankssteveAlright Brain, you don't like me, and I don't like you. But lets just do this, and I can get back to killing you with beer. |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-07-12 : 10:01:33
|
Now you've gone and done it .... how many opinons do you want?  Kristen |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-07-12 : 10:03:18
|
| I'm not knowledgeable on this, but I think you should Mirror the LOGs. Why=Because its basically write-only, but redundancy is handy to safeguard against hardware failure.A separate SCSI/disk channel/controller would be good too.Kristen |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2005-07-12 : 10:16:01
|
quote:
Now you've gone and done it .... how many opinons do you want?
<Thinks> Tee Hee, wonder how long I can keep this thread going <\Thinks>steveAlright Brain, you don't like me, and I don't like you. But lets just do this, and I can get back to killing you with beer. |
|
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-07-12 : 11:40:28
|
| yeah I thought RAID 1 for t-logs was the general consensus and RAID 5 or 10 for database files.Sean RoussyPlease backup all of your databases including master, msdb and model on a regular basis. I am tired of telling people they are screwed. The job you save may be your own.I am available for consulting work. Just email me through the forum. |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-07-12 : 19:36:25
|
| If you get a LOT of IO on this server, you might want to consider RAID 10 for the transaction logs. It's more expensive, but also faster and more robust than a mirrored set.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2005-07-13 : 03:17:57
|
| Thanks Guys, there isn't a lot of IO, so I figure RAID 1 (assuming I can scrounge two discs and not just one!)steveAlright Brain, you don't like me, and I don't like you. But lets just do this, and I can get back to killing you with beer. |
|
|
|
Frank Kalis
Constraint Violating Yak Guru
413 Posts |
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2005-07-13 : 10:19:23
|
| OK guys, I have two discs so I'm away. It's now given me some more questions though1) Anything to look out for when moving the transaction logs?2) I do local backups which are then copied over the network. Any potential problems with them being done to the mirrored drive in preference to the existing location on the RAID 5?3) I don't know a great deal about filegroups apart from a quick scan in BOL. I was wondering if it may be worth while putting some of the data/indexes onto the mirrored drive. Any suggestions/comments? Would it be preferable to put least used or most used onto there? I have a small number of tables that are used relatively often and a large number that are used relatively rarely. Is it worthwhile moving any of this to the mirrored drive?4) Finally, would there be any benefit to moving the system databases there?Many thanks steveAlright Brain, you don't like me, and I don't like you. But lets just do this, and I can get back to killing you with beer. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-07-13 : 13:59:48
|
| 1) Don't think so. Stop the database maybe? 2) We do ours to the DATA drive, but only because it has more space3) When we moved to have separate drives we just put the NDF on the RAID 1 and the MDF on the RAID 10. Performance is pretty good! Perhaps could be better, but maybe just try the easy route first?4a) When we made the change we split all the databases - NDF on RAID 1, MDF on RAID 10. In fairness it was a new server so we were just CONFIG'ing and RESTORE'ing onto it, so that may be easier than "upgrading"4b) Have you got enough RAM? Most bang-for-buck there I reckonKristen |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2005-07-14 : 03:14:09
|
Actually the RAM point is a very good one (and the one about a seperate controller). The discs I have acquired are from a perfectly good server that was being replaced. There may well be some RAM or a disc contorller in it too that I can cadge recycle in an enviromentally friendly waycheers for the commentssteveAlright Brain, you don't like me, and I don't like you. But lets just do this, and I can get back to killing you with beer. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-07-14 : 11:37:35
|
| enviromentally friendly way = "Get your mits off" I suppose?! |
|
|
|
|
RAIDED