24th June 17:39
RAID5 Data disk and Mirrored Controller disks -- Best Practices?
Good. You know what is "advisable." Unfortunately we cannot always work
with systems that are configured as we would like them...
How many databases do you have?
How big do you expect the log files to be?
How big is your OS volume?
If you only have two arrays to work with I would be tempted to put (leave)
tempdb on the OS volume.
Put the databases and logs on the RAID 5 volume.
Leave the page file alone. SQL Server doesn't (shouldn't) use it.
I might catch some flak for that recommendation, but here is why I made the
recommendation that I did:
- You are doing more reads that writes so you will not take too much of a
write penalty by having your data and logs on the same volume.
- If you put the logs on the OS partition and did not monitor their growth
they could fill up the volume (depending on what types of actions you do
within the database). I would rather fill up a non-OS partition