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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-09-21 : 22:42:29
|
| Morrisos writes "Hello,Does anyone have advice on how to best install SQL Server2000 on a HP DL580, single controller with RAID5 3-300 GB disks? In the past I have left the OS on C: and created a D: for just SQL Server. I am wondering if it really matters since this box has only one controller.THanks,Morrisos" |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-09-21 : 22:59:08
|
| Replace the controller that comes with the server. It's a piece of crap. If you don't need much performance (because you're not going to get it with three disks), then it shouldn't matter too much. From a management and standards perspective, I would leave the D: drive for SQL Server though. Why did you buy THREE disks???? The DL580 can have four.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2005-09-22 : 10:40:00
|
| 3 300GB disks?? The rebuild time on that array is going to be FOREVER!!!!I would have gotten four smaller disks like Derrick reccomends.Spindles == speedTo answer your question, a 5-10GB partition C: for the OS, and then a D: for everything else. Since it's really one big drive anyway, it probably doesn't matter too much, but I'd go ahead and separate it. If you ever grow into a larger array, you can move things around a bit easier if it's not one big drive.Michael<Yoda>Use the Search page you must. Find the answer you will. Cursors, path to the Dark Side they are. Avoid them, you must. Use Order By NewID() to get a random record you will.</Yoda> |
|
|
|
|
|
|
|
|
Installation Best Practices- Disk Partitioning