Home Forums SQL Server 2014 Administration - SQL Server 2014 Creating additional data file for a particular file group - Anything needs to be checked out? RE: Creating additional data file for a particular file group - Anything needs to be checked out?

  • SQL!$@w$0ME (7/6/2015)


    This particular db is almost 450gb in size.

    So a fairly small database still.

    SQL data files max out at 16 TB, not a few GB. You split across drives (separate IO paths) if you're having IO contention or have inadequate IO throughput, not because the file has reached some arbitrary (smallish) size.

    And if you are splitting for IO load purposes, adding a new file is the worst thing you could do, as due to proportional fill, all writes would go to the new file initially.

    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