Hi Guys,
I am confused with placing data file , log file and temp file
When I did browsing , I found some articles saying it is best to place those files in 3 different drives as it will improve performance , but other article told me to put them together in 1 drive as it will reduce the failure rate of each volume ( less drive to be maintained )
Is your SQL Server using directly attached storage or is it using a SAN? If you use a SAN then any separate "drives" your server sees may just be logical drives carved out of the same physical array of disks, so it doesn't really matter then. I suppose to answer your other questions, it depends on the RAID level the disk array is setup with, and what you mean by "it blows up" as to what the effects will be.
Thanks for the reply
I just found out from my sys admin , it is using SAN ,and if the drive is down ,SAN will automatic point other drive to get up and perform
Related Temp files , will performance gets better if i put it on dedicated drive ?