Post reply

Indexes data file

  • December 22, 2010 at 1:36 pm

    #242668

    Hi,

    I have a disk array of 1TB where my databases are sitting. As of now each database have 1 data file and 1 log file.

    I am wondering if I should/must create a new data file and move all indexes of that database on that new file even if I have only 1 disk array (raid 10). Will this improve the performance of my SQL server even if I have only one controller?

    Thanks,

  • December 22, 2010 at 3:51 pm

    #1265729

    Unless you create a new filegroup and file, you cannot move the data to the new file.

  • December 22, 2010 at 4:08 pm

    #1265734

    Thanks willtwc.

    But if it's on the same RAID10, will I see performance improvement by doing this? I was told that If I create a new datafile (& Filegroup), they need to be on a different RAID10, is it true?

  • December 22, 2010 at 4:54 pm

    #1265743

    if you have only 1 disk array, it will not make much difference. Separating the data to a different array will help performance.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply