jonalberghini (5/1/2012)
In my situation I have a table that is partitioned into 12 partitions. So I have different file for each portioned group on the same lun going to the 5 disk stripped set. Would it make more sense to break it up into 12 logical luns. Would SQl server and Windows Server access faster because my SASS channel is 6g and I am only utilizing up to 1g (in monitoring it). This is a read only Data set.
If you have 1 5-disk stripe with no redundancy at all I doubt your partitioning is gaining you anything. You are likely hitting your max reads on the disks as is. The stripe set can only operate 1 read at a time. You will have no parallel reads occurring. I would suggest you have separate stripe sets at that point to allow for parallel access, but that would depend on if the controller and pathing you use would also allow for the parallel access.