How does SQL Server Table partitioning get impacted by the DISK RAID level ? We have a SQL Server with 8 data disks . The main table in the database has over 200 million rows partitioned by day of week over 7 disks. In this case , does one need to set up Raid 0 /Raid 5 for optimal read performance or simply because the partitions are on separate disks negate the need for disk striping or there is an optimal RAID setting in this case.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.