From: Mike '/m' 


Frightening, eh?

  :-)

 /m

On Tue, 21 Jun 2005 21:11:34 -0700, Ellen K.  wrote:

>Yikes, we agree again!!!
>
>
>
>On Sun, 19 Jun 2005 09:36:21 -0400, Mike '/m'  wrote in
>message :
>
>>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