Pagefile and log file location question

[BobSchleicher]

I have a 6 hardrives on my server and the raid array is broken up like this:

0,1 = raid1
2 = raid0
3,4,5 = raid5

I am reading that the pagefile on a dedicated SQL server rarely gets used so keep the pagefile on the boot drive and put the log files on a dedicated hard drive.

But what I have always practiced is putting the pagefile on it's own hard drive.

So which configuration makes more sense?

0,1 = Boot Drive (raid1)
2 = Pagefile (raid0)
3,4,5 = Data files/Log files (raid5)

0,1 = Boot Drive/Pagefile (raid1)
2 = Log files (raid0)
3,4,5 = Data files (raid5)

0,1 = Boot Drive (raid1)
2 = Log files/Pagefile (raid0)
3,4,5 = Data files (raid5)

Thanks for your thoughts.

BobSchleicher

 

[mrdenny]

See my post in your other thread in the Windows 2003 forum.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com