Partitioning table

Last Post 12 May 2009 07:22 AM by timcronin. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
timcronin
New Member
New Member

--
12 May 2009 07:22 AM
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?
You are not authorized to post a reply.

Acceptable Use Policy