Mombu the Microsoft Forum sponsored links

Go Back   Mombu the Microsoft Forum > Microsoft > RAID5 Data disk and Mirrored Controller disks -- Best Practices?
User Name
Password
REGISTER NOW! Mark Forums Read

sponsored links


Reply
 
1 24th June 17:39
keith kratochvil
External User
 
Posts: 1
Default 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


--
Keith Kratochvil
  Reply With Quote


  sponsored links


Reply


Thread Tools
Display Modes




Copyright © 2006 SmartyDevil.com - Dies Mies Jeschet Boenedoesef Douvema Enitemaus -
666