Home Forums SQL Server 2008 SQL Server 2008 Administration Proper way to move data in large filegroup using DBCC SHRINKFILE emptyfile option RE: Proper way to move data in large filegroup using DBCC SHRINKFILE emptyfile option

  • May 1, 2013 at 3:52 am

    #1611513

    Isabelle2378 (4/30/2013)

    Hi,

    I have a filegroup with one large datafile that is 300GB and I want to create 10- 30GB files and spread the data across them for better performance.

    Since you're apparently splitting for performance, have you checked and confirmed that the database really is bottlenecked on IO? Are all 10 of those file on separate IO paths (separate physical drives at the very least)?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass