January 24, 2006 at 8:03 am
We are on a SAN with RAID5 spread across all disks. Each LUN rests across all the physical disks in the SAN.
Therefore, is there any performance benefit to have different tables in different filegroups and hence each filegroup in different LUNS if in essence each LUN is going to be spread across all disks in the SAN?
Thank you very much for taking the time to read this question.
January 24, 2006 at 8:10 am
I believe that each filegroup gets assigned its own thread so the only benefit you will get will be from whatever using separate threads gives you.
January 24, 2006 at 9:21 am
There also might be some benefit to backup/restore operations if the database is large.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
January 24, 2006 at 10:05 am
Thank you very much to both of you for your replies. I just wanted to make sure that I am not missing something trivial.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply