From: Mike '/m' 

On Sat, 18 Jun 2005 22:56:57 -0700, Ellen K.  wrote:

> a simple practice of always putting the log on a different array
> from the data already makes a big difference.

Worth highlighting.

If you put the log on the same disk [array] as the data, then you
effectively insert one (possibly two) disk seek times and rotational
latencies into each and every transaction.

I learned of this when I was beta-testing SQL Server 1.0 back in the
'80's.  The Sybase admin who was training us said it was one of his most
important set up guidelines.

  /m

--- BBBS/NT v4.01 Flag-5