Re: How would you layout the files?

From: Nuno Souto <>
Date: Tue, 09 Dec 2008 20:27:32 +1100
Message-ID: <>

Greg Rahn wrote,on my timestamp of 9/12/2008 9:35 AM:
> SAME - stripe and mirror everything.
> Redo and Data should be fine together. In fact, with only 4 spindles
> available for the db, I wouldn't have it any other way. RAID-10 the 4
> drives and mount it up as a single volume. Pray for the best.

I'd almost go with this one. With one "but": Create more than one "volume", in fact as many as you have "groups" of storage in the database: redos, undos, temps, data.
And assign each to a drive letter in Windows.

One of the things that most people forget is that Windows has one I/O queue per disk drive letter. You overload a single drive letter queue with all the I/O requests of the db and I can virtually guarantee a slow I/O performance. Windows does not react very well to very large disk request queues.

Nuno Souto
in sunny Sydney, Australia
Received on Tue Dec 09 2008 - 03:27:32 CST

Original text of this message