none
Index File group on same drive as data files RRS feed

  • Question

  • I've just found a file group used for indexes on the same drive as the data files.

    Am i correct in saying there is little benefit to this. The index file group should be on it's own spindle?


    Mr Shaw... One day I might know a thing or two about SQL Server!

    Friday, February 27, 2015 3:13 PM

Answers

  • Definitely there will be performance gain provided you are querying for related data which as references index on those index filegroups.

    It helps in parallel processing , having data and index on multiple disk heads helps in reading the data parallel. For more information you can refer the below link

    https://technet.microsoft.com/en-us/library/ms190433%28v=sql.105%29.aspx

    --Prashanth

    • Marked as answer by Mr Shaw Friday, February 27, 2015 3:56 PM
    Friday, February 27, 2015 3:21 PM