March 13, 2007 at 8:34 am
as far as i know, raid systems are completely transparent to SQL derver. if this is true, and all sql server will see is the volume of the raid system, is it possible to say which drive in the raid configuration which file will go on , or is this all handled by sql server internally?
March 13, 2007 at 9:40 pm
You are correct in that SQL Server has no information about where the files reside, be it single disk, RAID, etc.
As for the question:
>is it possible to say which drive in the raid configuration which file will go on , or is this all handled by sql server internally?
If your raid configuration is working, then the file will spread across all of the drives in the container/aggregate. If it's anything but RAID 0 (I prefer 'AID 0'), then not olny will the file be spread across all of the disks, but either a complete copy of the file or parity information for it will also be spread across the disks.
-Eddie
Eddie Wuerch
MCM: SQL
March 14, 2007 at 3:48 am
excellent, thanks!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply