Re: Opinions on SAME?

From: Thanassis Stathopoulos <thstath_at_attglobal.net>
Date: Sun, 22 Apr 2001 15:45:47 +0300
Message-ID: <9bujup$sq0$1@usenet.otenet.gr>

Jonathan,

Is there a relatively-safe rule of thumb as to what's the *minimum* disk count where the redo logs should get their own disk pair? I'm thinking in terms of OLTP-centric systems with 8 to 10 disk drives, offering twice the expected database space, a dual-channel controller with mirrors split across the channels and battery-backed up controller RAM.
Should this be 6+2, 8+2 or is it that at these counts the striping benefits still outweigh the separate redo log benefits?

By the way, great book.

Thanks,
Thanassis Received on Sun Apr 22 2001 - 07:45:47 CDT