From: Ellen K. 

There's already more writing going on there.   The idea is to get
writing away from the disks with the data and the transaction log.

On Mon, 27 Jan 2003 08:32:11 +0000, Chris Robinson
 wrote in message
:

>Just a quick thought here:  If your reason for putting the swap file on the
>solo drive was performance, why don't you put it on the RAID5 array?  or is
>this something to do with some SQL thing (I've never used SQL server)?
>
>Chris.
>
>"Ellen K." wrote:
>
>> This question might be a little weird.   (OK, weirder than usual. 
)
>>
>> Background:   I configured the box for our phone recordings database as
>> follows:
>>
>> 3 drives in a RAID 5 array -- SQL Server and data
>> 2 drives in a RAID 1 array -- OS on "C", transaction log
on "D"
>> 1 solo drive -- nonclustered indexes
>>
>> For performance reasons I wanted the swap file to be on the solo drive.
>> I was able to create one there, no problem.   However, according to some
>> message boxes etc apparently I *HAVE* to have one on C if I want to
>> capture dumps in case of crashes.   Is there any way I can make the one
>> on C *ONLY* be used for that purpose, and use the one on the solo drive
>> for normal swapping?

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