Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
CSK
Constraint Violating Yak Guru
489 Posts |
 Posted - 2006-06-06 : 02:12:58
|
| Hi Gurus,Can anybody help me How can implement the raid levels in SQL 2000ThanksKK |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-06-06 : 03:25:59
|
| SQL doesn't implement RAID levels. you Implement RAID at the OS or at the hardware level.I'm a little confused by your question though. Are you setting up a new server and need advice on what drive letters and RAID settings you should use?-ec |
 |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2006-06-06 : 03:45:23
|
| Generally something of a bone of contention is this.I'd suggest to you as a starting point -OS - mirrored pairsql data - raid 5 (or better if you can throw money at it)sql logs - mirrored (or 1 + 0 if you can't find a disk big enough)Then consider what you want to do with backups and tempdb. Use as many seperate controllers as you can for maximum benefit. Do not locate sql stuff on the same physical disks as the OS.But it all depends on what you're doing, size of app, etc.-------Moo. :) |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-06-06 : 04:00:41
|
| "sql data - raid 5 (or better if you can throw money at it)"Just to note here my experience with RAID5 which trashed the database when a drive went down - which I was not expecting could happen with RAID5 but now realise its actually sufficiently likely to need to be considered.Side point: On RAID1+0 if O/S writes to first drive [in a pair] and the drive fails at that point can I presume that O/S will carry on to do the write to the second drive?That's clearly what went wrong with our RAID5 - the write to all N-disks was in progress, Drive-M failed halfway through, the drive was [correctly] taken off line but the rest of the drives then delivered a torn-page error due to the write not having been completed. If all RAID5 is like that it seems a waste of time. Something should have triggered a re-write under those circumstances [which would have succeeded as the duff-drive would be off-line by then]"sql logs - mirrored (or 1 + 0 if you can't find a disk big enough)"I'd add to "if you can't find a disk big enough" that you can get more performance from RAID1+0 too, if that's important.Kristen |
|
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
Posted - 2006-06-06 : 05:51:10
|
| Thanks Guys |
|
|
|
|
|
|
Raid