Afficher un message
Vieux 09/10/2007, 21h34   #1
lcerni
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut Building New Server - What RAID should be used and how to divide t

Building New Server - What RAID should be used and how to divide the files
among the disk drives?

Ok. I admit I am completely confused. I am being asked to research for a
new server. My manager wants to know how many drives are needed depending on
the RAID. Currently our organization is using RAID-5. However, I am not
sure how to split up the data files and transactional logs.

Should the master, msdb, model data files be on drive e?
Should the master, msdb, model log files be on drive g?
Or should each database data file be on its own drive and each database log
file on another drive?
Or should all the data files be on one drive and the log files on a second
drive?
What about tempdb? Should the tempdb data file be on one drive separate
from the others and its log file on a drive separate from the other log
files? Also I think that I read that tempdb should be on RAID 0; that it can
be on a separate RAID from the other files? Is this true?

This is an example that I have put together. I don't know how correct/not
correct it is though.
c: operating system ?
d: data files for all user databases ?
e: data files for all system databases ?
f: log files for all user databases ?
g: log files for all system databases ?
h: tempdb data file RAID 0
i: tempdb log file RAID 0

He made a remark that he thought that we might need about 16 drives? I am
not sure I understand the relationship between the drives and RAID. I am
wondering if I am misunderstanding him.

How do most people have their servers set up?

Are there recommendations which files should be what RAID?

  Réponse avec citation
 
Page generated in 0,05064 seconds with 9 queries