SQL Server Performance

table partition

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by timscronin, May 12, 2009.

  1. timscronin New Member

    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
  2. MohammedU New Member

    I believe you should get some performance benifit for sure even if you you are using the same disk set...

Share This Page