I have a 3rd party app with several tables which are 7-14 million rows. Presently i have the data on a RAID 10, log files on a RAID 10, tempdb on it's own , and indexes on their own RAID 10. I was looking at partitioning some of the million row tables. The problem is there is no separate array to put them on. If i put the partitioned table on the array with the data, would I actaully gain anything
I believe you should get some performance benifit for sure even if you you are using the same disk set...